Uses of Class
org.apache.poi.hssf.record.Record

Packages that use Record
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.chart   
org.apache.poi.hssf.record.cont   
org.apache.poi.hssf.record.pivottable   
org.apache.poi.hssf.usermodel usermodel package maps HSSF low level strutures to familiar workbook/sheet model 
 

Uses of Record in org.apache.poi.hssf.dev
 

Methods in org.apache.poi.hssf.dev that return Record
static Record[] BiffViewer.createRecords(java.io.InputStream is, java.io.PrintStream ps, org.apache.poi.hssf.dev.BiffViewer.BiffRecordListener recListener, boolean dumpInterpretedRecords)
          Create an array of records from an input stream
 

Uses of Record in org.apache.poi.hssf.eventmodel
 

Methods in org.apache.poi.hssf.eventmodel with parameters of type Record
 boolean ERFListener.processRecord(Record rec)
          Process a Record.
 

Uses of Record in org.apache.poi.hssf.eventusermodel
 

Methods in org.apache.poi.hssf.eventusermodel with parameters of type Record
abstract  short AbortableHSSFListener.abortableProcessRecord(Record record)
          Process an HSSF Record.
 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 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 EventWorkbookBuilder.SheetRecordCollectingListener.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 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.
 

Uses of Record in org.apache.poi.hssf.eventusermodel.dummyrecord
 

Subclasses of Record in org.apache.poi.hssf.eventusermodel.dummyrecord
 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
 

Uses of Record in org.apache.poi.hssf.model
 

Methods in org.apache.poi.hssf.model that return Record
 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()
           
 

Methods in org.apache.poi.hssf.model that return types with arguments of type Record
 java.util.List<Record> WorkbookRecordList.getRecords()
           
 java.util.List<Record> InternalWorkbook.getRecords()
           
 java.util.Iterator<Record> WorkbookRecordList.iterator()
           
 java.lang.Class<? extends Record> RecordStream.peekNextClass()
           
 

Methods in org.apache.poi.hssf.model with parameters of type Record
 void WorkbookRecordList.add(int pos, Record r)
           
 

Method parameters in org.apache.poi.hssf.model with type arguments of type Record
static InternalWorkbook InternalWorkbook.createWorkbook(java.util.List<Record> recs)
          read support for low level API.
 void WorkbookRecordList.setRecords(java.util.List<Record> records)
           
 

Constructor parameters in org.apache.poi.hssf.model with type arguments of type Record
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
 

Uses of Record in org.apache.poi.hssf.record
 

Subclasses of Record in org.apache.poi.hssf.record
 class AbstractEscherHolderRecord
          The escher container record is used to hold escher records.
 class ArrayRecord
          ARRAY (0x0221)

Treated in a similar way to SharedFormulaRecord

 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)

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)

 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)

Description: This record stores the contents of an external cell or cell range

REFERENCE: OOO 5.23

 class DateWindow1904Record
          Title: Date Window 1904 Flag record
 class DBCellRecord
          Title: DBCell Record (0x00D7)

Description: Used by Excel and other MS apps to quickly find rows in the sheets.

 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)

Description: controls the accuracy of the calculations

REFERENCE: PG 303 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)

 class DimensionsRecord
          Title: Dimensions Record
 class DrawingGroupRecord
           
 class DrawingRecord
          DrawingRecord (0x00EC)

 class DrawingRecordForBiffViewer
          This is purely for the biff viewer.
 class DrawingSelectionRecord
          MsoDrawingSelection (0x00ED)

Reference: [MS-OGRAPH].pdf sec 2.4.69

 class DSFRecord
          Title: Double Stream Flag Record (0x0161)

Description: tells if this is a double stream file.

 class 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.

 class DVRecord
          Title: DATAVALIDATION Record (0x01BE)

Description: This record stores data validation settings and a list of cell ranges which contain these settings.

 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)

Description: This record is used for a quick lookup into the SST record.

 class FeatHdrRecord
          Title: FeatHdr (Feature Header) Record
 class FeatRecord
          Title: Feat (Feature) Record
 class FilePassRecord
          Title: File Pass Record (0x002F)

Description: Indicates that the record after this record are encrypted.

 class 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)

 class FnGroupCountRecord
          Title: Function Group Count Record
 class FontRecord
          Title: Font Record (0x0031)

- describes a font in the workbook (index = 0-3,5-infinity - skip 4)

 class FooterRecord
          Title: Footer Record (0x0015)

Description: Specifies the footer for a sheet

 class 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)

 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)

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)

 class InterfaceEndRecord
          Title: Interface End Record (0x00E2)
 class InterfaceHdrRecord
          Title: Interface Header Record (0x00E1)
 class 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!)

 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)

Description: Represents a set of columns in a row with no value but with styling.

 class MulRKRecord
          MULRK (0x00BD)

Used to store multiple RK numbers on a row.

 class NameCommentRecord
          Title: NAMECMT Record (0x0894)

Description: Defines a comment associated with a specified name.

 class NameRecord
          Title: DEFINEDNAME Record (0x0018)

Description: Defines a named range within a workbook.

 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)

