| Home >> All >> org >> apache >> cocoon >> poi >> [ hssf Javadoc ] |
• org.apache.cocoon.poi.hssf: Javadoc index of package org.apache.cocoon.poi.hssf.
Package Samples:
• org.apache.cocoon.poi.hssf.dev
• 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
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 ...
• 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)
• 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)
• 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)
• IndexRecord: Title: Index Record Description: Occurs right after BOF, tells you where the DBCELL records are for a sheet Important for locating cells NOT USED IN THIS RELEASE Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 323 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• BookBoolRecord: Title: Save External Links record (BookBool) Description: Contains a flag specifying whether the Gui should save externally linked values from other workbooks. Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 289 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• RefreshAllRecord: Title: Refresh All Record Description: Flag whether to refresh all external data when loading a sheet. (which hssf doesn't support anyhow so who really cares?) Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 376 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
• CalcModeRecord: Title: Calc Mode Record Description: Tells the gui whether to calculate formulas automatically, manually or automatically except for tables. Copyright: Copyright (c) 2001 SuperLink Software, Inc. REFERENCE: PG 292 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
| Home | Contact Us | Privacy Policy | Terms of Service |