The term "cell records" refers to the BIFF record types that actually contain cell data. Cell records that appear in BIFF5/BIFF7/BIFF8 files are shown in the following table.
|
Record |
Contents |
|
ARRAY |
An array-entered formula |
|
BLANK |
An empty cell |
|
BOOLERR |
A Boolean or error value |
|
FORMULA |
A cell formula, stored as parse tokens |
|
LABEL |
A string constant |
|
LABELSST |
String constant that uses BIFF8 shared string table (new to BIFF8) |
|
NUMBER |
An IEEE floating-point number |
|
MULBLANK |
Multiple empty cells (new to BIFF5) |
|
MULRK |
Multiple RK numbers (new to BIFF5) |
|
RK |
An RK number |
|
RSTRING |
Cell with character formatting |
|
SHRFMLA |
A shared formula (new to BIFF5) |
|
STRING |
A string that represents the result of a formula |
Microsoft Excel stores cell records in blocks that have at most 32 rows. Each row that contains cell records has a corresponding ROW record in the block, and each block contains a DBCELL record at the end of the block. For more information about row blocks and about optimizing your code when searching for cell records, see "Finding Cell Records in BIFF Files" on page 440.