The obj record is used to hold various graphic objects and controls.

 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)

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)

 class PasswordRev4Record
          Title: Protection Revision 4 password Record (0x01BC)

Description: Stores the (2 byte??!!) encrypted password for a shared workbook

REFERENCE: PG 374 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)

 class PrecisionRecord
          Title: Precision Record
 class PrintGridlinesRecord
          Title: Print Gridlines Record
 class PrintHeadersRecord
          Title: Print Headers Record
 class 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

 class ProtectionRev4Record
          Title: Protection Revision 4 Record (0x01AF)

Description: describes whether this is a protected shared/tracked workbook

REFERENCE: PG 373 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)

 class ProtectRecord
          Title: Protect Record (0x0012)

Description: defines whether a sheet or workbook is protected (HSSF DOES NOT SUPPORT ENCRYPTION)

HSSF now supports the simple "protected" sheets (where they are not encrypted and open office et al ignore the password record entirely).

 class RecalcIdRecord
          Title: Recalc Id Record (0x01C1)

Description: This record contains an ID that marks when a worksheet was last recalculated.

 class RefModeRecord
          Title: RefMode Record
 class RefreshAllRecord
          Title: Refresh All Record (0x01B7)

Description: Flag whether to refresh all external data when loading a sheet.

 class RightMarginRecord
          Record for the right margin.

 class RKRecord
          Title: RK Record (0x027E)

Description: An internal 32 bit number with the two most significant bits storing the type.

 class RowRecord
          Title: Row Record (0x0208)

Description: stores the row information for the sheet.

 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
          Common base class for SharedFormulaRecord, ArrayRecord and TableRecord which are have similarities.
 class SSTRecord
          Title: Static String Table Record (0x00FC)

Description: This holds all the strings for LabelSSTRecords.

 class StandardRecord
          Subclasses of this class (the majority of BIFF records) are non-continuable.
 class StringRecord
          STRING (0x0207)

Stores the cached result of a text formula

 class StyleRecord
          Title: Style Record (0x0293)

Description: Describes a builtin to the gui or user defined style

 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 TabIdRecord
          Title: Sheet Tab Index Array Record (0x013D)

Description: Contains an array of sheet id's.

 class TableRecord
          DATATABLE (0x0236)

TableRecord - The record specifies a data table.

 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)

Description: Unknown record just tells you the sid so you can figure out what records you are missing.

 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

Description: Tells the GUI if this was written by something that can use "natural language" formulas.

 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)

Description: flags whether workbook windows are protected

REFERENCE: PG 424 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)

 class WindowTwoRecord
          Title: Window Two Record
 class 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)

 class WriteProtectRecord
          Title: Write Protect Record
 class WSBoolRecord
          Title: WSBOOL (0x0081) (called SHEETPR in OOO doc)

Description: stores workbook settings (aka its a big "everything we didn't put somewhere else")

 

Methods in org.apache.poi.hssf.record that return Record
 Record Record.cloneViaReserialise()
          Clone the current record, via a call to serialize it, and another to create a new record from the bytes.
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()
          Returns the next (complete) record from the stream, or null if there are no more.
 

Methods in org.apache.poi.hssf.record that return types with arguments of type Record
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
Gets the POI implementation class for a given sid.
 

Uses of Record in org.apache.poi.hssf.record.aggregates
 

Methods in org.apache.poi.hssf.record.aggregates with parameters of type Record
 void RecordAggregate.RecordVisitor.visitRecord(Record r)
          Implementors may call non-mutating methods on Record r.
 void RecordAggregate.PositionTrackingVisitor.visitRecord(Record r)
           
 

Uses of Record in org.apache.poi.hssf.record.chart
 

Subclasses of Record in org.apache.poi.hssf.record.chart
 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)

(As with all chart related records, documentation is lacking.

 class ChartFRTInfoRecord
          CHARTFRTINFO - Chart Future Record Type Info (0x0850)
 class ChartRecord
          CHART (0x1002)

The chart record is used to define the location and size of a chart.

Chart related records don't seem to be covered in either the OOO or the MS documentation.

 class ChartStartBlockRecord
          STARTBLOCK - Chart Future Record Type Start Block (0x0852)
 class ChartStartObjectRecord
          STARTOBJECT - Chart Future Record Type Start Object (0x0854)
 class ChartTitleFormatRecord
          CHARTTITLEFORMAT (0x1050)

Describes the formatting runs associated with a chart title.

 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)

The series list record defines the series displayed as an overlay to the main chart record.
(As with all chart related records, documentation is lacking.

 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.

 

Uses of Record in org.apache.poi.hssf.record.cont
 

Subclasses of Record in org.apache.poi.hssf.record.cont
 class ContinuableRecord
          Common superclass of all records that can produce ContinueRecords while being serialized.
 

Uses of Record in org.apache.poi.hssf.record.pivottable
 

Subclasses of Record in org.apache.poi.hssf.record.pivottable
 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)
 

Uses of Record in org.apache.poi.hssf.usermodel
 

Method parameters in org.apache.poi.hssf.usermodel with type arguments of type Record
protected  void HSSFSheet.insertChartRecords(java.util.List<Record> records)
           
 



Copyright 2012 The Apache Software Foundation or its licensors, as applicable.