This record stores the sheet name, sheet type, and stream position.
BIFF8 Record Data
|
Offset |
Name |
Size |
Contents |
|
4 |
lbPlyPos |
4 |
Stream position of the start of the BOF record for the sheet |
|
8 |
grbit |
2 |
Option flags |
|
10 |
cch |
2 |
Length of the sheet name |
|
12 |
rgch |
var |
Sheet name |
BIFF7 Record Data
|
Offset |
Name |
Size |
Contents |
|
4 |
lbPlyPos |
4 |
Stream position of the start of the BOF record for the sheet |
|
8 |
grbit |
2 |
Option flags |
|
10 |
cch |
1 |
Length of the sheet name |
|
11 |
rgch |
var |
Sheet name |
The grbit field contains the options listed in the following table.
|
Offset |
Bits |
Mask |
Name |
Contents |
|
0 |
7 – 0 |
0Fh |
dt |
Sheet type: |
|
1 |
1–0 |
03h |
hsState |
Hidden state: |
|
7 – 2 |
FCh |
(Reserved) | ||
A Visual Basic procedure can set the Visible property of a sheet to create a very hidden sheet. A very hidden sheet can be made visible again by a Visual Basic procedure, but there is no way to make the sheet visible through the user interface of Microsoft Excel.