OpenOffice.org’s Documentation of the Microsoft Excel File Format

Short Description
Contains a description of the binary file format of Microsoft Excel, including all available Excel versions (for Windows) from Excel 2.1 to the current …

Website: sc.openoffice.org | Filesize: 1241kb

Content
OpenOffice.org’s Documentation of the
Microsoft Excel File Format
Excel Versions 2, 3, 4, 5, 95, 97, 2000, XP, 2003
Author Daniel Rentz . mailto:dr@openoffice.org ? http://sc.openoffice.org
License Public Documentation License
Contributors Andrew C. Oliver . mailto:acoliver@apache.org ? http://jakarta.apache.org/poi/index.html
- POIFS, additional records, fixes
Yves Hiltpold, James J. Keene, Sami Kuhmonen, John Marmion, Alexander Mavrin, Mike Salter,
Stefan Schm?ker, Charles Wyble
- additional records, fixes
Other sources Hyperlinks to Wikipedia (? http://www.wikipedia.org) for various extended information
Mailing list . mailto:dev@sc.openoffice.org
Subscription . mailto:dev-subscribe@sc.openoffice.org
Download PDF ? http://sc.openoffice.org/excelfileformat.pdf
OpenOffice.org 1.x XML ? http://sc.openoffice.org/excelfileformat.sxw
OpenOffice.org 2.x XML ? http://sc.openoffice.org/excelfileformat.odt
Project started 2001-Jun-29
Last change 2007-Jun-18
Revision 1.40Contents
1 Introduction …………………………………………………………………………………………… 6
1.1 License Notices 6
1.2 Abstract 7
1.3 Byte Order 9
2 Document Structure ………………………………………………………………………………. 10
2.1 Document Types 10
2.2 The Binary Interchange File Format 13
2.3 File Structure 14
2.4 BIFF Record Structure 16
2.5 Common Record Substructures 17
3 Formulas ……………………………………………………………………………………………… 28
3.1 Common Formula Structure 28
3.2 Token Classes 32
3.3 Cell Addresses in Tokens 36
3.4 Token Overview 40
3.5 Unary Operator Tokens 44
3.6 Binary Operator Tokens 45
3.7 Function Operator Tokens 49
3.8 Constant Operand Tokens 51
3.9 Operand Tokens 54
3.10 Control Tokens 65
3.11 Built-In Sheet Functions 74
4 Worksheet/Workbook Stream …………………………………………………………………. 78
4.1 Worksheet/Workbook Stream 79
4.2 Record Order in Streams and Substreams 80
4.3 Calculation Settings Block 86
4.4 Page Settings Block 86
4.5 Sheet View Settings Block 87
4.6 Cell Formatting 88
4.7 Cell Table and Row Blocks 89
4.8 Array Formulas and Shared Formulas 95
4.9 Multiple Operation Tables 96
4.10 Internal and External References 97
4.11 Shared String Table (BIFF8) 109
2…