Package | Description |
---|---|
org.apache.poi.hssf.dev |
DEV package serves two purposes.
|
org.apache.poi.hssf.eventmodel | |
org.apache.poi.hssf.eventusermodel |
HSSF eventmodel Package provides an event-based API for reading HSSF files.
|
org.apache.poi.hssf.eventusermodel.dummyrecord | |
org.apache.poi.hssf.model |
Provides low level API structures for reading, writing, modifying XLS files.
|
org.apache.poi.hssf.record |
Record package contains class representations for XLS binary strutures.
|
org.apache.poi.hssf.record.aggregates |
record aggregates are not real "records" but collections of records that act as a single record.
|
org.apache.poi.hssf.record.cf | |
org.apache.poi.hssf.record.chart | |
org.apache.poi.hssf.record.common | |
org.apache.poi.hssf.record.cont | |
org.apache.poi.hssf.record.crypto | |
org.apache.poi.hssf.record.pivottable | |
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.hssf.util |
util package contains tools needed for writing HSSF files that are not necesarily "real"
HSSF concepts.
|
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.
|
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.
|
Class and Description |
---|
BoundSheetRecord
Title: Bound Sheet Record (aka BundleSheet) (0x0085)
|
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.
|
Class and Description |
---|
Record
Title: Record
Description: All HSSF Records inherit from this class.
|
RecordBase
Common base class of
Record and RecordAggregate |
Class and Description |
---|
BackupRecord
Title: Backup Record
|
CellValueRecordInterface
The cell value record interface is implemented by all classes of type Record that
contain cell values.
|
DefaultColWidthRecord
Title: Default Column Width Record (0x0055)
|
DefaultRowHeightRecord
Title: Default Row Height Record
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.
|
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'.
REFERENCE: PG 314 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)
|
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.
|
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. |
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.
|
PrintGridlinesRecord
Title: Print Gridlines Record
|
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 |
RecordFormatException
Title: Record Format Exception
Description: Used by records to indicate invalid format/data.
|
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)
|
SSTRecord
Title: Static String Table Record (0x00FC)
Description: This holds all the strings for LabelSSTRecords.
|
StyleRecord
Title: Style Record (0x0293)
Description: Describes a builtin to the gui or user defined style
|
TextObjectRecord
The TXO record (0x01B6) is used to define the properties of a text box.
|
WindowOneRecord
Title: Window1 Record
|
WindowTwoRecord
Title: Window Two Record
|
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
|
Class and Description |
---|
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.
|
BlankRecord
Title: Blank cell record (0x0201)
|
BOFRecord
Title: Beginning Of File (0x0809)
|
BoolErrRecord
Creates new BoolErrRecord.
|
BottomMarginRecord
Record for the bottom margin.
|
BoundSheetRecord
Title: Bound Sheet Record (aka BundleSheet) (0x0085)
|
CalcCountRecord
Title: Calc Count Record
Description: Specifies the maximum times the gui should perform a formula
recalculation.
|
CalcModeRecord
Title: Calc Mode Record
|
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.
|
CFHeader12Record
Conditional Formatting Header v12 record CFHEADER12 (0x0879),
for conditional formattings introduced in Excel 2007 and newer.
|
CFHeaderBase
Parent of Conditional Formatting Header records,
CFHeaderRecord and CFHeader12Record . |
CFHeaderRecord
Conditional Formatting Header record CFHEADER (0x01B0).
|
CFRule12Record
Conditional Formatting v12 Rule Record (0x087A).
|
CFRuleBase
Conditional Formatting Rules.
|
CFRuleRecord
Conditional Formatting Rule Record (0x01B1).
|
CodepageRecord
Title: Codepage Record
|
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
|
DBCellRecord
Title: DBCell Record (0x00D7)
Description: Used by Excel and other MS apps to quickly find rows in the sheets.
|
DefaultColWidthRecord
Title: Default Column Width Record (0x0055)
|
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
|
DrawingRecord
DrawingRecord (0x00EC)
|
DrawingSelectionRecord
MsoDrawingSelection (0x00ED)
Reference:
[MS-OGRAPH].pdf sec 2.4.69
|
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.
|
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
|
FeatRecord
Title: Feat (Feature) Record
|
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'.
REFERENCE: PG 314 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)
|
FooterRecord
Title: Footer Record (0x0015)
Description: Specifies the footer for a sheet
|
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
|
HCenterRecord
Title: HCenter record (0x0083)
|
HeaderFooterBase
Common header/footer base class
|
HeaderFooterRecord
The HEADERFOOTER record stores information added in Office Excel 2007 for headers/footers.
|
HeaderRecord
Title: Header Record
|
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)
|
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
|
LbsDataSubRecord
This structure specifies the properties of a list or drop-down list embedded object in a sheet.
|
LeftMarginRecord
Record for the left margin.
|
Margin
The margin interface is a parent used to define left, right, top and bottom margins.
|
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.
|
MulRKRecord
MULRK (0x00BD)
Used to store multiple RK numbers on a row.
|
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
|
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 ). |
PageBreakRecord
Record that contains the functionality page breaks (horizontal and vertical)
|
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
|
RecordInputStream.LeftoverDataException
For use in
BiffViewer which may construct Record s 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 |
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
|
Class and Description |
---|
ArrayRecord
ARRAY (0x0221)
Treated in a similar way to SharedFormulaRecord
|
CellValueRecordInterface
The cell value record interface is implemented by all classes of type Record that
contain cell values.
|
CFHeaderBase
Parent of Conditional Formatting Header records,
CFHeaderRecord and CFHeader12Record . |
CFRuleBase
Conditional Formatting Rules.
|
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
|
DVRecord
Title: DATAVALIDATION Record (0x01BE)
Description: This record stores data validation settings and a list of cell ranges
which contain these settings.
|
FooterRecord
Title: Footer Record (0x0015)
Description: Specifies the footer for a sheet
|
FormulaRecord
Formula Record (0x0006).
|
HCenterRecord
Title: HCenter record (0x0083)
|
HeaderFooterRecord
The HEADERFOOTER record stores information added in Office Excel 2007 for headers/footers.
|
HeaderRecord
Title: Header Record
|
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
|
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 |
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
|
Class and Description |
---|
RecordInputStream
Title: Record Input Stream
|
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
|
StandardRecord
Subclasses of this class (the majority of BIFF records) are non-continuable.
|
Class and Description |
---|
RecordInputStream
Title: Record Input Stream
|
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
|
Class and Description |
---|
BiffHeaderInput |
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
|
StandardRecord
Subclasses of this class (the majority of BIFF records) are non-continuable.
|
Class and Description |
---|
CellValueRecordInterface
The cell value record interface is implemented by all classes of type Record that
contain cell values.
|
CFRule12Record
Conditional Formatting v12 Rule Record (0x087A).
|
CFRuleBase
Conditional Formatting Rules.
|
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)
|
HyperlinkRecord
The
HyperlinkRecord (0x01B8) wraps an HLINK-record
from the Excel-97 format. |
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.
|
TextObjectRecord
The TXO record (0x01B6) is used to define the properties of a text box.
|
Class and Description |
---|
RecordInputStream
Title: Record Input Stream
|
Copyright 2016 The Apache Software Foundation or its licensors, as applicable.