Uses of Package
org.zkoss.poi.hssf.record

Packages that use org.zkoss.poi.hssf.record

Package	Description
org.zkoss.poi.hssf.dev	DEV package serves two purposes. 1.
org.zkoss.poi.hssf.eventmodel
org.zkoss.poi.hssf.eventusermodel	HSSF eventmodel Package provides an event-based API for reading HSSF files.
org.zkoss.poi.hssf.eventusermodel.dummyrecord
org.zkoss.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.zkoss.poi.hssf.record	Record package contains class representations for XLS binary strutures.
org.zkoss.poi.hssf.record.aggregates	record aggregates are not real "records" but collections of records that act as a single record.
org.zkoss.poi.hssf.record.cf
org.zkoss.poi.hssf.record.chart
org.zkoss.poi.hssf.record.common
org.zkoss.poi.hssf.record.cont
org.zkoss.poi.hssf.record.crypto
org.zkoss.poi.hssf.record.pivottable
org.zkoss.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model Related Documentation For overviews, tutorials, examples, guides, and tool documentation, please see: Apache POI Project
org.zkoss.poi.hssf.util	util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
org.zkoss.poi.ss.usermodel

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.dev

Class and Description
FormulaRecord Formula Record (0x0006).
Record Title: Record Description: All HSSF Records inherit from this class.
RecordFormatException Title: Record Format Exception Description: Used by records to indicate invalid format/data.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.eventmodel

Class and Description
Record Title: Record Description: All HSSF Records inherit from this class.
RecordFormatException Title: Record Format Exception Description: Used by records to indicate invalid format/data.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.eventusermodel

Class and Description
BoundSheetRecord Title: Bound Sheet Record (aka BundleSheet) (0x0085) Description: Defines a sheet within a workbook.
CellValueRecordInterface The cell value record interface is implemented by all classes of type Record that contain cell values.
ExternSheetRecord EXTERNSHEET (0x0017) A List of Indexes to EXTERNALBOOK (supplemental book) Records
Record Title: Record Description: All HSSF Records inherit from this class.
SSTRecord Title: Static String Table Record (0x00FC) Description: This holds all the strings for LabelSSTRecords.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.eventusermodel.dummyrecord

Class and Description
Record Title: Record Description: All HSSF Records inherit from this class.
RecordBase Common base class of Record and RecordAggregate

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.model

Class and Description
BackupRecord Title: Backup Record Description: Boolean specifying whether the GUI should store a backup of the file.
BookExtRecord [MS-XLS].pdf 2.4.23 BookExt page 203 properties of a workbook file
CellValueRecordInterface The cell value record interface is implemented by all classes of type Record that contain cell values.
Compat12Record [MS-XLS].pdf 2.4.54 Compat12 page 231 whether to check for compatibility with earlier application versions when saving the workbook.
CompressPicturesRecord [MS-XLS].pdf 2.4.55 CompressPictures page 231 Recomendation for picture compression when saving.
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 per sheet Description: Row height for rows with undefined or not explicitly defined heights.
ExtendedFormatRecord Title: Extended Format Record Description: Probably one of the more complex records.
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.
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'.
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)
ForceFullCalculationRecord [MS-XLS].pdf 2.4.125 ForceFullCalculation page 298 Value of the forced calculation mode for this workbook.
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)
GridsetRecord Title: Gridset Record.
HeaderFooterRecord The HEADERFOOTER record stores information added in Office Excel 2007 for headers/footers.
HyperlinkRecord The HyperlinkRecord (0x01B8) wraps an HLINK-record from the Excel-97 format.
MergeCellsRecord Title: Merged Cells Record (0x00E5) Description: Optional record defining a square area of cells to "merged" into one cell.
MTRSettingsRecord [MS-XLS].pdf 2.4.173 MTRSettings page 343 Multithreaded calculation settings.
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)
ObjRecord OBJRECORD (0x005D) The obj record is used to hold various graphic objects and controls.
PaletteRecord PaletteRecord (0x0092) - Supports custom palettes.
PLVRecord [MS-XLS].pdf 2.4.200 PLV page 360 Page Layout View for a sheet.
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.
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
RowRecord Title: Row Record (0x0208) Description: stores the row information for the sheet.
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)
SSTRecord Title: Static String Table Record (0x00FC) Description: This holds all the strings for LabelSSTRecords.
StyleExtRecord The StyleExt record follow the Style record
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)
TableStylesRecord TABLESTYLES (0x088E)
TextObjectRecord The TXO record (0x01B6) is used to define the properties of a text box.
ThemeRecord The theme used in this workbook.
WindowOneRecord Title: Window1 Record Description: Stores the attributes of the workbook window.
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.
XFCrcRecord Title: XFCRC Record
XFExtRecord 2.4.355 XFEXT [MS-XLS].pdf, page 609.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.record

