| Package | Description | 
|---|---|
| org.apache.poi.hssf.record | Record package contains class representations for XLS binary strutures. | 
| org.apache.poi.hssf.record.chart | |
| org.apache.poi.hssf.record.pivottable | 
| Modifier and Type | Class and Description | 
|---|---|
| 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  | DrawingRecord | 
| 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  | ExtendedFormatRecordProbably one of the more complex records. | 
| class  | ExternalNameRecordEXTERNALNAME (0x0023) | 
| class  | ExternSheetRecordEXTERNSHEET (0x0017) | 
| 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  | 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  | 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  | 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  | 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  | 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 | 
|---|---|
| abstract StandardRecord | StandardRecord. copy() | 
| Constructor and Description | 
|---|
| StandardRecord(StandardRecord other) | 
| 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  | 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) | 
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.