| Package | Description |
|---|---|
| org.zkoss.poi.hssf.dev |
DEV package serves two purposes.
|
| 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
|
| 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 | |
| org.zkoss.poi.ss.util |
| 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
|
| 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)
|
| 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
|
| 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)
|
| 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
|
| PrintHeadersRecord
Title: Print Headers 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 |
| 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.
|
| StyleExtRecord
The StyleExt record follow the Style record
|
| StyleRecord
Title: Style Record (0x0293)
Description: Describes a builtin to the gui or user defined style
|
| 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
|
| 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
|
| XFCrcRecord
Title: XFCRC Record
|
| XFExtRecord
2.4.355 XFEXT [MS-XLS].pdf, page 609.
|
| Class and Description |
|---|
| AbstractEscherHolderRecord
The escher container record is used to hold escher records.
|
| BlankRecord
Title: Blank cell record (0x0201)
|
| BOFRecord
Title: Beginning Of File (0x0809)
|
| BoundSheetRecord
Title: Bound Sheet Record (aka BundleSheet) (0x0085)
|
| 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)
|
| FormulaRecord
Formula Record (0x0006).
|
| FullColorExt
2.5.155 FullColorExt.
|
| HeaderFooterBase
Common header/footer base class
|
| InterfaceEndRecord
Title: Interface End Record (0x00E2)
|
| 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.
|
| 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)
|
| 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 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 |
| 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
|
| XFExtRecord
2.4.355 XFEXT [MS-XLS].pdf, page 609.
|
| Class and Description |
|---|
| ArrayRecord
ARRAY (0x0221)
Treated in a similar way to SharedFormulaRecord
|
| BOFRecord
Title: Beginning Of File (0x0809)
|
| 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
|
| 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
|
| 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.
|
| 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)
|
| HyperlinkRecord
The
HyperlinkRecord (0x01B8) wraps an HLINK-record
from the Excel-97 format. |
| LabelSSTRecord
Title: Label SST Record
|
| 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
|
| TextObjectRecord
The TXO record (0x01B6) is used to define the properties of a text box.
|
| Class and Description |
|---|
| FullColorExt
2.5.155 FullColorExt.
|
| Class and Description |
|---|
| FontRecord
Title: Font Record (0x0031)
- describes a font in the workbook (index = 0-3,5-infinity - skip 4)
|
| StyleExtRecord
The StyleExt record follow the Style record
|
| StyleRecord
Title: Style Record (0x0293)
Description: Describes a builtin to the gui or user defined style
|
| Class and Description |
|---|
| RecordInputStream
Title: Record Input Stream
|
Copyright © 2020. All rights reserved.