MICROSOFT OFFICE EXCEL 97-2007
BINARY FILE FORMAT SPECIFICATION
[*.xls (97-2007) format]
Microsoft Office Excel 97-2007 Binary File Format (.xls) Specification Page 1 of 349
Microsoft Office Excel 97-2007
Binary File Format (.xls) Specification
NOTICE
This specification is provided under the Microsoft Open Specification Promise. For
further details on the Microsoft Open Specification Promise, please refer to:
http://www.microsoft.com/interop/osp/default.mspx. You are free to copy, display
and perform this specification, to make derivative works of this specification, and to
distribute the specification, however distribution rights are limited to unmodified copies
of the original specification and any redistributed copies of the specification must retain
its attribution of Microsoft’s rights in the copyright of the specification, this full notice,
and the URL to the webpage containing the most current version of the specification as
provided by Microsoft.
Microsoft may have patents, patent applications, trademarks, copyrights, or other
intellectual property rights covering subject matter in these materials. Except as
expressly provided in the Microsoft Open Specification Promise and this notice, the
furnishing of these materials does not give you any license to these patents, trademarks,
copyrights, or other intellectual property.
The information contained in this document represents the point-in-time view of
Microsoft Corporation on the issues discussed as of the date of publication. Because
Microsoft must respond to changing market conditions, it should not be interpreted to
be a commitment on the part of Microsoft, and Microsoft cannot guarantee the
accuracy of any information presented after the date of authoring.
Unless otherwise noted, the example companies, organizations, products, domain
names, e-mail addresses, logos, people, places and events depicted herein are fictitious,
and no association with any real company, organization, product, domain name, email
address, logo, person, place or event is intended or should be inferred.
©2007 Microsoft Corporation. All rights reserved.
Microsoft Office Excel 97-2007 Binary File Format (.xls) Specification Page 2 of 349
Microsoft, Windows, Windows NT, Windows Server, and Windows Vista are either
registered trademarks or trademarks of Microsoft Corporation in the United States
and/or other countries.
Microsoft Office Excel 97-2007 Binary File Format (.xls) Specification Page 3 of 349
Table of Contents
Table of Contents ................................................................................................................ 3
Introduction ....................................................................................................................... 11
File Format Versions......................................................................................................... 11
FRT Record Description ................................................................................................... 13
The Workbook Compound File ........................................................................................ 16
Simple Save (new for BIFF7 and later) ...................................................................... 17
Double Stream File ..................................................................................................... 17
Unicode Strings in BIFF8 ........................................................................................... 17
Extended Strings in East Asian Versions.............................................................. 19
Other Microsoft Excel File Formats ................................................................................. 19
BIFF Record Information ................................................................................................. 20
Record Number ........................................................................................................... 20
Record Data Length .................................................................................................... 20
Record Data ................................................................................................................ 20
Byte Swapping ............................................................................................................ 20
Indexing in BIFF Records ........................................................................................... 21
Undefined Cells in the Sheet....................................................................................... 21
Cell Records ................................................................................................................ 21
BIFF Record Order ..................................................................................................... 22
Record Descriptions .......................................................................................................... 34
1904: 1904 Date System (22h) ................................................................................... 34
ADDIN: Workbook Is an Add-in Macro (87h) .......................................................... 34
ADDMENU: Menu Addition (C2h) ........................................................................... 34
ARRAY: Array-Entered Formula (221h) ................................................................... 35
AUTOFILTER: AutoFilter Data (9Eh) ...................................................................... 36
DOPER Structures ................................................................................................ 37
AUTOFILTER12: Auto-filter Data Introduced in Excel 2007 (87Eh) ...................... 38
AUTOFILTERINFO: Drop-Down Arrow Count (9Dh) ............................................ 42
AUTOWEBPUB: Auto web publish storage (8c0h) .................................................. 42
BACKUP: Save Backup Version of the File (40h) .................................................... 43
BLANK: Cell Value, Blank Cell (201h)..................................................................... 43
BOF: Beginning of File (809h) ................................................................................... 43
BOOKBOOL: Workbook Option Flag (DAh) ........................................................... 44
BOOKEXT: Extra Book Info (863h) .......................................................................... 45
BOOLERR: Cell Value, Boolean or Error (205h) ...................................................... 47
BOTTOMMARGIN: Bottom Margin Measurement (29h) ........................................ 47
BOUNDSHEET: Sheet Information (85h) ................................................................. 48
CALCCOUNT: Iteration Count (0Ch) ....................................................................... 48
CALCMODE: Calculation Mode (0Dh) ..................................................................... 48
CELLWATCH: Cell Watch (86Ch) ........................................................................... 49
CF: Conditional Formatting Conditions (1B1h) ......................................................... 49
CF12: Conditional Formatting Condition 12 (87Ah) ................................................. 50
CFEX: Conditional Formatting Extension (87Bh) ..................................................... 54
CODENAME: VBE Object Name (42h) .................................................................... 55
Microsoft Office Excel 97-2007 Binary File Format (.xls) Specification Page 4 of 349
CODEPAGE: Default Code Page (42h) ..................................................................... 55
COLINFO: Column Formatting Information (7Dh) ................................................... 55
COMPAT12: Compatibility Checker 12 (88Ch) ........................................................ 56
COMPRESSPICTURES: Automatic Picture Compression Mode (89Bh) ................. 56
CONDFMT: Conditional Formatting Range Information (1B0h).............................. 57
CONDFMT12: Conditional Formatting Range Information 12 (879h) ..................... 57
CONTINUE: Continues Long Records (3Ch) ............................................................ 58
CONTINUEFRT: Continued FRT (812h) .................................................................. 59
CONTINUEFRT11: Continue FRT 11 (875h) ........................................................... 59
CONTINUEFRT12: Continued FRT 12 (87Fh) ......................................................... 60
COORDLIST: Polygon Object Vertex Coordinates (A9h) ........................................ 60
COUNTRY: Default Country and WIN.INI Country (8Ch) ...................................... 61
CRASHRECERR: Crash Recovery Error (865h) ....................................................... 62
CRN: Nonresident Operands (5Ah) ............................................................................ 63
CRTCOOPT: Color options for Chart series in Mac Office 11 (8cbh) ...................... 64
DATALABEXT: Chart Data Label Extension (86Ah) .............................................. 64
DATALABEXTCONTENTS: Chart Data Label Extension Contents (86Bh) ........... 65
DBCELL: Stream Offsets (D7h) ................................................................................ 66
DBQUERYEXT: Database Query Extensions (803h) ............................................... 66
DCON: Data Consolidation Information (50h) .......................................................... 70
DCONBIN: Data Consolidation Information (1B5h) ................................................. 70
DCONN: Data Connection (876h).............................................................................. 71
DCONNAME: Data Consolidation Named References (52h) ................................... 82
DCONREF: Data Consolidation References (51h) .................................................... 82
DEFAULTROWHEIGHT: Default Row Height (225h) ............................................ 82
DEFCOLWIDTH: Default Width for Columns (55h) ................................................ 83
DELMENU: Menu Deletion (C3h) ............................................................................ 83
DELTA: Iteration Increment (10h) ............................................................................. 83
DIMENSIONS: Cell Table Size (200h) ..................................................................... 84
DOCROUTE: Routing Slip Information (B8h) .......................................................... 84
DROPDOWNOBJIDS: Drop Down Object IDs Record (874h) ................................ 85
DSF: Double Stream File (161h) ................................................................................ 86
DV: Data Validation Criteria (1BEh) ......................................................................... 86
DVAL: Data Validation Information (1B2h) ............................................................. 86
DXF: Differential XF (88Dh) ..................................................................................... 87
EDG: Edition Globals (88h) ....................................................................................... 92
EOF: End of File (0Ah) .............................................................................................. 93
EXCEL9FILE: Excel 9 File (1C0h) ........................................................................... 93
EXTERNCOUNT: Number of External References (16h) ........................................ 93
EXTERNNAME: Externally Referenced Name (223h) ............................................. 93
External Name ...................................................................................................... 93
DDE Link .............................................................................................................. 94
OLE Link .............................................................................................................. 94
EXTERNSHEET: External Reference (17h) .............................................................. 95
File name Encoding .............................................................................................. 95
EXTSST: Extended Shared String Table (FFh) .......................................................... 97
- 1
- 2
- 3
前往页