Package | Description |
---|---|
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.chart | |
org.apache.poi.hssf.record.cont | |
org.apache.poi.hssf.record.pivottable |
Modifier and Type | Class | Description |
---|---|---|
class |
LastCellOfRowDummyRecord |
A dummy record to indicate that we've now had the last
cell record for this row.
|
class |
MissingCellDummyRecord |
A dummy record for when we're missing a cell in a row,
but still want to trigger something
|
class |
MissingRowDummyRecord |
A dummy record for when we're missing a row, but still
want to trigger something
|
Modifier and Type | Method | Description |
---|---|---|
java.util.List<RecordBase> |
InternalSheet.getRecords() |
Modifier and Type | Class | Description |
---|---|---|
class |
AbstractEscherHolderRecord |
The escher container record is used to hold escher records.
|
class |
ArrayRecord |
ARRAY (0x0221)
|
class |
AutoFilterInfoRecord |
The AutoFilterInfo record specifies the number of columns that have AutoFilter enabled
and indicates the beginning of the collection of AutoFilter records.
|
class |
BackupRecord |
Title: Backup Record
|
class |
BlankRecord |
Title: Blank cell record (0x0201)
|
class |
BOFRecord |
Title: Beginning Of File (0x0809)
|
class |
BookBoolRecord |
Title: Save External Links record (BookBool)
|
class |
BoolErrRecord |
Creates new BoolErrRecord.
|
class |
BottomMarginRecord |
Record for the bottom margin.
|
class |
BoundSheetRecord |
Title: Bound Sheet Record (aka BundleSheet) (0x0085)
|
class |
CalcCountRecord |
Title: Calc Count Record
Description: Specifies the maximum times the gui should perform a formula
recalculation.
|
class |
CalcModeRecord |
Title: Calc Mode Record
|
class |
CellRecord |
Base class for all cell value records (implementors of
CellValueRecordInterface ). |
class |
CFHeaderRecord |
Conditional Formatting Header record CFHEADER (0x01B0)
|
class |
CFRuleRecord |
Conditional Formatting Rule Record (0x01B1).
|
class |
CodepageRecord |
Title: Codepage Record
|
class |
ColumnInfoRecord |
Title: COLINFO Record (0x007D)
|
class |
ContinueRecord |
Title: Continue Record(0x003C) - Helper class used primarily for SST Records
|
class |
CountryRecord |
Title: Country Record (aka WIN.INI country)
|
class |
CRNCountRecord |
XCT - CRN Count
|
class |
CRNRecord |
Title: CRN(0x005A)
|
class |
DateWindow1904Record |
Title: Date Window 1904 Flag record
|
class |
DBCellRecord |
Title: DBCell Record (0x00D7)
|
class |
DConRefRecord |
DConRef records specify a range in a workbook (internal or external) that serves as a data source
for pivot tables or data consolidation.
|
class |
DefaultColWidthRecord |
Title: Default Column Width Record (0x0055)
|
class |
DefaultRowHeightRecord |
Title: Default Row Height Record
Description: Row height for rows with undefined or not explicitly defined
heights.
|
class |
DeltaRecord |
Title: Delta Record (0x0010)
|
class |
DimensionsRecord |
Title: Dimensions Record
|
class |
DrawingGroupRecord |
|
class |
DrawingRecord |
DrawingRecord (0x00EC)
|
class |
DrawingRecordForBiffViewer |
This is purely for the biff viewer.
|
class |
DrawingSelectionRecord |
MsoDrawingSelection (0x00ED)
|
class |
DSFRecord |
Title: Double Stream Flag Record (0x0161)
|
class |
DVALRecord |
Title: DATAVALIDATIONS Record (0x01B2)
|
class |
DVRecord |
Title: DATAVALIDATION Record (0x01BE)
|
class |
EOFRecord |
End Of File record.
|
class |
EscherAggregate |
This class is used to aggregate the MSODRAWING and OBJ record
combinations.
|
class |
ExtendedFormatRecord |
Title: Extended Format Record
Description: Probably one of the more complex records.
|
class |
ExternalNameRecord |
EXTERNALNAME (0x0023)
|
class |
ExternSheetRecord |
EXTERNSHEET (0x0017)
A List of Indexes to EXTERNALBOOK (supplemental book) Records |
class |
ExtSSTRecord |
Title: Extended Static String Table (0x00FF)
|
class |
FeatHdrRecord |
Title: FeatHdr (Feature Header) Record
|
class |
FeatRecord |
Title: Feat (Feature) Record
|
class |
FilePassRecord |
Title: File Pass Record (0x002F)
|
class |
FileSharingRecord |
Title: FILESHARING (0x005B)
|
class |
FnGroupCountRecord |
Title: Function Group Count Record
|
class |
FontRecord |
Title: Font Record (0x0031)
|
class |
FooterRecord |
Title: Footer Record (0x0015)
|
class |
FormatRecord |
Title: Format Record (0x041E)
|
class |
FormulaRecord |
Formula Record (0x0006).
|
class |
GridsetRecord |
Title: Gridset Record.
|
class |
GutsRecord |
Title: Guts Record
|
class |
HCenterRecord |
Title: HCenter record (0x0083)
|
class |
HeaderFooterBase |
Common header/footer base class
|
class |
HeaderFooterRecord |
The HEADERFOOTER record stores information added in Office Excel 2007 for headers/footers.
|
class |
HeaderRecord |
Title: Header Record
|
class |
HideObjRecord |
Title: Hide Object Record
|
class |
HorizontalPageBreakRecord |
HorizontalPageBreak (0x001B) record that stores page breaks at rows
|
class |
HyperlinkRecord |
The
HyperlinkRecord (0x01B8) wraps an HLINK-record
from the Excel-97 format. |
class |
IndexRecord |
Title: Index Record (0x020B)
|
class |
InterfaceEndRecord |
Title: Interface End Record (0x00E2)
|
class |
InterfaceHdrRecord |
Title: Interface Header Record (0x00E1)
|
class |
IterationRecord |
Title: Iteration Record (0x0011)
|
class |
LabelRecord |
Label Record (0x0204) - read only support for strings stored directly in the cell..
|
class |
LabelSSTRecord |
Title: Label SST Record
|
class |
LeftMarginRecord |
Record for the left margin.
|
class |
MergeCellsRecord |
Title: Merged Cells Record (0x00E5)
Description: Optional record defining a square area of cells to "merged" into one cell. |
class |
MMSRecord |
Title: MMS Record
|
class |
MulBlankRecord |
Title: Multiple Blank cell record(0x00BE)
|
class |
MulRKRecord |
MULRK (0x00BD)
|
class |
NameCommentRecord |
Title: NAMECMT Record (0x0894)
|
class |
NameRecord |
Title: DEFINEDNAME Record (0x0018)
|
class |
NoteRecord |
NOTE: Comment Associated with a Cell (0x001C)
|
class |
NumberRecord |
NUMBER (0x0203) Contains a numeric cell value.
|
class |
ObjectProtectRecord |
Title: Object Protect Record
|
class |
ObjRecord |
OBJRECORD (0x005D)
|
class |
PageBreakRecord |
Record that contains the functionality page breaks (horizontal and vertical)
|
class |
PaletteRecord |
PaletteRecord (0x0092) - Supports custom palettes.
|
class |
PaneRecord |
Describes the frozen and unfozen panes.
|
class |
PasswordRecord |
Title: Password Record (0x0013)
|
class |
PasswordRev4Record |
Title: Protection Revision 4 password Record (0x01BC)
|
class |
PrecisionRecord |
Title: Precision Record
|
class |
PrintGridlinesRecord |
Title: Print Gridlines Record
|
class |
PrintHeadersRecord |
Title: Print Headers Record
|
class |
PrintSetupRecord |
Title: PAGESETUP (0x00A1)
|
class |
ProtectionRev4Record |
Title: Protection Revision 4 Record (0x01AF)
|
class |
ProtectRecord |
Title: Protect Record (0x0012)
|
class |
RecalcIdRecord |
Title: Recalc Id Record (0x01C1)
|
class |
Record |
Title: Record
Description: All HSSF Records inherit from this class.
|
class |
RefModeRecord |
Title: RefMode Record
|
class |
RefreshAllRecord |
Title: Refresh All Record (0x01B7)
|
class |
RightMarginRecord |
Record for the right margin.
|
class |
RKRecord |
Title: RK Record (0x027E)
|
class |
RowRecord |
Title: Row Record (0x0208)
|
class |
SaveRecalcRecord |
Title: Save Recalc Record
|
class |
ScenarioProtectRecord |
Title: Scenario Protect Record
|
class |
SCLRecord |
Specifies the window's zoom magnification.
|
class |
SelectionRecord |
Title: Selection Record (0x001D)
|
class |
SharedFormulaRecord |
Title: SHAREDFMLA (0x04BC) SharedFormulaRecord
Description: Primarily used as an excel optimization so that multiple similar formulas
are not written out too many times.
|
class |
SharedValueRecordBase |
|
class |
SSTRecord |
Title: Static String Table Record (0x00FC)
|
class |
StandardRecord |
Subclasses of this class (the majority of BIFF records) are non-continuable.
|
class |
StringRecord |
STRING (0x0207)
|
class |
StyleRecord |
Title: Style Record (0x0293)
|
class |
SupBookRecord |
Title: Sup Book - EXTERNALBOOK (0x01AE)
|
class |
TabIdRecord |
Title: Sheet Tab Index Array Record (0x013D)
|
class |
TableRecord |
DATATABLE (0x0236)
|
class |
TableStylesRecord |
TABLESTYLES (0x088E)
|
class |
TextObjectRecord |
The TXO record (0x01B6) is used to define the properties of a text box.
|
class |
TopMarginRecord |
Record for the top margin.
|
class |
UncalcedRecord |
Title: Uncalced Record
|
class |
UnknownRecord |
Title: Unknown Record (for debugging)
|
class |
UserSViewBegin |
The UserSViewBegin record specifies settings for a custom view associated with the sheet.
|
class |
UserSViewEnd |
The UserSViewEnd record marks the end of the settings for a custom view associated with the sheet
|
class |
UseSelFSRecord |
Title: USESELFS (0x0160) - Use Natural Language Formulas Flag
|
class |
VCenterRecord |
Title: VCenter record
|
class |
VerticalPageBreakRecord |
VerticalPageBreak (0x001A) record that stores page breaks at columns
|
class |
WindowOneRecord |
Title: Window1 Record
|
class |
WindowProtectRecord |
Title: Window Protect Record (0x0019)
|
class |
WindowTwoRecord |
Title: Window Two Record
|
class |
WriteAccessRecord |
Title: Write Access Record (0x005C)
|
class |
WriteProtectRecord |
Title: Write Protect Record
|
class |
WSBoolRecord |
Title: WSBOOL (0x0081) (called SHEETPR in OOO doc)
|
Modifier and Type | Method | Description |
---|---|---|
static EscherAggregate |
EscherAggregate.createAggregate(java.util.List<RecordBase> records,
int locFirstDrawingRecord) |
Collapses the drawing records into an aggregate.
|
Modifier and Type | Class | Description |
---|---|---|
class |
CFRecordsAggregate |
CFRecordsAggregate - aggregates Conditional Formatting records CFHeaderRecord
and number of up to three CFRuleRecord records together to simplify
access to them.
|
class |
ChartSubstreamRecordAggregate |
|
class |
ColumnInfoRecordsAggregate |
|
class |
ConditionalFormattingTable |
Holds all the conditional formatting for a workbook sheet.
|
class |
CustomViewSettingsRecordAggregate |
Manages the all the records associated with a 'Custom View Settings' sub-stream.
Includes the initial USERSVIEWBEGIN(0x01AA) and final USERSVIEWEND(0x01AB). |
class |
DataValidityTable |
Manages the DVALRecord and DVRecords for a single sheet
See OOO excelfileformat.pdf section 4.14 |
class |
FormulaRecordAggregate |
The formula record aggregate is used to join together the formula record and it's
(optional) string record and (optional) Shared Formula Record (template reads, excel optimization).
|
class |
MergedCellsTable |
|
class |
PageSettingsBlock |
Groups the page settings records for a worksheet.
|
class |
RecordAggregate |
RecordAggregates are groups of of BIFF Records that are typically stored
together and/or updated together.
|
class |
RowRecordsAggregate |
|
class |
WorksheetProtectionBlock |
Groups the sheet protection records for a worksheet.
|
Modifier and Type | Method | Description |
---|---|---|
void |
CustomViewSettingsRecordAggregate.append(RecordBase r) |
Modifier and Type | Method | Description |
---|---|---|
void |
PageSettingsBlock.positionRecords(java.util.List<RecordBase> sheetRecords) |
Some apps can define multiple HeaderFooterRecord records for a sheet.
|
Modifier and Type | Class | Description |
---|---|---|
class |
AreaFormatRecord |
The area format record is used to define the colours and patterns for an area.
|
class |
AreaRecord |
The area record is used to define a area chart.
|
class |
AxisLineFormatRecord |
The axis line format record defines the axis type details.
|
class |
AxisOptionsRecord |
The axis options record provides unit information and other various tidbits about the axis.
|
class |
AxisParentRecord |
The axis size and location
|
class |
AxisRecord |
The axis record defines the type of an axis.
|
class |
AxisUsedRecord |
The number of axes used on a chart.
|
class |
BarRecord |
The bar record is used to define a bar chart.
|
class |
BeginRecord |
The begin record defines the start of a block of records for a (grpahing
data object.
|
class |
CategorySeriesAxisRecord |
This record refers to a category or series axis and is used to specify label/tickmark frequency.
|
class |
CatLabRecord |
CATLAB - Category Labels (0x0856)
|
class |
ChartEndBlockRecord |
ENDBLOCK - Chart Future Record Type End Block (0x0853)
|
class |
ChartEndObjectRecord |
ENDOBJECT - Chart Future Record Type End Object (0x0855)
|
class |
ChartFormatRecord |
Class ChartFormatRecord (0x1014)
|
class |
ChartFRTInfoRecord |
CHARTFRTINFO - Chart Future Record Type Info (0x0850)
|
class |
ChartRecord |
CHART (0x1002)
|
class |
ChartStartBlockRecord |
STARTBLOCK - Chart Future Record Type Start Block (0x0852)
|
class |
ChartStartObjectRecord |
STARTOBJECT - Chart Future Record Type Start Object (0x0854)
|
class |
ChartTitleFormatRecord |
CHARTTITLEFORMAT (0x1050)
|
class |
DataFormatRecord |
The data format record is used to index into a series.
|
class |
DataLabelExtensionRecord |
DATALABEXT - Chart Data Label Extension (0x086A)
|
class |
DatRecord |
The dat record is used to store options for the chart.
|
class |
DefaultDataLabelTextPropertiesRecord |
The default data label text properties record identifies the text characteristics of the preceding text record.
|
class |
EndRecord |
The end record defines the end of a block of records for a (Graphing)
data object.
|
class |
FontBasisRecord |
The font basis record stores various font metrics.
|
class |
FontIndexRecord |
The font index record indexes into the font table for the text record.
|
class |
FrameRecord |
The frame record indicates whether there is a border around the displayed text of a chart.
|
class |
LegendRecord |
Defines a legend for a chart.
|
class |
LineFormatRecord |
Describes a line format record.
|
class |
LinkedDataRecord |
Describes a linked data record.
|
class |
NumberFormatIndexRecord |
The number format index record indexes format table.
|
class |
ObjectLinkRecord |
Links text to an object on the chart or identifies it as the title.
|
class |
PlotAreaRecord |
preceeds and identifies a frame as belonging to the plot area.
|
class |
PlotGrowthRecord |
The plot growth record specifies the scaling factors used when a font is scaled.
|
class |
SeriesChartGroupIndexRecord |
The series chart group index record stores the index to the CHARTFORMAT record (0 based).
|
class |
SeriesIndexRecord |
links a series to its position in the series list.
|
class |
SeriesLabelsRecord |
The series label record defines the type of label associated with the data format record.
|
class |
SeriesListRecord |
SERIESLIST (0x1016)
|
class |
SeriesRecord |
The series record describes the overall data for a series.
|
class |
SeriesTextRecord |
SERIESTEXT (0x100D)
|
class |
SeriesToChartGroupRecord |
Indicates the chart-group index for a series.
|
class |
SheetPropertiesRecord |
Describes a chart sheet properties record.
|
class |
TextRecord |
The text record is used to define text stored on a chart.
|
class |
TickRecord |
The Tick record defines how tick marks and label positioning/formatting
|
class |
UnitsRecord |
The units record describes units.
|
class |
ValueRangeRecord |
The value range record defines the range of the value axis.
|
Modifier and Type | Class | Description |
---|---|---|
class |
ContinuableRecord |
Common superclass of all records that can produce
ContinueRecord s while being serialized. |
Modifier and Type | Class | Description |
---|---|---|
class |
DataItemRecord |
SXDI - Data Item (0x00C5)
|
class |
ExtendedPivotTableViewFieldsRecord |
SXVDEX - Extended PivotTable View Fields (0x0100)
|
class |
PageItemRecord |
SXPI - Page Item (0x00B6)
|
class |
StreamIDRecord |
SXIDSTM - Stream ID (0x00D5)
|
class |
ViewDefinitionRecord |
SXVIEW - View Definition (0x00B0)
|
class |
ViewFieldsRecord |
SXVD - View Fields (0x00B1)
|
class |
ViewSourceRecord |
SXVS - View Source (0x00E3)
|
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.