The DIMENSIONS record contains the minimum and maximum bounds of the sheet. It provides a concise indication of the sheet size.
Note that both the rwMac and colMac fields are greater by 1 than the actual last row and column. For example, a worksheet that exists between cells B3 and D6 would have the following dimensions in the dimensions record (note rows and columns are 0-based in BIFF files in which row 1 and column A are both coded as 0):
rwMic = 2 — indicates that 3 is the first row
colMic = 1 — indicates that B is the first column
rwMac = 6 — indicates that 6 is the last row
colMac = 4 — indicates that D is the last column
Record Data — BIFF8
Offset |
Name |
Size |
Contents |
4 |
rwMic |
4 |
First defined row on the sheet |
8 |
rwMac |
4 |
Last defined row on the sheet, plus 1 |
12 |
colMic |
2 |
First defined column on the sheet |
14 |
colMac |
2 |
Last defined column on the sheet, plus 1 |
16 |
(Reserved) |
2 |
Reserved; must be 0 (zero) |
Record Data — BIFF7 and earlier
Offset |
Name |
Size |
Contents |
4 |
rwMic |
2 |
First defined row on the sheet |
6 |
rwMac |
2 |
Last defined row on the sheet, plus 1 |
8 |
colMic |
2 |
First defined column on the sheet |
10 |
colMac |
2 |
Last defined column on the sheet, plus 1 |
12 |
(Reserved) |
2 |
Reserved; must be 0 (zero) |