Microsoft Excel writes an INDEX record immediately after the BOF record for each worksheet substream in a BIFF file. For more information about the INDEX record, see "Finding Cell Records in BIFF Files" on page 440.
Record Data — BIFF8
|
Offset |
Name |
Size |
Contents |
|
4 |
(Reserved) |
4 |
Reserved; must be 0 (zero) |
|
8 |
rwMic |
4 |
First row that exists on the sheet |
|
12 |
rwMac |
4 |
Last row that exists on the sheet, plus 1 |
|
16 |
(Reserved) |
4 |
Reserved; must be 0 (zero) |
|
20 |
rgibRw |
var |
Array of file offsets to the DBCELL records for each block of ROW records. A block contains ROW records for up to 32 rows. For more information, see "Finding Cell Records in BIFF Files" on page 440. |
Record Data — BIFF7 and earlier
|
Offset |
Name |
Size |
Contents |
|
4 |
(Reserved) |
4 |
Reserved; must be 0 (zero) |
|
8 |
rwMic |
2 |
First row that exists on the sheet |
|
10 |
rwMac |
2 |
Last row that exists on the sheet, plus 1 |
|
12 |
(Reserved) |
4 |
Reserved; must be 0 (zero) |
|
16 |
rgibRw |
var |
Array of file offsets to the DBCELL records for each block of ROW records. A block contains ROW records for up to 32 rows. For more information, see "Finding Cell Records in BIFF Files" on page 440. |
The rwMic field contains the number of the first row in the sheet that contains a value or a formula that is referenced by a cell in some other row. Because rows (and columns) are always stored 0-based rather than 1-based (as they appear on the screen), cell A1 is stored as row 0, cell A2 is row 1, and so on. The rwMac field contains the 0-based number of the last row in the sheet, plus 1.