INDEX: Index Record (20Bh)

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.