BIFF Record Order

BIFF record order has changed as the file format has evolved. The simplest way to determine BIFF record order is to create a workbook in Microsoft Excel and then use the BiffView utility to examine the record order.

BIFF Records: Alphabetical Order

Record

Number

1904: 1904 Date System

22h

ADDIN: Workbook Is an Add-in Macro

87h

ADDMENU: Menu Addition

C2h

ARRAY: Array-Entered Formula

221h

AUTOFILTER: AutoFilter Data

9Eh

AUTOFILTERINFO: Drop-Down Arrow Count

9Dh

BACKUP: Save Backup Version of the File

40h

BLANK: Cell Value, Blank Cell

201h

BOF: Beginning of File

809h

BOOKBOOL: Workbook Option Flag

DAh

BOOLERR: Cell Value, Boolean or Error

205h

BOTTOMMARGIN: Bottom Margin Measurement

29h

BOUNDSHEET: Sheet Information

85h

CALCCOUNT: Iteration Count

0Ch

CALCMODE: Calculation Mode

0Dh

CF: Conditional Formatting Conditions

1B1h

CONDFMT: Conditional Formatting Range Information

1B0h

CODENAME: VBE Object Name

42h

CODEPAGE: Default Code Page

42h

COLINFO: Column Formatting Information

7Dh

CONTINUE: Continues Long Records

3Ch

COORDLIST: Polygon Object Vertex Coordinates

A9h

COUNTRY: Default Country and WIN.INI Country

8Ch

CRN: Nonresident Operands

5Ah

DBCELL: Stream Offsets

D7h

DCON: Data Consolidation Information

50h

DCONBIN: Data Consolidation Information

1B5h

DCONNAME: Data Consolidation Named References

52h

DCONREF: Data Consolidation References

51h

DEFAULTROWHEIGHT: Default Row Height

225h

DEFCOLWIDTH: Default Width for Columns

55h

DELMENU: Menu Deletion

C3h

DELTA: Iteration Increment

10h

DIMENSIONS: Cell Table Size

200h

DOCROUTE: Routing Slip Information

B8h

DSF: Double Stream File

161h

DV: Data Validation Criteria

1BEh

DVAL: Data Validation Information

1B2h

EDG: Edition Globals

88h

EOF: End of File

0Ah

EXTERNCOUNT: Number of External References

16h

EXTERNNAME: Externally Referenced Name

223h

EXTERNSHEET: External Reference

17h

EXTSST: Extended Shared String Table

FFh

FILEPASS: File Is Password-Protected

2Fh

FILESHARING: File-Sharing Information

5Bh

FILESHARING2: File-Sharing Information for Shared Lists

1A5h

FILTERMODE: Sheet Contains Filtered List

9Bh

FNGROUPCOUNT: Built-in Function Group Count

9Ch

FNGROUPNAME: Function Group Name

9Ah

FONT: Font Description

231h

FOOTER: Print Footer on Each Page

15h

FORMAT: Number Format

41Eh

FORMULA: Cell Formula

406h

GCW: Global Column-Width Flags

ABh

GRIDSET: State Change of Gridlines Option

82h

GUTS: Size of Row and Column Gutters

80h

HCENTER: Center Between Horizontal Margins

83h

HEADER: Print Header on Each Page

14h

HIDEOBJ: Object Display Options

8Dh

HLINK: Hyperlink

1B8h

HORIZONTALPAGEBREAKS: Explicit Row Page Breaks

1Bh

IMDATA: Image Data

7Fh

INDEX: Index Record

20Bh

INTERFACEEND: End of User Interface Records

E2h

INTERFACEHDR: Beginning of User Interface Records

E1h

ITERATION: Iteration Mode

11h

LABEL: Cell Value, String Constant

204h

LABELSST: Cell Value, String Constant/SST

FDh

LEFTMARGIN: Left Margin Measurement

26h

LHNGRAPH: Named Graph Information

95h

LHRECORD: .WK? File Conversion Information

94h

