|
||||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |
See:
Description
Interface Summary | |
---|---|
BiffHeaderInput | |
CellValueRecordInterface | The cell value record interface is implemented by all classes of type Record that contain cell values. |
Margin | The margin interface is a parent used to define left, right, top and bottom margins. |
Class Summary | |
---|---|
AbstractEscherHolderRecord | The escher container record is used to hold escher records. |
ArrayRecord | ARRAY (0x0221) Treated in a similar way to SharedFormulaRecord |
AutoFilterInfoRecord | The AutoFilterInfo record specifies the number of columns that have AutoFilter enabled and indicates the beginning of the collection of AutoFilter records. |
BackupRecord | Title: Backup Record Description: Boolean specifying whether the GUI should store a backup of the file. |
BlankRecord | Title: Blank cell record (0x0201) Description: Represents a column in a row with no value but with styling. |
BOFRecord | Title: Beginning Of File (0x0809) Description: Somewhat of a misnomer, its used for the beginning of a set of records that have a particular purpose or subject. |
BookBoolRecord | Title: Save External Links record (BookBool) Description: Contains a flag specifying whether the Gui should save externally linked values from other workbooks. |
BoolErrRecord | Creates new BoolErrRecord. (0x0205) REFERENCE: PG ??? |
BottomMarginRecord | Record for the bottom margin. |
BoundSheetRecord | Title: Bound Sheet Record (aka BundleSheet) (0x0085) Description: Defines a sheet within a workbook. |
CalcCountRecord | Title: Calc Count Record Description: Specifies the maximum times the gui should perform a formula recalculation. |
CalcModeRecord | Title: Calc Mode Record Description: Tells the gui whether to calculate formulas automatically, manually or automatically except for tables. |
CellRecord | Base class for all cell value records (implementors of CellValueRecordInterface ). |
CFHeaderRecord | Conditional Formatting Header record CFHEADER (0x01B0) |
CFRuleRecord | Conditional Formatting Rule Record (0x01B1). |
CFRuleRecord.ComparisonOperator | |
CodepageRecord | Title: Codepage Record
Description: the default characterset. for the workbook
REFERENCE: PG 293 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
Use CodePageUtil to turn these values into Java code pages
to encode/decode strings. |
ColumnInfoRecord | Title: COLINFO Record (0x007D) Description: Defines with width and formatting for a range of columns REFERENCE: PG 293 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
CommonObjectDataSubRecord | The common object data record is used to store all common preferences for an excel object. |
ContinueRecord | Title: Continue Record(0x003C) - Helper class used primarily for SST Records Description: handles overflow for prior record in the input stream; content is tailored to that prior record |
CountryRecord | Title: Country Record (aka WIN.INI country) Description: used for localization. |
CRNCountRecord | XCT - CRN Count REFERENCE: 5.114 |
CRNRecord | Title: CRN(0x005A) Description: This record stores the contents of an external cell or cell range REFERENCE: OOO 5.23 |
DateWindow1904Record | Title: Date Window 1904 Flag record Description: Flag specifying whether 1904 date windowing is used. |
DBCellRecord | Title: DBCell Record (0x00D7) Description: Used by Excel and other MS apps to quickly find rows in the sheets. |
DBCellRecord.Builder | |
DConRefRecord | DConRef records specify a range in a workbook (internal or external) that serves as a data source for pivot tables or data consolidation. |
DefaultColWidthRecord | Title: Default Column Width Record (0x0055) Description: Specifies the default width for columns that have no specific width set. |
DefaultRowHeightRecord | Title: Default Row Height Record Description: Row height for rows with undefined or not explicitly defined heights. |
DeltaRecord | Title: Delta Record (0x0010) Description: controls the accuracy of the calculations REFERENCE: PG 303 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
DimensionsRecord | Title: Dimensions Record Description: provides the minumum and maximum bounds of a sheet. |
DrawingGroupRecord | |
DrawingRecord | DrawingRecord (0x00EC) |
DrawingRecordForBiffViewer | This is purely for the biff viewer. |
DrawingSelectionRecord | MsoDrawingSelection (0x00ED) Reference: [MS-OGRAPH].pdf sec 2.4.69 |
DSFRecord | Title: Double Stream Flag Record (0x0161) Description: tells if this is a double stream file. |
DVALRecord | Title: DATAVALIDATIONS Record (0x01B2) Description: used in data validation ; This record is the list header of all data validation records (0x01BE) in the current sheet. |
DVRecord | Title: DATAVALIDATION Record (0x01BE) Description: This record stores data validation settings and a list of cell ranges which contain these settings. |
EmbeddedObjectRefSubRecord | ftPictFmla (0x0009) A sub-record within the OBJ record which stores a reference to an object stored in a separate entry within the OLE2 compound file. |
EndSubRecord | ftEnd (0x0000) The end data record is used to denote the end of the subrecords. |
EOFRecord | End Of File record. |
EscherAggregate | This class is used to aggregate the MSODRAWING and OBJ record combinations. |
ExtendedFormatRecord | Title: Extended Format Record Description: Probably one of the more complex records. |
ExternalNameRecord | EXTERNALNAME (0x0023) |
ExternSheetRecord | EXTERNSHEET (0x0017) A List of Indexes to EXTERNALBOOK (supplemental book) Records |
ExtSSTRecord | Title: Extended Static String Table (0x00FF) Description: This record is used for a quick lookup into the SST record. |
ExtSSTRecord.InfoSubRecord | |
FeatHdrRecord | Title: FeatHdr (Feature Header) Record This record specifies common information for Shared Features, and specifies the beginning of a collection of records to define them. |
FeatRecord | Title: Feat (Feature) Record This record specifies Shared Features data. |
FilePassRecord | Title: File Pass Record (0x002F) Description: Indicates that the record after this record are encrypted. |
FilePassRecord.Rc4KeyData | |
FilePassRecord.XorKeyData | |
FileSharingRecord | Title: FILESHARING (0x005B) Description: stores the encrypted readonly for a workbook (write protect) This functionality is accessed from the options dialog box available when performing 'Save As'. |
FnGroupCountRecord | Title: Function Group Count Record Description: Number of built in function groups in the current version of the Spreadsheet (probably only used on Windoze) REFERENCE: PG 315 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
FontRecord | Title: Font Record (0x0031) - describes a font in the workbook (index = 0-3,5-infinity - skip 4) Description: An element in the Font Table REFERENCE: PG 315 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
FooterRecord | Title: Footer Record (0x0015) Description: Specifies the footer for a sheet REFERENCE: PG 317 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
FormatRecord | Title: Format Record (0x041E) Description: describes a number format -- those goofy strings like $(#,###) REFERENCE: PG 317 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
FormulaRecord | Formula Record (0x0006). |
FtCblsSubRecord | This structure appears as part of an Obj record that represents a checkbox or radio button. |
FtCfSubRecord | The FtCf structure specifies the clipboard format of the picture-type Obj record containing this FtCf. |
FtPioGrbitSubRecord | This structure appears as part of an Obj record that represents image display properties. |
GridsetRecord | Title: Gridset Record. |
GroupMarkerSubRecord | ftGmo (0x0006) The group marker record is used as a position holder for groups. |
GutsRecord | Title: Guts Record Description: Row/column gutter sizes REFERENCE: PG 320 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
HCenterRecord | Title: HCenter record (0x0083) Description: whether to center between horizontal margins REFERENCE: PG 320 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
HeaderFooterBase | Common header/footer base class |
HeaderFooterRecord | The HEADERFOOTER record stores information added in Office Excel 2007 for headers/footers. |
HeaderRecord | Title: Header Record Description: Specifies a header for a sheet REFERENCE: PG 321 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
HideObjRecord | Title: Hide Object Record Description: flag defines whether to hide placeholders and object REFERENCE: PG 321 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
HorizontalPageBreakRecord | HorizontalPageBreak (0x001B) record that stores page breaks at rows |
HyperlinkRecord | The HyperlinkRecord (0x01B8) wraps an HLINK-record
from the Excel-97 format. |
IndexRecord | Title: Index Record (0x020B) Description: Occurs right after BOF, tells you where the DBCELL records are for a sheet Important for locating cells NOT USED IN THIS RELEASE REFERENCE: PG 323 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
InterfaceEndRecord | Title: Interface End Record (0x00E2) Description: Shows where the Interface Records end (MMS) (has no fields) REFERENCE: PG 324 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
InterfaceHdrRecord | Title: Interface Header Record (0x00E1) Description: Defines the beginning of Interface records (MMS) REFERENCE: PG 324 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
IterationRecord | Title: Iteration Record (0x0011) 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!) |
LabelRecord | Label Record (0x0204) - read only support for strings stored directly in the cell.. |
LabelSSTRecord | Title: Label SST Record Description: Refers to a string in the shared string table and is a column value. |
LbsDataSubRecord | This structure specifies the properties of a list or drop-down list embedded object in a sheet. |
LbsDataSubRecord.LbsDropData | This structure specifies properties of the dropdown list control |
LeftMarginRecord | Record for the left margin. |
MergeCellsRecord | Title: Merged Cells Record (0x00E5)
Description: Optional record defining a square area of cells to "merged" into one cell. |
MMSRecord | Title: MMS Record Description: defines how many add menu and del menu options are stored in the file. |
MulBlankRecord | Title: Multiple Blank cell record(0x00BE) Description: Represents a set of columns in a row with no value but with styling. |
MulRKRecord | MULRK (0x00BD) Used to store multiple RK numbers on a row. 1 MulRk = Multiple Cell values. |
NameCommentRecord | Title: NAMECMT Record (0x0894) Description: Defines a comment associated with a specified name. |
NameRecord | Title: DEFINEDNAME Record (0x0018) Description: Defines a named range within a workbook. |
NoteRecord | NOTE: Comment Associated with a Cell (0x001C) |
NoteStructureSubRecord | ftNts (0x000D) Represents a NoteStructure sub record. |
NumberRecord | NUMBER (0x0203) Contains a numeric cell value. |
ObjectProtectRecord | Title: Object Protect Record Description: Protect embedded object with the lamest "security" ever invented. |
ObjRecord | OBJRECORD (0x005D) The obj record is used to hold various graphic objects and controls. |
OldCellRecord | Base class for all old (Biff 2 - Biff 4) cell value records
(implementors of CellValueRecordInterface ). |
OldFormulaRecord | Formula Record (0x0006 / 0x0206 / 0x0406) - holds a formula in encoded form, along with the value if a number |
OldLabelRecord | Biff2 - Biff 4 Label Record (0x0004 / 0x0204) - read only support for
strings stored directly in the cell, from the older file formats that
didn't use LabelSSTRecord |
OldSheetRecord | Title: Bound Sheet Record (aka BundleSheet) (0x0085) for BIFF 5 Description: Defines a sheet within a workbook. |
OldStringRecord | Biff2 - Biff 4 Label Record (0x0007 / 0x0207) - read only support for formula string results. |
PageBreakRecord | Record that contains the functionality page breaks (horizontal and vertical) The other two classes just specifically set the SIDS for record creation. |
PageBreakRecord.Break | Since both records store 2byte integers (short), no point in differentiating it in the records. |
PaletteRecord | PaletteRecord (0x0092) - Supports custom palettes. |
PaneRecord | Describes the frozen and unfozen panes. |
PasswordRecord | Title: Password Record (0x0013) Description: stores the encrypted password for a sheet or workbook (HSSF doesn't support encryption) REFERENCE: PG 371 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
PasswordRev4Record | Title: Protection Revision 4 password Record (0x01BC) Description: Stores the (2 byte??!!) |
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!) |
PrintGridlinesRecord | Title: Print Gridlines Record Description: whether to print the gridlines when you enjoy you spreadsheet on paper. |
PrintHeadersRecord | Title: Print Headers Record Description: Whether or not to print the row/column headers when you enjoy your spreadsheet in the physical form. |
PrintSetupRecord | Title: PAGESETUP (0x00A1) Description: Stores print setup options -- bogus for HSSF (and marked as such) REFERENCE: PG 385 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) REFERENCE: PG 412 Microsoft Excel Binary File Format Structure v20091214 |
ProtectionRev4Record | Title: Protection Revision 4 Record (0x01AF) Description: describes whether this is a protected shared/tracked workbook REFERENCE: PG 373 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
ProtectRecord | Title: Protect Record (0x0012) Description: defines whether a sheet or workbook is protected (HSSF DOES NOT SUPPORT ENCRYPTION) HSSF now supports the simple "protected" sheets (where they are not encrypted and open office et al ignore the password record entirely). |
RecalcIdRecord | Title: Recalc Id Record (0x01C1) Description: This record contains an ID that marks when a worksheet was last recalculated. |
Record | Title: Record Description: All HSSF Records inherit from this class. |
RecordBase | Common base class of Record and RecordAggregate |
RecordFactory | Title: Record Factory Description: Takes a stream and outputs an array of Record objects. |
RecordFactoryInputStream | A stream based way to get at complete records, with as low a memory footprint as possible. |
RecordInputStream | Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records. |
RefModeRecord | Title: RefMode Record Description: Describes which reference mode to use REFERENCE: PG 376 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
RefreshAllRecord | Title: Refresh All Record (0x01B7) Description: Flag whether to refresh all external data when loading a sheet. |
RightMarginRecord | Record for the right margin. |
RKRecord | Title: RK Record (0x027E) Description: An internal 32 bit number with the two most significant bits storing the type. |
RowRecord | Title: Row Record (0x0208) Description: stores the row information for the sheet. |
SaveRecalcRecord | Title: Save Recalc Record Description: defines whether to recalculate before saving (set to true) REFERENCE: PG 381 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
ScenarioProtectRecord | Title: Scenario Protect Record Description: I have no idea what a Scenario is or why on would want to protect it with the lamest "security" ever invented. |
SCLRecord | Specifies the window's zoom magnification. |
SelectionRecord | Title: Selection Record (0x001D) Description: shows the user's selection on the sheet for write set num refs to 0 REFERENCE: PG 291 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
SharedFormulaRecord | Title: SHAREDFMLA (0x04BC) SharedFormulaRecord Description: Primarily used as an excel optimization so that multiple similar formulas are not written out too many times. |
SharedValueRecordBase | Common base class for SharedFormulaRecord , ArrayRecord and
TableRecord which are have similarities. |
SSTRecord | Title: Static String Table Record (0x00FC) Description: This holds all the strings for LabelSSTRecords. |
StandardRecord | Subclasses of this class (the majority of BIFF records) are non-continuable. |
StringRecord | STRING (0x0207) Stores the cached result of a text formula |
StyleRecord | Title: Style Record (0x0293) Description: Describes a builtin to the gui or user defined style REFERENCE: PG 390 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
SubRecord | Subrecords are part of the OBJ class. |
SupBookRecord | Title: Sup Book - EXTERNALBOOK (0x01AE) Description: A External Workbook Description (Supplemental Book) Its only a dummy record for making new ExternSheet Record REFERENCE: 5.38 |
TabIdRecord | Title: Sheet Tab Index Array Record (0x013D) Description: Contains an array of sheet id's. |
TableRecord | DATATABLE (0x0236) TableRecord - The record specifies a data table. |
TableStylesRecord | TABLESTYLES (0x088E) |
TextObjectRecord | The TXO record (0x01B6) is used to define the properties of a text box. |
TopMarginRecord | Record for the top margin. |
UncalcedRecord | Title: Uncalced Record If this record occurs in the Worksheet Substream, it indicates that the formulas have not been recalculated before the document was saved. |
UnicodeString | Deprecated. Use UnicodeString instead |
UnknownRecord | Title: Unknown Record (for debugging) Description: Unknown record just tells you the sid so you can figure out what records you are missing. |
UserSViewBegin | The UserSViewBegin record specifies settings for a custom view associated with the sheet. |
UserSViewEnd | The UserSViewEnd record marks the end of the settings for a custom view associated with the sheet |
UseSelFSRecord | Title: USESELFS (0x0160) - Use Natural Language Formulas Flag Description: Tells the GUI if this was written by something that can use "natural language" formulas. |
VCenterRecord | Title: VCenter record Description: tells whether to center the sheet between vertical margins REFERENCE: PG 420 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
VerticalPageBreakRecord | VerticalPageBreak (0x001A) record that stores page breaks at columns |
WindowOneRecord | Title: Window1 Record Description: Stores the attributes of the workbook window. |
WindowProtectRecord | Title: Window Protect Record (0x0019) Description: flags whether workbook windows are protected REFERENCE: PG 424 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
WindowTwoRecord | Title: Window Two Record Description: sheet window settings REFERENCE: PG 422 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
WriteAccessRecord | Title: Write Access Record (0x005C) 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) REFERENCE: PG 424 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
WriteProtectRecord | Title: Write Protect Record Description: Indicated that the sheet/workbook is write protected. |
WSBoolRecord | Title: WSBOOL (0x0081) (called SHEETPR in OOO doc) Description: stores workbook settings (aka its a big "everything we didn't put somewhere else") REFERENCE: PG 425 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2) |
Exception Summary | |
---|---|
RecordFormatException | Title: Record Format Exception Description: Used by records to indicate invalid format/data. |
RecordInputStream.LeftoverDataException | For use in BiffViewer which may construct Record s that don't completely
read all available data. |
Record package contains class representations for XLS binary strutures. Its very low level.
org.apache.poi.hssf.eventmodel
,
RecordFactory
|
||||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |