| Package | Description | 
|---|---|
| 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 | The 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 | |
| org.apache.poi.hssf.usermodel | The usermodel package maps HSSF low level structures to familiar workbook/sheet model | 
| Modifier and Type | Method and Description | 
|---|---|
| boolean | ERFListener. processRecord(Record rec)Process a Record. | 
| Modifier and Type | Method and Description | 
|---|---|
| abstract short | AbortableHSSFListener. abortableProcessRecord(Record record)Process an HSSF Record. | 
| void | HSSFListener. processRecord(Record record)process an HSSF Record. | 
| void | FormatTrackingHSSFListener. processRecord(Record record)Process this record ourselves, and then pass it on to our child listener | 
| void | AbortableHSSFListener. processRecord(Record record)This method, inherited from HSSFListener is implemented as a stub. | 
| void | EventWorkbookBuilder.SheetRecordCollectingListener. processRecord(Record record)Process this record ourselves, and then
  pass it on to our child listener | 
| void | MissingRecordAwareHSSFListener. processRecord(Record record) | 
| protected short | HSSFRequest. processRecord(Record rec)Called by HSSFEventFactory, passes the Record to each listener associated with
 a record.sid. | 
| void | FormatTrackingHSSFListener. processRecordInternally(Record record)Process the record ourselves, but do not pass it on to the child
 Listener. | 
| void | EventWorkbookBuilder.SheetRecordCollectingListener. processRecordInternally(Record record)Process the record ourselves, but do not
  pass it on to the child Listener. | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | LastCellOfRowDummyRecordA dummy record to indicate that we've now had the last
  cell record for this row. | 
| class  | MissingCellDummyRecordA dummy record for when we're missing a cell in a row,
  but still want to trigger something | 
| class  | MissingRowDummyRecordA dummy record for when we're missing a row, but still
  want to trigger something | 
| Modifier and Type | Method and Description | 
|---|---|
| Record | InternalWorkbook. findFirstRecordBySid(short sid)Returns the first occurance of a record matching a particular sid. | 
| Record | InternalSheet. findFirstRecordBySid(short sid)Returns the first occurrence of a record matching a particular sid. | 
| Record | InternalWorkbook. findNextRecordBySid(short sid,
                   int pos)Returns the next occurance of a record matching a particular sid. | 
| Record | WorkbookRecordList. get(int i) | 
| Record | RecordStream. getNext() | 
| Record | RecordStream. peekNextRecord() | 
| Modifier and Type | Method and Description | 
|---|---|
| java.util.List<Record> | InternalWorkbook. getRecords() | 
| java.util.List<Record> | WorkbookRecordList. getRecords() | 
| java.lang.Class<? extends Record> | RecordStream. peekNextClass() | 
| Modifier and Type | Method and Description | 
|---|---|
| void | WorkbookRecordList. add(int pos,
   Record r) | 
| Modifier and Type | Method and Description | 
|---|---|
| static InternalWorkbook | InternalWorkbook. createWorkbook(java.util.List<Record> recs)read support  for low level
 API. | 
| void | WorkbookRecordList. setRecords(java.util.List<Record> records) | 
| Constructor and Description | 
|---|
| RecordStream(java.util.List<Record> records,
            int startIx) | 
| RecordStream(java.util.List<Record> inputList,
            int startIndex,
            int endIx)Creates a RecordStream bounded by startIndex and endIndex | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | AbstractEscherHolderRecordThe escher container record is used to hold escher records. | 
| class  | ArrayRecordARRAY (0x0221) | 
| class  | AutoFilterInfoRecordThe AutoFilterInfo record specifies the number of columns that have AutoFilter enabled
 and indicates the beginning of the collection of AutoFilter records. | 
| class  | BackupRecordBoolean specifying whether the GUI should store a backup of the file. | 
| class  | BlankRecordRepresents a column in a row with no value but with styling. | 
| class  | BOFRecordSomewhat of a misnomer, its used for the beginning of a set of records that
 have a particular purpose or subject. | 