LPR: Sheet Was Printed Using LINE.PRINT(

98h

MMS: ADDMENU/DELMENU Record Group Count

C1h

MSODRAWING: Microsoft Office Drawing

ECh

MSODRAWINGGROUP: Microsoft Office Drawing Group

EBh

MSODRAWINGSELECTION: Microsoft Office Drawing Selection

EDh

MULBLANK: Multiple Blank Cells

BEh

MULRK: Multiple RK Cells

BDh

NAME: Defined Name

218h

NOTE: Comment Associated with a Cell

1Ch

NUMBER: Cell Value, Floating-Point Number

203h

OBJ: Describes a Graphic Object

5Dh

OBJPROTECT: Objects Are Protected

63h

OBPROJ: Visual Basic Project

D3h

OLESIZE: Size of OLE Object

DEh

PALETTE: Color Palette Definition

92h

PANE: Number of Panes and Their Position

41h

PARAMQRY: Query Parameters

DCh

PASSWORD: Protection Password

13h

PLS: Environment-Specific Print Record

4Dh

PRECISION: Precision

0Eh

PRINTGRIDLINES: Print Gridlines Flag

2Bh

PRINTHEADERS: Print Row/Column Labels

2Ah

PROTECT: Protection Flag

12h

PROT4REV: Shared Workbook Protection Flag

1AFh

QSI: External Data Range

1ADh

RECIPNAME: Recipient Name

B9h

REFMODE: Reference Mode

0Fh

REFRESHALL: Refresh Flag

1B7h

RIGHTMARGIN: Right Margin Measurement

27h

RK: Cell Value, RK Number

7Eh

ROW: Describes a Row

208h

RSTRING: Cell with Character Formatting

D6h

SAVERECALC: Recalculate Before Save

5Fh

SCENARIO: Scenario Data

AFh

SCENMAN: Scenario Output Data

AEh

SCENPROTECT: Scenario Protection

DDh

SCL: Window Zoom Magnification

A0h

SELECTION: Current Selection

1Dh

SETUP: Page Setup

A1h

SHRFMLA: Shared Formula

BCh

SORT: Sorting Options

90h

SOUND: Sound Note

96h

SST: Shared String Table

FCh

STANDARDWIDTH: Standard Column Width

99h

STRING: String Value of a Formula

207h

STYLE: Style Information

293h

SUB: Subscriber

91h

SUPBOOK: Supporting Workbook

1AEh

SXDB: PivotTable Cache Data

C6h

SXDBEX: PivotTable Cache Data

122h

SXDI: Data Item

C5h

SXEX: PivotTable View Extended Information

F1h

SXEXT: External Source Information

DCh

SXFDBTYPE: SQL Datatype Identifier

1BBh

SXFILT: PivotTable Rule Filter

F2h

SXFORMAT: PivotTable Format Record

FBh

SXFORMULA: PivotTable Formula Record

103h

SXFMLA: PivotTable Parsed Expression

F9h

SXIDSTM: Stream ID

D5h

SXIVD: Row/Column Field IDs

B4h

SXLI: Line Item Array

B5h

SXNAME: PivotTable Name

F6h

SXPAIR: PivotTable Name Pair

F8h

SXPI: Page Item

B6h

SXRULE: PivotTable Rule Data

F0h

SXSTRING: String

CDh

SXSELECT: PivotTable Selection Information

F7h

SXTBL: Multiple Consolidation Source Info

D0h

SXTBPG: Page Item Indexes

D2h

SXTBRGIITM: Page Item Name Count

D1h

SXVD: View Fields

B1h

SXVDEX: Extended PivotTable View Fields

100h

SXVI: View Item

B2h

SXVIEW: View Definition

B0h

SXVS: View Source

E3h

TABID: Sheet Tab Index Array

13Dh

TABIDCONF: Sheet Tab ID of Conflict History

EAh

TABLE: Data Table

236h

TEMPLATE: Workbook Is a Template

60h

TOPMARGIN: Top Margin Measurement

28h

TXO: Text Object

1B6h

UDDESC: Description String for Chart Autoformat

DFh

UNCALCED: Recalculation Status

5Eh

USERBVIEW: Workbook Custom View Settings

1A9h

USERSVIEWBEGIN: Custom View Settings

1AAh

USERSVIEWEND: End of Custom View Records

1ABh

USESELFS: Natural Language Formulas Flag

160h

VCENTER: Center Between Vertical Margins

84h

VERTICALPAGEBREAKS: Explicit Column Page Breaks

1Ah

WINDOW1: Window Information

3Dh

WINDOW2: Sheet Window Information

23Eh

WINDOWPROTECT: Windows Are Protected

19h

WRITEACCESS: Write Access User Name

5Ch

WRITEPROT: Workbook Is Write-Protected

86h

WSBOOL: Additional Workspace Information

81h

XCT: CRN Record Count

59h

XF: Extended Format

E0h

XL5MODIFY: Flag for DSF

162h


BIFF Records: Record Number Order

Number

Record

0Ah

EOF: End of File

0Ch

CALCCOUNT: Iteration Count

0Dh

CALCMODE: Calculation Mode

0Eh

PRECISION: Precision

0Fh

REFMODE: Reference Mode

10h

DELTA: Iteration Increment

11h

ITERATION: Iteration Mode

12h

PROTECT: Protection Flag

13h

PASSWORD: Protection Password

14h

HEADER: Print Header on Each Page

15h

FOOTER: Print Footer on Each Page

16h

EXTERNCOUNT: Number of External References

17h

EXTERNSHEET: External Reference

19h

WINDOWPROTECT: Windows Are Protected

1Ah

VERTICALPAGEBREAKS: Explicit Column Page Breaks

1Bh

HORIZONTALPAGEBREAKS: Explicit Row Page Breaks

1Ch

NOTE: Comment Associated with a Cell

1Dh

SELECTION: Current Selection

22h

1904: 1904 Date System

26h

LEFTMARGIN: Left Margin Measurement

27h

RIGHTMARGIN: Right Margin Measurement

28h

TOPMARGIN: Top Margin Measurement

29h

BOTTOMMARGIN: Bottom Margin Measurement

2Ah

PRINTHEADERS: Print Row/Column Labels

2Bh

PRINTGRIDLINES: Print Gridlines Flag

2Fh

FILEPASS: File Is Password-Protected

3Ch

CONTINUE: Continues Long Records

3Dh

WINDOW1: Window Information

40h

BACKUP: Save Backup Version of the File

41h

PANE: Number of Panes and Their Position

42h

CODENAME: VBE Object Name

42h

CODEPAGE: Default Code Page

4Dh

PLS: Environment-Specific Print Record

50h

DCON: Data Consolidation Information

51h

DCONREF: Data Consolidation References

52h

DCONNAME: Data Consolidation Named References

55h

DEFCOLWIDTH: Default Width for Columns

59h

XCT: CRN Record Count

5Ah

CRN: Nonresident Operands

5Bh

FILESHARING: File-Sharing Information

5Ch

WRITEACCESS: Write Access User Name

5Dh

OBJ: Describes a Graphic Object

5Eh

UNCALCED: Recalculation Status

5Fh

SAVERECALC: Recalculate Before Save

60h

TEMPLATE: Workbook Is a Template

63h

OBJPROTECT: Objects Are Protected

7Dh

COLINFO: Column Formatting Information

7Eh

RK: Cell Value, RK Number

7Fh

IMDATA: Image Data

80h

GUTS: Size of Row and Column Gutters

81h

WSBOOL: Additional Workspace Information

82h

GRIDSET: State Change of Gridlines Option

83h

HCENTER: Center Between Horizontal Margins

84h

VCENTER: Center Between Vertical Margins

85h

BOUNDSHEET: Sheet Information

86h

WRITEPROT: Workbook Is Write-Protected

87h

ADDIN: Workbook Is an Add-in Macro

88h

EDG: Edition Globals

89h

PUB: Publisher

8Ch

COUNTRY: Default Country and WIN.INI Country

8Dh

HIDEOBJ: Object Display Options

90h

SORT: Sorting Options

91h

SUB: Subscriber

92h

PALETTE: Color Palette Definition

94h

LHRECORD: .WK? File Conversion Information

95h

LHNGRAPH: Named Graph Information

96h

SOUND: Sound Note

98h

LPR: Sheet Was Printed Using LINE.PRINT(

99h

STANDARDWIDTH: Standard Column Width

9Ah

FNGROUPNAME: Function Group Name

9Bh

FILTERMODE: Sheet Contains Filtered List

9Ch

FNGROUPCOUNT: Built-in Function Group Count

9Dh

AUTOFILTERINFO: Drop-Down Arrow Count

9Eh

AUTOFILTER: AutoFilter Data

A0h

SCL: Window Zoom Magnification

A1h

SETUP: Page Setup

A9h

COORDLIST: Polygon Object Vertex Coordinates

ABh

GCW: Global Column-Width Flags

AEh

SCENMAN: Scenario Output Data

AFh

SCENARIO: Scenario Data

B0h

SXVIEW: View Definition

B1h

SXVD: View Fields

B2h

SXVI: View Item

B4h

SXIVD: Row/Column Field IDs

B5h

SXLI: Line Item Array

B6h

SXPI: Page Item

B8h

DOCROUTE: Routing Slip Information

B9h

RECIPNAME: Recipient Name

BCh

SHRFMLA: Shared Formula

BDh

MULRK: Multiple RK Cells

BEh

MULBLANK: Multiple Blank Cells

C1h

MMS: ADDMENU/DELMENU Record Group Count

C2h

ADDMENU: Menu Addition

C3h

DELMENU: Menu Deletion

C5h

SXDI: Data Item

C6h

SXDB: PivotTable Cache Data

CDh

SXSTRING: String

D0h

SXTBL: Multiple Consolidation Source Info

D1h

SXTBRGIITM: Page Item Name Count

D2h

SXTBPG: Page Item Indexes

D3h

OBPROJ: Visual Basic Project

D5h

SXIDSTM: Stream ID

D6h

RSTRING: Cell with Character Formatting

D7h

DBCELL: Stream Offsets

DAh

BOOKBOOL: Workbook Option Flag

DCh

PARAMQRY: Query Parameters

DCh

SXEXT: External Source Information

DDh

SCENPROTECT: Scenario Protection

DEh

OLESIZE: Size of OLE Object

DFh

UDDESC: Description String for Chart Autoformat

E0h

XF: Extended Format

E1h

INTERFACEHDR: Beginning of User Interface Records

E2h

INTERFACEEND: End of User Interface Records

E3h

SXVS: View Source

EAh

TABIDCONF: Sheet Tab ID of Conflict History

EBh

MSODRAWINGGROUP: Microsoft Office Drawing Group

ECh

MSODRAWING: Microsoft Office Drawing

EDh

MSODRAWINGSELECTION: Microsoft Office Drawing Selection

F0h

SXRULE: PivotTable Rule Data

F1h

SXEX: PivotTable View Extended Information

F2h

SXFILT: PivotTable Rule Filter

F6h

SXNAME: PivotTable Name

F7h

SXSELECT: PivotTable Selection Information

F8h

SXPAIR: PivotTable Name Pair

F9h

SXFMLA: PivotTable Parsed Expression

FBh

SXFORMAT: PivotTable Format Record

FCh

SST: Shared String Table

FDh

LABELSST: Cell Value, String Constant/SST

FFh

EXTSST: Extended Shared String Table

100h

SXVDEX: Extended PivotTable View Fields

103h

SXFORMULA: PivotTable Formula Record

122h

SXDBEX: PivotTable Cache Data

13Dh

TABID: Sheet Tab Index Array

160h

USESELFS: Natural Language Formulas Flag

161h

DSF: Double Stream File

162h

XL5MODIFY: Flag for DSF

1A5h

FILESHARING2: File-Sharing Information for Shared Lists

1A9h

USERBVIEW: Workbook Custom View Settings

1AAh

USERSVIEWBEGIN: Custom View Settings

1ABh

USERSVIEWEND: End of Custom View Records

1ADh

QSI: External Data Range

1AEh

SUPBOOK: Supporting Workbook

1AFh

PROT4REV: Shared Workbook Protection Flag

1B0h

CONDFMT: Conditional Formatting Range Information

1B1h

CF: Conditional Formatting Conditions

1B2h

DVAL: Data Validation Information

1B5h

DCONBIN: Data Consolidation Information

1B6h

TXO: Text Object

1B7h

REFRESHALL: Refresh Flag

1B8h

HLINK: Hyperlink

1BBh

SXFDBTYPE: SQL Datatype Identifier

1BCh

PROT4REVPASS: Shared Workbook Protection Password

1BEh

DV: Data Validation Criteria

200h

DIMENSIONS: Cell Table Size

201h

BLANK: Cell Value, Blank Cell

203h

NUMBER: Cell Value, Floating-Point Number

204h

LABEL: Cell Value, String Constant

205h

BOOLERR: Cell Value, Boolean or Error

207h

STRING: String Value of a Formula

208h

ROW: Describes a Row

20Bh

INDEX: Index Record

218h

NAME: Defined Name

221h

ARRAY: Array-Entered Formula

223h

EXTERNNAME: Externally Referenced Name

225h

DEFAULTROWHEIGHT: Default Row Height

231h

FONT: Font Description

236h

TABLE: Data Table

23Eh

WINDOW2: Sheet Window Information

293h

STYLE: Style Information

406h

FORMULA: Cell Formula

41Eh

FORMAT: Number Format

809h

BOF: Beginning of File