The Microsoft Excel File Format - Apache OpenOffice

'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.

Google Online Preview   Download