All Packages from org.apache.cocoon.poi.hssf.* to org.apache.cocoon.poi.util.*

Home >> All >> org >> apache >> cocoon >> poi

•

Package Samples:

• org.apache.cocoon.poi.hssf.dev
• org.apache.cocoon.poi.hssf
• org.apache.cocoon.poi.hssf.model
• org.apache.cocoon.poi.hssf.record.formula
• org.apache.cocoon.poi.hssf.record
• org.apache.cocoon.poi.hssf.usermodel
• org.apache.cocoon.poi.poifs.common
• org.apache.cocoon.poi.poifs.filesystem
• org.apache.cocoon.poi.poifs.property
• org.apache.cocoon.poi.poifs.storage
• org.apache.cocoon.poi.util

Classes:

• HSSFDataFormat: Utility to identify builin formats. The following is a list of the formats as returned by this class. 0, "General" 1, "0" 2, "0.00" 3, "#,##0" 4, "#,##0.00" 5, "($#,##0_);($#,##0)" 6, "($#,##0_);[Red]($#,##0)" 7, "($#,##0.00);($#,##0.00)" 8, "($#,##0.00_);[Red]($#,##0.00)" 9, "0%" 0xa, "0.00%" 0xb, "0.00E+00" 0xc, "# ?/?" 0xd, "# ??/??" 0xe, "m/d/yy" 0xf, "d-mmm-yy" 0x10, "d-mmm" 0x11, "mmm-yy" 0x12, "h:mm AM/PM" 0x13, "h:mm:ss AM/PM" 0x14, "h:mm" 0x15, "h:mm:ss" 0x16, "m/d/yy h:mm" // 0x17 - 0x24 reserved for international and undocumented 0x25, "(#,##0_);(#,##0)" 0x26, "(#,##0_);[Red](#,##0)" ...
• Workbook: Workbook Low level model implementation of a Workbook. Provides creational methods for settings and objects contained in the workbook object. This file contains the low level binary records starting at the workbook's BOF and ending with the workbook's EOF. Use HSSFWorkbook for a high level representation. The structures of the highlevel API use references to this to perform most of their operations. Its probably unwise to use these low level structures directly unless you really know what you're doing. I recommend you read the Microsoft Excel 97 Developer's Kit (Microsoft Press) and the documentation ...
• ShortList: A List of short's; as full an implementation of the java.util.List interface as possible, with an eye toward minimal creation of objects the mimicry of List is as follows: if possible, operations designated 'optional' in the List interface are attempted wherever the List interface refers to an Object, substitute short wherever the List interface refers to a Collection or List, substitute ShortList the mimicry is not perfect, however: operations involving Iterators or ListIterators are not supported remove(Object) becomes removeValue to distinguish it from remove(short index) subList is not sup ...
• IntList: A List of int's; as full an implementation of the java.util.List interface as possible, with an eye toward minimal creation of objects the mimicry of List is as follows: if possible, operations designated 'optional' in the List interface are attempted wherever the List interface refers to an Object, substitute int wherever the List interface refers to a Collection or List, substitute IntList the mimicry is not perfect, however: operations involving Iterators or ListIterators are not supported remove(Object) becomes removeValue to distinguish it from remove(int index) subList is not supported
• RKRecord: Title: RK Record Description: An internal 32 bit number with the two most significant bits storing the type. This is part of a bizarre scheme to save disk space and memory (gee look at all the other whole records that are in the file just "cause"..,far better to waste processor cycles on this then leave on of those "valuable" records out). We support this in READ-ONLY mode. HSSF converts these to NUMBER records Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 376 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• Sheet: Low level model implementation of a Sheet (one workbook contains many sheets) This file contains the low level binary records starting at the sheets BOF and ending with the sheets EOF. Use HSSFSheet for a high level representation. The structures of the highlevel API use references to this to perform most of their operations. Its probably unwise to use these low level structures directly unless you really know what you're doing. I recommend you read the Microsoft Excel 97 Developer's Kit (Microsoft Press) and the documentation at http://sc.openoffice.org/excelfileformat.pdf before even attempting ...
• HSSFCell: High level representation of a cell in a row of a spreadsheet. Cells can be numeric, formula-based or string-based (text). The cell type specifies this. String cells cannot conatin numbers and numeric cells cannot contain strings (at least according to our model). Client apps should do the conversions themselves. Formula cells are treated like string cells, simply containing a formula string. They'll be rendered differently. Cells should have their number (0 based) before being added to a row. Only cells that have values should be added. NOTE: the alpha won't be implementing formulas
• ExtendedFormatRecord: Title: Extended Format Record Description: Probably one of the more complex records. There are two breeds: Style and Cell. It should be noted that fields in the extended format record are somewhat arbitrary. Almost all of the fields are bit-level, but we name them as best as possible by functional group. In some places this is better than others. Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 426 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• CalcCountRecord: Title: Calc Count Record Description: Specifies the maximum times the gui should perform a formula recalculation. For instance: in the case a formula includes cells that are themselves a result of a formula and a value changes. This is essentially a failsafe against an infinate loop in the event the formulas are not independant. Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 292 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• BlockAllocationTable: This class manages and creates the Block Allocation Table, which is basically a set of linked lists of block indices. Each block of the filesystem has an index. The first block, the header, is skipped; the first block after the header is index 0, the next is index 1, and so on. A block's index is also its index into the Block Allocation Table. The entry that it finds in the Block Allocation Table is the index of the next block in the linked list of blocks making up a file, or it is set to -2: end of list.
• ExtSSTRecord: Title: Extended Static String Table Description: I really don't understand this thing... its supposed to be "a hash table for optimizing external copy operations" -- This sounds like a job for Marc "BitMaster" Johnson aka the "Hawaiian Master Chef". Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 313 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• ProtectRecord: Title: Protect Record Description: defines whether a sheet or workbook is protected (HSSF DOES NOT SUPPORT ENCRYPTION) (kindly ask the US government to stop having arcane stupid encryption laws and we'll support it) (after all terrorists will all use US-legal encrypton right??) Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 373 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• MulBlankRecord: Title: Mulitple Blank cell record Description: Represents a set of columns in a row with no value but with styling. In this release we have read-only support for this record type. The RecordFactory converts this to a set of BlankRecord objects. Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 329 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• IterationRecord: Title: Iteration Record Description: Tells whether to iterate over forumla calculations or not (if a formula is dependant upon another formula's result) (odd feature for something that can only have 32 elements in a formula!) Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 325 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• UnicodeString: Title: Unicode String Description: Unicode String record. We implement these as a record, although they are really just standard fields that are in several records. It is considered more desirable then repeating it in all of them. Copyright: Copyright (c) 2001 SuperLink Software, Inc REFERENCE: PG 264 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• BoundSheetRecord: Title: Bound Sheet Record (aka BundleSheet) Description: Defines a sheet within a workbook. Basically stores the sheetname and tells where the Beginning of file record is within the HSSF file. Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 291 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• WriteAccessRecord: Title: Write Access Record Description: Stores the username of that who owns the spreadsheet generator (on unix the user's login, on Windoze its the name you typed when you installed the thing) Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 424 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• PropertyFactory: Factory for turning an array of RawDataBlock instances containing Proprty data into an array of proper Property objects. The array produced may be sparse, in that any portion of data that should correspond to a Property, but which does not map to a proper Property (i.e., a DirectoryProperty, DocumentProperty, or RootProperty) will get mapped to a null Property in the array.
• WindowOneRecord: Title: Window1 Record Description: Stores the attributes of the workbook window. This is basically so the gui knows how big to make the window holding the spreadsheet document. Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 421 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• UnknownRecord: Title: Unknown Record (for debugging) Description: Unknown record just tells you the sid so you can figure out what records you are missing. Also helps us read/modify sheets we don't know all the records to. (HSSF leaves these alone!) Copyright: Copyright (c) 2001 Company: SuperLink Software, Inc.
• PrecisionRecord: Title: Precision Record Description: defines whether to store with full precision or what's displayed by the gui (meaning have really screwed up and skewed figures or only think you do!) Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 372 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• BOFRecord: Title: Beginning Of File Description: Somewhat of a misnomer, its used for the beginning of a set of records that have a particular pupose or subject. Used in sheets and workbooks. Copyright: Copyright (c) 2001 SuperLinkSoftware, Inc. REFERENCE: PG 289 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• CountryRecord: Title: Country Record (aka WIN.INI country) Description: used for localization. Currently HSSF always sets this to 1 and it seems to work fine even in Germany. (es geht's auch fuer Deutschland) Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 298 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• ProtectionRev4Record: Title: Protection Revision 4 Record Description: describes whether this is a protected shared/tracked workbook ( HSSF does not support encryption because we don't feel like going to jail ) Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 373 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• DSFRecord: Title: Double Stream Flag Record Description: tells if this is a double stream file. (always no for HSSF generated files) Double Stream files contain both BIFF8 and BIFF7 workbooks. Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 305 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)

Home | Contact Us | Privacy Policy | Terms of Service