The Microsoft Excel File Format - Apache OpenOffice

  • Pdf File 1,168.58KByte

's Documentation of the

Microsoft Excel File Format

Excel Versions 2, 3, 4, 5, 95, 97, 2000, XP, 2003

Author License Contributors

Other sources Mailing list

Download

Project started Last change Revision

Daniel Rentz mailto:dr@

Public Documentation License

Yves Hiltpold, James J. Keene, Sami Kuhmonen, John Marmion, Alexander Mavrin, Josh Micich, Andrew C. Oliver, Mike Salter, Stefan Schm?cker, Charles Wyble

Hyperlinks to Wikipedia ( ) for various extended information

mailto:dev@sc. Subscription mailto:dev-subscribe@sc.

PDF 1.x XML 2.x XML

2001-Jun-29

2008-Apr-02

1.42

Contents

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

4.1 Worksheet/Workbook Stream

80

4.2 Record Order in Streams and Substreams

81

4.3 Calculation Settings Block

87

4.4 Page Settings Block

87

4.5 Sheet View Settings Block

88

4.6 Cell Formatting

89

4.7 Cell Table and Row Blocks

90

4.8 Array Formulas and Shared Formulas

96

4.9 Multiple Operation Tables

97

4.10 Internal and External References

98

4.11 Shared String Table (BIFF8)

110

2

4.12 Conditional Formatting Table (BIFF8)

112

4.13 Hyperlink Table (BIFF8)

112

4.14 Data Validity Table (BIFF8)

112

4.15 AutoFilter, Advanced Filter

113

4.16 Scenarios

113

4.17 Web Queries (BIFF8)

113

4.18 Worksheet/Workbook Protection

114

4.19 File Protection

117

5 Worksheet/Workbook Records ........................................................................ 120

5.1 Overview, Ordered by Record Identifier

120

5.2 Overview, Ordered by Record Names

124

5.3 Overview, Ordered by BIFF Versions

127

5.4 ARRAY

132

5.5 BACKUP

133

5.6 BITMAP

133

5.7 BLANK

134

5.8 BOF ? Beginning of File

135

5.9 BOOKBOOL

137

5.10 BOOLERR

137

5.11 BOTTOMMARGIN

138

5.12 BUILTINFMTCOUNT

138

5.13 CALCCOUNT

139

5.14 CALCMODE

139

5.15 CFHEADER

139

5.16 CFRULE ? Conditional Formatting Rule

140

5.17 CODEPAGE

145

5.18 COLINFO

146

5.19 COLUMNDEFAULT

147

5.20 COLWIDTH

147

5.21 CONTINUE

148

5.22 COUNTRY

149

5.23 CRN

150

5.24 DATATABLE ? Multiple Operation Table

151

5.25 DATATABLE2 ? Multiple Operation Table

152

5.26 DATAVALIDATION

153

5.27 DATAVALIDATIONS

154

5.28 DATEMODE

154

5.29 DBCELL

155

5.30 DCONREF ? Data Consolidation Reference

155

5.31 DEFAULTROWHEIGHT

156

5.32 DEFCOLWIDTH

156

5.33 DEFINEDNAME

157

5.34 DELTA

160

5.35 DIMENSION

160

5.36 DSF ? Double Stream File

161

5.37 EOF ? End of File

161

5.38 EXTERNALBOOK ? External Workbook

162

5.39 EXTERNALNAME

164

5.40 EXTERNCOUNT

166

5.41 EXTERNSHEET

166

5.42 EXTSST ? Extended SST

167

5.43 FILEPASS

168

5.44 FILESHARING

170

5.45 FONT

171

5.46 FONT2

173

3

5.47 FONTCOLOR

173

5.48 FOOTER

173

5.49 FORMAT

174

5.50 FORMULA

176

5.51 GCW ? Global Column Width

178

5.52 GRIDSET

179

5.53 GUTS

179

5.54 HCENTER

179

5.55 HEADER

180

5.56 HIDEOBJ

181

5.57 HORIZONTALPAGEBREAKS

181

5.58 HYPERLINK

182

5.59 INDEX

185

5.60 INTEGER

186

5.61 ITERATION

186

5.62 IXFE ? Index to XF

186

5.63 LABEL

187

5.64 LABELRANGES

187

5.65 LABELSST

188

5.66 LEFTMARGIN

188

5.67 MERGEDCELLS

188

5.68 MULBLANK ? Multiple BLANK

189

5.69 MULRK ? Multiple RK

189

5.70 NOTE

190

5.71 NUMBER

191

5.72 OBJECTPROTECT

191

5.73 PAGESETUP

192

5.74 PALETTE

195

5.75 PANE

197

5.76 PASSWORD

197

5.77 PHONETICPR

198

5.78 PLS

198

5.79 PRECISION

198

5.80 PRINTGRIDLINES

199

5.81 PRINTHEADERS

199

5.82 PROTECT

200

5.83 QUICKTIP

200

5.84 RANGEPROTECTION

200

5.85 REFMODE

201

5.86 RIGHTMARGIN

201

5.87 RK

201

5.88 ROW

202

5.89 RSTRING

204

5.90 SAVERECALC

204

5.91 SCENPROTECT

205

5.92 SCL

205

5.93 SELECTION

205

5.94 SHAREDFMLA ? Shared Formula

206

5.95 SHEET

206

5.96 SHEETLAYOUT

207

5.97 SHEETPR

207

5.98 SHEETPROTECTION

208

5.99 SORT

209

5.100 SST ? Shared String Table

210

5.101 STANDARDWIDTH

210

5.102 STRING

211

5.103 STYLE

212

4

5.104 TOPMARGIN

213

5.105 UNCALCED

213

5.106 USESELFS

213

5.107 VCENTER

214

5.108 VERTICALPAGEBREAKS

214

5.109 WINDOW1

215

5.110 WINDOW2

216

5.111 WINDOWPROTECT

217

5.112 WRITEACCESS

218

5.113 WRITEPROT

218

5.114 XCT ? CRN Count

218

5.115 XF ? Extended Format

219

6 Drawing Objects .............................................................................................. 225

7 Charts ............................................................................................................... 226

7.1 Document Integration

226

7.2 General Chart Structure

229

7.3 Common Record Blocks

231

7.4 Record Overview, Ordered by Identifier

234

7.5 Record Overview, Ordered by Name

235

7.6 CHAREAFORMAT

236

7.7 CHAXISLINE

237

7.8 CHBEGIN ? Begin of Block

238

7.9 CHEND ? End of Block

239

7.10 CHFRAME

240

7.11 CHLINEFORMAT

241

7.12 CHSOURCELINK

242

7.13 CHSTRING

243

8 PivotTables ...................................................................................................... 244

9 Change Tracking ............................................................................................. 245

10 Workspace Documents .................................................................................... 246

10.1 Workspace Stream

246

10.2 Overview, Ordered by Record Identifier

248

10.3 INDEX

249

10.4 SHEETHDR

250

10.5 SHEETSOFFSET

250

5

................
................

Online Preview   Download