Class and Description
AbstractEscherHolderRecord The escher container record is used to hold escher records.
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.
BoundSheetRecord Title: Bound Sheet Record (aka BundleSheet) (0x0085) Description: Defines a sheet within a workbook.
CellRecord Base class for all cell value records (implementors of CellValueRecordInterface).
CellValueRecordInterface The cell value record interface is implemented by all classes of type Record that contain cell values.
CFRuleRecord Conditional Formatting Rule Record (0x01B1).
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)
DBCellRecord Title: DBCell Record (0x00D7) Description: Used by Excel and other MS apps to quickly find rows in the sheets.
DrawingRecord DrawingRecord (0x00EC)
EnhancedProtection
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.
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
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)
FormulaRecord Formula Record (0x0006).
FullColorExt 2.5.155 FullColorExt.
HeaderFooterBase Common header/footer base class
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)
LbsDataSubRecord This structure specifies the properties of a list or drop-down list embedded object in a sheet.
Margin The margin interface is a parent used to define left, right, top and bottom margins.
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.
NoteRecord NOTE: Comment Associated with a Cell (0x001C)
NumberRecord NUMBER (0x0203) Contains a numeric cell value.
ObjRecord OBJRECORD (0x005D) The obj record is used to hold various graphic objects and controls.
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.
Record Title: Record Description: All HSSF Records inherit from this class.
RecordBase Common base class of Record and RecordAggregate
RecordFormatException Title: Record Format Exception Description: Used by records to indicate invalid format/data.
RecordInputStream Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records.
RecordInputStream.LeftoverDataException For use in BiffViewer which may construct Records that don't completely read all available data.
RKRecord Title: RK Record (0x027E) Description: An internal 32 bit number with the two most significant bits storing the type.
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.
StandardRecord Subclasses of this class (the majority of BIFF records) are non-continuable.
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
XFExtRecord 2.4.355 XFEXT [MS-XLS].pdf, page 609.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.record.aggregates

Class and Description
ArrayRecord ARRAY (0x0221) Treated in a similar way to SharedFormulaRecord
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.
CellValueRecordInterface The cell value record interface is implemented by all classes of type Record that contain cell values.
CFHeaderRecord Conditional Formatting Header record CFHEADER (0x01B0)
CFRuleRecord Conditional Formatting Rule Record (0x01B1).
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)
DimensionsRecord Title: Dimensions Record Description: provides the minumum and maximum bounds of a sheet.
DVRecord Title: DATAVALIDATION Record (0x01BE) Description: This record stores data validation settings and a list of cell ranges which contain these settings.
EOFRecord End Of File record.
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)
FormulaRecord Formula Record (0x0006).
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)
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)
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)
MergeCellsRecord Title: Merged Cells Record (0x00E5) Description: Optional record defining a square area of cells to "merged" into one cell.
MulBlankRecord Title: Multiple Blank cell record(0x00BE) Description: Represents a set of columns in a row with no value but with styling.
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)
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
Record Title: Record Description: All HSSF Records inherit from this class.
RecordBase Common base class of Record and RecordAggregate
RowRecord Title: Row Record (0x0208) Description: stores the row information for the sheet.
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.
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.
StringRecord STRING (0x0207) Stores the cached result of a text formula
TableRecord DATATABLE (0x0236) TableRecord - The record specifies a data table.
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)

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.record.cf

Class and Description
RecordInputStream Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.record.chart

Class and Description
Record Title: Record Description: All HSSF Records inherit from this class.
RecordBase Common base class of Record and RecordAggregate
RecordInputStream Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records.
StandardRecord Subclasses of this class (the majority of BIFF records) are non-continuable.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.record.common

Class and Description
RecordInputStream Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.record.cont

Class and Description
Record Title: Record Description: All HSSF Records inherit from this class.
RecordBase Common base class of Record and RecordAggregate
RecordInputStream Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.record.crypto

Class and Description
BiffHeaderInput

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.record.pivottable

Class and Description
Record Title: Record Description: All HSSF Records inherit from this class.
RecordBase Common base class of Record and RecordAggregate
RecordInputStream Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records.
StandardRecord Subclasses of this class (the majority of BIFF records) are non-continuable.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.usermodel

Class and Description
CellValueRecordInterface The cell value record interface is implemented by all classes of type Record that contain cell values.
CFRuleRecord Conditional Formatting Rule Record (0x01B1).
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.
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.
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)
HyperlinkRecord The HyperlinkRecord (0x01B8) wraps an HLINK-record from the Excel-97 format.
LabelSSTRecord Title: Label SST Record Description: Refers to a string in the shared string table and is a column value.
NameRecord Title: DEFINEDNAME Record (0x0018) Description: Defines a named range within a workbook.
NoteRecord NOTE: Comment Associated with a Cell (0x001C)
ObjRecord OBJRECORD (0x005D) The obj record is used to hold various graphic objects and controls.
PaletteRecord PaletteRecord (0x0092) - Supports custom palettes.
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
Record Title: Record Description: All HSSF Records inherit from this class.
RowRecord Title: Row Record (0x0208) Description: stores the row information for the sheet.
StyleExtRecord The StyleExt record follow the Style record
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)
TextObjectRecord The TXO record (0x01B6) is used to define the properties of a text box.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.hssf.util

Class and Description
FullColorExt 2.5.155 FullColorExt.
RecordInputStream Title: Record Input Stream Description: Wraps a stream and provides helper methods for the construction of records.

Classes in org.zkoss.poi.hssf.record used by org.zkoss.poi.ss.usermodel

Class and Description
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)
StyleExtRecord The StyleExt record follow the Style record
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)