Package org.apache.poi.hssf.record
package org.apache.poi.hssf.record
Record package contains class representations for XLS binary strutures. Its very
low level.
Related Documentation
For overviews, tutorials, examples, guides, and tool documentation, please see:- See Also:
-
ClassDescriptionThe escher container record is used to hold escher records.ARRAY (0x0221)The AutoFilterInfo record specifies the number of columns that have AutoFilter enabled and indicates the beginning of the collection of AutoFilter records.Title: Backup RecordTitle: Blank cell record (0x0201)Title: Beginning Of File (0x0809)Title: Save External Links record (BookBool)Creates new BoolErrRecord.Record for the bottom margin.Title: Bound Sheet Record (aka BundleSheet) (0x0085)Title: Calc Count Record Description: Specifies the maximum times the gui should perform a formula recalculation.Title: Calc Mode RecordBase class for all cell value records (implementors of
CellValueRecordInterface
).The cell value record interface is implemented by all classes of type Record that contain cell values.Conditional Formatting Header v12 record CFHEADER12 (0x0879), for conditional formattings introduced in Excel 2007 and newer.Parent of Conditional Formatting Header records,CFHeaderRecord
andCFHeader12Record
.Conditional Formatting Header record CFHEADER (0x01B0).Conditional Formatting v12 Rule Record (0x087A).Conditional Formatting Rules.Conditional Formatting Rule Record (0x01B1).Title: Codepage RecordTitle: COLINFO Record (0x007D)The common object data record is used to store all common preferences for an excel object.Title: Continue Record(0x003C) - Helper class used primarily for SST RecordsTitle: Country Record (aka WIN.INI country)XCT - CRN CountTitle: CRN(0x005A)Title: Date Window 1904 Flag recordTitle: DBCell Record (0x00D7)DConRef records specify a range in a workbook (internal or external) that serves as a data source for pivot tables or data consolidation.Title: Default Column Width Record (0x0055)Title: Default Row Height Record Description: Row height for rows with undefined or not explicitly defined heights.Title: Delta Record (0x0010)Title: Dimensions RecordDrawingRecord (0x00EC)This is purely for the biff viewer.MsoDrawingSelection (0x00ED)Title: Double Stream Flag Record (0x0161)Title: DATAVALIDATIONS Record (0x01B2)Title: DATAVALIDATION Record (0x01BE)ftPictFmla (0x0009)ftEnd (0x0000)End Of File record.This class is used to aggregate the MSODRAWING and OBJ record combinations.Title: Extended Format Record Description: Probably one of the more complex records.EXTERNALNAME (0x0023)EXTERNSHEET (0x0017)Title: Extended Static String Table (0x00FF)Title: FeatHdr (Feature Header) RecordTitle: Feat (Feature) RecordTitle: File Pass Record (0x002F)Title: FILESHARING (0x005B)Title: Function Group Count RecordTitle: Font Record (0x0031)Title: Footer Record (0x0015)Title: Format Record (0x041E)Formula Record (0x0006).This structure appears as part of an Obj record that represents a checkbox or radio button.The FtCf structure specifies the clipboard format of the picture-type Obj record containing this FtCf.This structure appears as part of an Obj record that represents image display properties.Title: Gridset Record.ftGmo (0x0006)Title: Guts RecordTitle: HCenter record (0x0083)Common header/footer base classThe HEADERFOOTER record stores information added in Office Excel 2007 for headers/footers.Title: Header RecordTitle: Hide Object RecordHorizontalPageBreak (0x001B) record that stores page breaks at rowsTheHyperlinkRecord
(0x01B8) wraps an HLINK-record from the Excel-97 format.Title: Index Record (0x020B)Title: Interface End Record (0x00E2)Title: Interface Header Record (0x00E1)Title: Iteration Record (0x0011)Label Record (0x0204) - read only support for strings stored directly in the cell...Title: Label SST RecordThis structure specifies the properties of a list or drop-down list embedded object in a sheet.This structure specifies properties of the dropdown list controlRecord for the left margin.The margin interface is a parent used to define left, right, top and bottom margins.Title: Merged Cells Record (0x00E5)Title: MMS RecordTitle: Multiple Blank cell record(0x00BE)MULRK (0x00BD)Title: NAMECMT Record (0x0894)Title: DEFINEDNAME Record (0x0018)NOTE: Comment Associated with a Cell (0x001C)ftNts (0x000D)NUMBER (0x0203) Contains a numeric cell value.Title: Object Protect RecordOBJRECORD (0x005D)Base class for all old (Biff 2 - Biff 4) cell value records (implementors ofCellValueRecordInterface
).Formula Record (0x0006 / 0x0206 / 0x0406) - holds a formula in encoded form, along with the value if a numberBiff2 - Biff 4 Label Record (0x0004 / 0x0204) - read only support for strings stored directly in the cell, from the older file formats that didn't useLabelSSTRecord
Title: Bound Sheet Record (aka BundleSheet) (0x0085) for BIFF 5Biff2 - Biff 4 Label Record (0x0007 / 0x0207) - read only support for formula string results.Record that contains the functionality page breaks (horizontal and vertical)Since both records store 2byte integers (short), no point in differentiating it in the records.PaletteRecord (0x0092) - Supports custom palettes.Describes the frozen and unfrozen panes.Title: Password Record (0x0013)Title: Protection Revision 4 password Record (0x01BC)Title: Precision RecordTitle: Print Gridlines RecordTitle: Print Headers RecordTitle: PAGESETUP (0x00A1)Title: Protection Revision 4 Record (0x01AF)Title: Protect Record (0x0012)Title: Recalc Id Record (0x01C1)All HSSF Records inherit from this class.Common base class ofRecord
andRecordAggregate
Title: Record FactoryA stream based way to get at complete records, with as low a memory footprint as possible.Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records.For use inBiffViewer
which may constructRecord
s that don't completely read all available data.Title: RefMode RecordTitle: Refresh All Record (0x01B7)Record for the right margin.Title: RK Record (0x027E)Title: Row Record (0x0208)Title: Save Recalc RecordTitle: Scenario Protect RecordSpecifies the window's zoom magnification.Title: Selection Record (0x001D)Title: SHAREDFMLA (0x04BC) SharedFormulaRecord Description: Primarily used as an excel optimization so that multiple similar formulas are not written out too many times.Title: Static String Table Record (0x00FC)Subclasses of this class (the majority of BIFF records) are non-continuable.STRING (0x0207)Title: Style Record (0x0293)Subrecords are part of the OBJ class.Title: Sup Book - EXTERNALBOOK (0x01AE)Title: Sheet Tab Index Array Record (0x013D)DATATABLE (0x0236)TABLESTYLES (0x088E)The TXO record (0x01B6) is used to define the properties of a text box.Record for the top margin.Title: Uncalced RecordTitle: Unknown Record (for debugging)The UserSViewBegin record specifies settings for a custom view associated with the sheet.The UserSViewEnd record marks the end of the settings for a custom view associated with the sheetTitle: USESELFS (0x0160) - Use Natural Language Formulas FlagTitle: VCenter recordVerticalPageBreak (0x001A) record that stores page breaks at columnsTitle: Window1 RecordTitle: Window Protect Record (0x0019)Title: Window Two RecordTitle: Write Access Record (0x005C)Title: Write Protect RecordTitle: WSBOOL (0x0081) (called SHEETPR in OOO doc)