| class  | BookBoolRecordContains a flag specifying whether the Gui should save externally linked values from other workbooks. | 
| class  | BoolErrRecordCreates new BoolErrRecord. | 
| class  | BottomMarginRecordRecord for the bottom margin. | 
| class  | BoundSheetRecordDefines a sheet within a workbook. | 
| class  | CalcCountRecordSpecifies the maximum times the gui should perform a formula recalculation. | 
| class  | CalcModeRecordTells the gui whether to calculate formulas automatically, manually or automatically except for tables. | 
| class  | CellRecordBase class for all cell value records (implementors of  CellValueRecordInterface). | 
| class  | CFHeader12RecordConditional Formatting Header v12 record CFHEADER12 (0x0879),
  for conditional formattings introduced in Excel 2007 and newer. | 
| class  | CFHeaderBaseParent of Conditional Formatting Header records,
   CFHeaderRecordandCFHeader12Record. | 
| class  | CFHeaderRecordConditional Formatting Header record CFHEADER (0x01B0). | 
| class  | CFRule12RecordConditional Formatting v12 Rule Record (0x087A). | 
| class  | CFRuleBaseConditional Formatting Rules. | 
| class  | CFRuleRecordConditional Formatting Rule Record (0x01B1). | 
| class  | CodepageRecordThe default characterset. | 
| class  | ColumnInfoRecordDefines with width and formatting for a range of columns | 
| class  | ContinueRecordHelper class used primarily for SST Records | 
| class  | CountryRecordCountry Record (aka WIN.INI country) - used for localization | 
| class  | CRNCountRecordXCT - CRN Count | 
| class  | CRNRecordThis record stores the contents of an external cell or cell range | 
| class  | DateWindow1904RecordFlag specifying whether 1904 date windowing is used. | 
| class  | DBCellRecordUsed by Excel and other MS apps to quickly find rows in the sheets. | 
| class  | DConRefRecordDConRef records specify a range in a workbook (internal or external) that serves as a data source
 for pivot tables or data consolidation. | 
| class  | DefaultColWidthRecordSpecifies the default width for columns that have no specific width set. | 
| class  | DefaultRowHeightRecordRow height for rows with undefined or not explicitly defined heights. | 
| class  | DeltaRecordControls the accuracy of the calculations | 
| class  | DimensionsRecordProvides the minumum and maximum bounds of a sheet. | 
| class  | DrawingGroupRecord | 
| class  | DrawingRecord | 
| class  | DrawingRecordForBiffViewerThis is purely for the biff viewer. | 
| class  | DrawingSelectionRecordMsoDrawingSelection (0x00ED) | 
| class  | DSFRecordTells if this is a double stream file. | 
| class  | DVALRecordThis record is the list header of all data validation records (0x01BE) in the current sheet. | 
| class  | DVRecordThis record stores data validation settings and a list of cell ranges which contain these settings. | 
| class  | EOFRecordMarks the end of records belonging to a particular object in the HSSF File | 
| class  | EscherAggregateThis class is used to aggregate the MSODRAWING and OBJ record
 combinations. | 
