The Microsoft Excel File Format
's Documentation of the
Microsoft Excel File Format
Excel Versions 2, 3, 4, 5, 95, 97, 2000, XP, 2003
Author
Daniel Rentz ? mailto:dr@ üÐ
License
Public Documentation License
Contributors
Yves Hiltpold, James J. Keene, Sami Kuhmonen, John Marmion, Alexander Mavrin,
Josh Micich, Andrew C. Oliver, Mike Salter, Stefan Schm?cker, Charles Wyble
Other sources
Hyperlinks to Wikipedia (üÐ ) for various extended information
Mailing list
? mailto:dev@sc.
Subscription ? mailto:dev-subscribe@sc.
Download
PDF üÐ
1.x XML üÐ
2.x XML üÐ
Project started
2001-Jun-29
Last change
2008-Apr-02
Revision
1.42
Contents
1 Introduction ......................................................................................................... 6
1.1
1.2
1.3
License Notices
Abstract
Byte Order
6
7
9
2 Document Structure ........................................................................................... 10
2.1
2.2
2.3
2.4
2.5
Document Types
The Binary Interchange File Format
File Structure
BIFF Record Structure
Common Record Substructures
10
13
14
16
17
3 Formulas ............................................................................................................ 28
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
3.10
3.11
Common Formula Structure
Token Classes
Cell Addresses in Tokens
Token Overview
Unary Operator Tokens
Binary Operator Tokens
Function Operator Tokens
Constant Operand Tokens
Operand Tokens
Control Tokens
Built-In Sheet Functions
28
32
36
40
44
45
49
51
54
65
74
4 Worksheet/Workbook Stream ............................................................................ 79
4.1
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.9
4.10
4.11
2
Worksheet/Workbook Stream
Record Order in Streams and Substreams
Calculation Settings Block
Page Settings Block
Sheet View Settings Block
Cell Formatting
Cell Table and Row Blocks
Array Formulas and Shared Formulas
Multiple Operation Tables
Internal and External References
Shared String Table (BIFF8)
80
81
87
87
88
89
90
96
97
98
110
4.12
4.13
4.14
4.15
4.16
4.17
4.18
4.19
Conditional Formatting Table (BIFF8)
Hyperlink Table (BIFF8)
Data Validity Table (BIFF8)
AutoFilter, Advanced Filter
Scenarios
Web Queries (BIFF8)
Worksheet/Workbook Protection
File Protection
112
112
112
113
113
113
114
117
5 Worksheet/Workbook Records ........................................................................ 120
5.1
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
5.10
5.11
5.12
5.13
5.14
5.15
5.16
5.17
5.18
5.19
5.20
5.21
5.22
5.23
5.24
5.25
5.26
5.27
5.28
5.29
5.30
5.31
5.32
5.33
5.34
5.35
5.36
5.37
5.38
5.39
5.40
5.41
5.42
5.43
5.44
5.45
5.46
Overview, Ordered by Record Identifier
Overview, Ordered by Record Names
Overview, Ordered by BIFF Versions
ARRAY
BACKUP
BITMAP
BLANK
BOF ¨C Beginning of File
BOOKBOOL
BOOLERR
BOTTOMMARGIN
BUILTINFMTCOUNT
CALCCOUNT
CALCMODE
CFHEADER
CFRULE ¨C Conditional Formatting Rule
CODEPAGE
COLINFO
COLUMNDEFAULT
COLWIDTH
CONTINUE
COUNTRY
CRN
DATATABLE ¨C Multiple Operation Table
DATATABLE2 ¨C Multiple Operation Table
DATAVALIDATION
DATAVALIDATIONS
DATEMODE
DBCELL
DCONREF ¨C Data Consolidation Reference
DEFAULTROWHEIGHT
DEFCOLWIDTH
DEFINEDNAME
DELTA
DIMENSION
DSF ¨C Double Stream File
EOF ¨C End of File
EXTERNALBOOK ¨C External Workbook
EXTERNALNAME
EXTERNCOUNT
EXTERNSHEET
EXTSST ¨C Extended SST
FILEPASS
FILESHARING
FONT
FONT2
120
124
127
132
133
133
134
135
137
137
138
138
139
139
139
140
145
146
147
147
148
149
150
151
152
153
154
154
155
155
156
156
157
160
160
161
161
162
164
166
166
167
168
170
171
173
3
5.47
5.48
5.49
5.50
5.51
5.52
5.53
5.54
5.55
5.56
5.57
5.58
5.59
5.60
5.61
5.62
5.63
5.64
5.65
5.66
5.67
5.68
5.69
5.70
5.71
5.72
5.73
5.74
5.75
5.76
5.77
5.78
5.79
5.80
5.81
5.82
5.83
5.84
5.85
5.86
5.87
5.88
5.89
5.90
5.91
5.92
5.93
5.94
5.95
5.96
5.97
5.98
5.99
5.100
5.101
5.102
5.103
4
FONTCOLOR
FOOTER
FORMAT
FORMULA
GCW ¨C Global Column Width
GRIDSET
GUTS
HCENTER
HEADER
HIDEOBJ
HORIZONTALPAGEBREAKS
HYPERLINK
INDEX
INTEGER
ITERATION
IXFE ¨C Index to XF
LABEL
LABELRANGES
LABELSST
LEFTMARGIN
MERGEDCELLS
MULBLANK ¨C Multiple BLANK
MULRK ¨C Multiple RK
NOTE
NUMBER
OBJECTPROTECT
PAGESETUP
PALETTE
PANE
PASSWORD
PHONETICPR
PLS
PRECISION
PRINTGRIDLINES
PRINTHEADERS
PROTECT
QUICKTIP
RANGEPROTECTION
REFMODE
RIGHTMARGIN
RK
ROW
RSTRING
SAVERECALC
SCENPROTECT
SCL
SELECTION
SHAREDFMLA ¨C Shared Formula
SHEET
SHEETLAYOUT
SHEETPR
SHEETPROTECTION
SORT
SST ¨C Shared String Table
STANDARDWIDTH
STRING
STYLE
173
173
174
176
178
179
179
179
180
181
181
182
185
186
186
186
187
187
188
188
188
189
189
190
191
191
192
195
197
197
198
198
198
199
199
200
200
200
201
201
201
202
204
204
205
205
205
206
206
207
207
208
209
210
210
211
212
5.104 TOPMARGIN
5.105 UNCALCED
5.106 USESELFS
5.107 VCENTER
5.108 VERTICALPAGEBREAKS
5.109 WINDOW1
5.110 WINDOW2
5.111 WINDOWPROTECT
5.112 WRITEACCESS
5.113 WRITEPROT
5.114 XCT ¨C CRN Count
5.115 XF ¨C Extended Format
213
213
213
214
214
215
216
217
218
218
218
219
6 Drawing Objects .............................................................................................. 225
7 Charts ............................................................................................................... 226
7.1
7.2
7.3
7.4
7.5
7.6
7.7
7.8
7.9
7.10
7.11
7.12
7.13
Document Integration
General Chart Structure
Common Record Blocks
Record Overview, Ordered by Identifier
Record Overview, Ordered by Name
CHAREAFORMAT
CHAXISLINE
CHBEGIN ¨C Begin of Block
CHEND ¨C End of Block
CHFRAME
CHLINEFORMAT
CHSOURCELINK
CHSTRING
226
229
231
234
235
236
237
238
239
240
241
242
243
8 PivotTables ...................................................................................................... 244
9 Change Tracking ............................................................................................. 245
10 Workspace Documents .................................................................................... 246
10.1
10.2
10.3
10.4
10.5
Workspace Stream
Overview, Ordered by Record Identifier
INDEX
SHEETHDR
SHEETSOFFSET
246
248
249
250
250
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- file format example
- pdf file format basic structure
- all file format opener
- office file format converter
- best file format for documents
- pdf file format tutorial
- pdf file format explained
- sequence file format in hive
- microsoft file format crossword
- printable file format crossword
- microsoft file format converter download
- file format converter free download