| class  | ExtendedFormatRecordProbably one of the more complex records. | 
| class  | ExternalNameRecordEXTERNALNAME (0x0023) | 
| class  | ExternSheetRecordEXTERNSHEET (0x0017) | 
| class  | ExtSSTRecordExtended Static String Table (0x00FF) | 
| class  | FeatHdrRecordTitle: FeatHdr (Feature Header) Record | 
| class  | FeatRecordTitle: Feat (Feature) Record | 
| class  | FilePassRecordFile Pass Record (0x002F) | 
| class  | FileSharingRecordStores the encrypted readonly for a workbook (write protect). | 
| class  | FnGroupCountRecordumber of built in function groups in the current version of the Spreadsheet (probably only used on Windows) | 
| class  | FontRecordDescribes a font in the workbook | 
| class  | FooterRecordSpecifies the footer for a sheet | 
| class  | FormatRecordDescribes a number format -- those goofy strings like $(#,###) | 
| class  | FormulaRecordFormula Record (0x0006). | 
| class  | GridsetRecordFlag denoting whether the user specified that gridlines are used when printing. | 
| class  | GutsRecordRow/column gutter sizes | 
| class  | HCenterRecordWhether to center between horizontal margins | 
| class  | HeaderFooterBaseCommon header/footer base class | 
| class  | HeaderFooterRecordThe HEADERFOOTER record stores information added in Office Excel 2007 for headers/footers. | 
| class  | HeaderRecordSpecifies a header for a sheet | 
| class  | HideObjRecordFlag defines whether to hide placeholders and object | 
| class  | HorizontalPageBreakRecordHorizontalPageBreak (0x001B) record that stores page breaks at rows | 
| class  | HyperlinkRecordThe  HyperlinkRecord(0x01B8) wraps an HLINK-record
  from the Excel-97 format. | 
| class  | IndexRecordOccurs right after BOF, tells you where the DBCELL records are for a sheet Important for locating cells | 
| class  | InterfaceEndRecordShows where the Interface Records ends (MMS) | 
| class  | InterfaceHdrRecordDefines the beginning of Interface records (MMS) | 
| class  | IterationRecordTells whether to iterate over formula calculations or not. | 
| class  | LabelRecordLabel Record (0x0204) - read only support for strings stored directly in the cell... | 
| class  | LabelSSTRecordRefers to a string in the shared string table and is a column value. | 
| class  | LeftMarginRecordRecord for the left margin. | 
| class  | MergeCellsRecordOptional record defining a square area of cells to "merged" into one cell. | 
| class  | MMSRecorddefines how many add menu and del menu options are stored in the file. | 
| class  | MulBlankRecordRepresents a set of columns in a row with no value but with styling. | 
| class  | MulRKRecordUsed to store multiple RK numbers on a row. | 
| class  | NameCommentRecordDefines a comment associated with a specified name. | 
| class  | NameRecordDefines a named range within a workbook. | 
| class  | NoteRecordNOTE: Comment Associated with a Cell (0x001C) | 
| class  | NumberRecordNUMBER (0x0203) Contains a numeric cell value. | 
| class  | ObjectProtectRecordProtect embedded object with the lamest "security" ever invented. | 
| class  | ObjRecordOBJRECORD (0x005D) | 
| class  | PageBreakRecordRecord that contains the functionality page breaks (horizontal and vertical) | 
| class  | PaletteRecordSupports custom palettes. | 
| class  | PaneRecordDescribes the frozen and unfrozen panes. | 
| class  | PasswordRecordStores the encrypted password for a sheet or workbook (HSSF doesn't support encryption) | 
| class  | PasswordRev4RecordProtection Revision 4 password Record (0x01BC) | 
| class  | PrecisionRecordDefines whether to store with full precision or what's displayed by the gui
 (meaning have really screwed up and skewed figures or only think you do!) | 
| class  | PrintGridlinesRecordWhether to print the gridlines when you enjoy the spreadsheet on paper. | 
| class  | PrintHeadersRecordWhether or not to print the row/column headers when you enjoy your spreadsheet in the physical form. | 
| class  | PrintSetupRecordStores print setup options -- bogus for HSSF (and marked as such) | 
| class  | ProtectionRev4RecordDescribes whether this is a protected shared/tracked workbook | 
| class  | ProtectRecordDefines whether a sheet or workbook is protected (HSSF DOES NOT SUPPORT ENCRYPTION) | 
| class  | RecalcIdRecordThis record contains an ID that marks when a worksheet was last recalculated. | 
| class  | RefModeRecordDescribes which reference mode to use | 
| class  | RefreshAllRecordFlag whether to refresh all external data when loading a sheet. | 
| class  | RightMarginRecordRecord for the right margin. | 
| class  | RKRecordAn internal 32 bit number with the two most significant bits storing the type. | 
| class  | RowRecordStores the row information for the sheet. | 
| class  | SaveRecalcRecordDefines whether to recalculate before saving (set to true) | 
| class  | ScenarioProtectRecordI have no idea what a Scenario is or why on would want to protect it with the lamest "security" ever invented. | 
| class  | SCLRecordSpecifies the window's zoom magnification. | 
| class  | SelectionRecordShows the user's selection on the sheet for write set num refs to 0 | 
| class  | SharedFormulaRecordPrimarily used as an excel optimization so that multiple similar formulas are not
 written out too many times. | 
| class  | SharedValueRecordBase | 
| class  | SSTRecordStatic String Table Record (0x00FC) | 
| class  | StandardRecordSubclasses of this class (the majority of BIFF records) are non-continuable. | 
| class  | StringRecordSTRING (0x0207) | 
| class  | StyleRecordDescribes a builtin to the gui or user defined style | 
| class  | SupBookRecordA External Workbook Description (Supplemental Book). | 
| class  | TabIdRecordContains an array of sheet id's. | 
| class  | TableRecordThe record specifies a data table. | 
| class  | TableStylesRecordTABLESTYLES (0x088E) | 
| class  | TextObjectRecordThe TXO record (0x01B6) is used to define the properties of a text box. | 
| class  | TopMarginRecordRecord for the top margin. | 
| class  | UncalcedRecordIf this record occurs in the Worksheet Substream, it indicates that the formulas have not
 been recalculated before the document was saved. | 
| class  | UnknownRecordUnknown record just tells you the sid so you can figure out what records you are missing. | 
| class  | UserSViewBeginThe UserSViewBegin record specifies settings for a custom view associated with the sheet. | 
| class  | UserSViewEndThe UserSViewEnd record marks the end of the settings for a custom view associated with the sheet | 
| class  | UseSelFSRecordTells the GUI if this was written by something that can use "natural language" formulas. | 
| class  | VCenterRecordTells whether to center the sheet between vertical margins | 
| class  | VerticalPageBreakRecordVerticalPageBreak (0x001A) record that stores page breaks at columns | 
| class  | WindowOneRecordStores the attributes of the workbook window. | 
| class  | WindowProtectRecordFlags whether workbook windows are protected | 
| class  | WindowTwoRecordSheet window settings | 
| class  | WriteAccessRecordTitle: Write Access Record (0x005C) | 
| class  | WriteProtectRecordIndicated that the sheet/workbook is write protected. | 
| class  | WSBoolRecordStores workbook settings (aka its a big "everything we didn't put somewhere else") | 
| Modifier and Type | Method and Description | 
|---|---|
| Record | Record. cloneViaReserialise()Clone the current record, via a call to serialize
  it, and another to create a new record from the
  bytes. | 
| abstract Record | Record. copy() | 
| static Record | InterfaceEndRecord. create(RecordInputStream in) | 
| static Record[] | RecordFactory. createRecord(RecordInputStream in)create a record, if there are MUL records than multiple records
 are returned digested into the non-mul form. | 
| static Record | RecordFactory. createSingleRecord(RecordInputStream in) | 
| Record | RecordFactoryInputStream. nextRecord() | 
| Modifier and Type | Method and Description | 
|---|---|
| static java.util.List<Record> | RecordFactory. createRecords(java.io.InputStream in)Create an array of records from an input stream | 
| static java.lang.Class<? extends Record> | RecordFactory. getRecordClass(int sid)Debug / diagnosis method | 
| java.util.Map<EscherRecord,Record> | EscherAggregate. getShapeToObjMapping() | 
| Modifier and Type | Method and Description | 
|---|---|
| void | EscherAggregate. associateShapeToObjRecord(EscherRecord r,
                         Record objRecord)Associates an escher record to an OBJ record or a TXO record. | 
| Constructor and Description | 
|---|
| Record(Record other) | 
| Modifier and Type | Method and Description | 
|---|---|
| void | RecordAggregate.RecordVisitor. visitRecord(Record r)Implementors may call non-mutating methods on Record r. | 
| void | RecordAggregate.PositionTrackingVisitor. visitRecord(Record r) | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | AreaFormatRecordThe area format record is used to define the colours and patterns for an area. | 
| class  | AreaRecordThe area record is used to define a area chart. | 
| class  | AxisLineFormatRecordThe axis line format record defines the axis type details. | 
| class  | AxisOptionsRecordThe axis options record provides unit information and other various tidbits about the axis. | 
| class  | AxisParentRecordThe axis size and location | 
| class  | AxisRecordThe axis record defines the type of an axis. | 
| class  | AxisUsedRecordThe number of axes used on a chart. | 
| class  | BarRecordThe bar record is used to define a bar chart. | 
| class  | BeginRecordThe begin record defines the start of a block of records for a (graphing
 data object. | 
| class  | CategorySeriesAxisRecordThis record refers to a category or series axis and is used to specify label/tickmark frequency. | 
| class  | CatLabRecordCATLAB - Category Labels (0x0856) | 
| class  | ChartEndBlockRecordENDBLOCK - Chart Future Record Type End Block (0x0853) | 
| class  | ChartEndObjectRecordENDOBJECT - Chart Future Record Type End Object (0x0855) | 
| class  | ChartFormatRecordClass ChartFormatRecord (0x1014) | 
| class  | ChartFRTInfoRecordCHARTFRTINFO - Chart Future Record Type Info (0x0850) | 
| class  | ChartRecordCHART (0x1002) | 
| class  | ChartStartBlockRecordSTARTBLOCK - Chart Future Record Type Start Block (0x0852) | 
| class  | ChartStartObjectRecordSTARTOBJECT - Chart Future Record Type Start Object (0x0854) | 
| class  | ChartTitleFormatRecordCHARTTITLEFORMAT (0x1050) | 
| class  | DataFormatRecordThe data format record is used to index into a series. | 
| class  | DataLabelExtensionRecordDATALABEXT - Chart Data Label Extension (0x086A) | 
| class  | DatRecordThe dat record is used to store options for the chart. | 
| class  | DefaultDataLabelTextPropertiesRecordThe default data label text properties record identifies the text characteristics of the preceding text record. | 
| class  | EndRecordThe end record defines the end of a block of records for a (Graphing)
 data object. | 
| class  | FontBasisRecordThe font basis record stores various font metrics. | 
| class  | FontIndexRecordThe font index record indexes into the font table for the text record. | 
| class  | FrameRecordThe frame record indicates whether there is a border around the displayed text of a chart. | 
| class  | LegendRecordDefines a legend for a chart. | 
| class  | LineFormatRecordDescribes a line format record. | 
| class  | LinkedDataRecordDescribes a linked data record. | 
| class  | NumberFormatIndexRecordThe number format index record indexes format table. | 
| class  | ObjectLinkRecordLinks text to an object on the chart or identifies it as the title. | 
| class  | PlotAreaRecordpreceeds and identifies a frame as belonging to the plot area. | 
| class  | PlotGrowthRecordThe plot growth record specifies the scaling factors used when a font is scaled. | 
| class  | SeriesChartGroupIndexRecordThe series chart group index record stores the index to the CHARTFORMAT record (0 based). | 
| class  | SeriesIndexRecordlinks a series to its position in the series list. | 
| class  | SeriesLabelsRecordThe series label record defines the type of label associated with the data format record. | 
| class  | SeriesListRecordSERIESLIST (0x1016) | 
| class  | SeriesRecordThe series record describes the overall data for a series. | 
| class  | SeriesTextRecordSERIESTEXT (0x100D) | 
| class  | SeriesToChartGroupRecordIndicates the chart-group index for a series. | 
| class  | SheetPropertiesRecordDescribes a chart sheet properties record. | 
| class  | TextRecordThe text record is used to define text stored on a chart. | 
| class  | TickRecordThe Tick record defines how tick marks and label positioning/formatting | 
| class  | UnitsRecordThe units record describes units. | 
| class  | ValueRangeRecordThe value range record defines the range of the value axis. | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | ContinuableRecordCommon superclass of all records that can produce  ContinueRecords while being serialized. | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | DataItemRecordSXDI - Data Item (0x00C5) | 
| class  | ExtendedPivotTableViewFieldsRecordSXVDEX - Extended PivotTable View Fields (0x0100) | 
| class  | PageItemRecordSXPI - Page Item (0x00B6) | 
| class  | StreamIDRecordSXIDSTM - Stream ID (0x00D5) | 
| class  | ViewDefinitionRecordSXVIEW - View Definition (0x00B0) | 
| class  | ViewFieldsRecordSXVD - View Fields (0x00B1) | 
| class  | ViewSourceRecordSXVS - View Source (0x00E3) | 
| Modifier and Type | Method and Description | 
|---|---|
| protected void | HSSFSheet. insertChartRecords(java.util.List<Record> records) | 
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.