United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Open Specifications

Data Portability

Microsoft Office File Formats

Microsoft Office File Format Documents

[MS-XLS]: Excel Binary File Format (.xls) Structure

2 Structures

2.4 Records

2.4.1 AlRuns

2.4.2 Area

2.4.3 AreaFormat

2.4.4 Array

2.4.5 AttachedLabel

2.4.6 AutoFilter

2.4.7 AutoFilter12

2.4.8 AutoFilterInfo

2.4.9 AxcExt

2.4.10 AxesUsed

2.4.11 Axis

2.4.12 AxisLine

2.4.13 AxisParent

2.4.14 Backup

2.4.15 Bar

2.4.16 BCUsrs

2.4.17 Begin

2.4.19 BkHim

2.4.20 Blank

2.4.21 BOF

2.4.22 BookBool

2.4.25 BopPop

2.4.26 BopPopCustom

2.4.27 BottomMargin

2.4.28 BoundSheet8

2.4.29 BRAI

2.4.30 BuiltInFnGroupCount

2.4.31 CalcCount

2.4.32 CalcDelta

2.4.33 CalcIter

2.4.34 CalcMode

2.4.35 CalcPrecision

2.4.36 CalcRefMode

2.4.37 CalcSaveRecalc

2.4.38 CatLab

2.4.39 CatSerRange

2.4.40 CbUsr

2.4.41 CellWatch

2.4.42 CF

2.4.43 CF12

2.4.44 CFEx

2.4.45 Chart

2.4.47 Chart3DBarShape

2.4.48 ChartFormat

2.4.49 ChartFrtInfo

2.4.50 ClrtClient

2.4.51 CodeName

2.4.52 CodePage

2.4.54 Compat12

2.4.55 CompressPictures

2.4.57 CondFmt12

2.4.58 Continue

2.4.59 ContinueBigName

2.4.60 ContinueFrt

2.4.61 ContinueFrt11

2.4.62 ContinueFrt12

2.4.64 CrErr

2.4.65 CRN

2.4.66 CrtLayout12

2.4.67 CrtLayout12A

2.4.70 CrtMlFrt

2.4.71 CrtMlFrtContinue

2.4.72 CUsr

2.4.73 Dat

2.4.74 DataFormat

2.4.75 DataLabExt

2.4.76 DataLabExtContents

2.4.77 Date1904

2.4.78 DBCell

2.4.79 DbOrParamQry

2.4.81 DBQueryExt

2.4.82 DCon

2.4.84 DConn

2.4.85 DConName

2.4.87 DefaultRowHeight

2.4.88 DefaultText

2.4.89 DefColWidth

2.4.90 Dimensions

2.4.91 DocRoute

2.4.93 DropDownObjIds

2.4.94 DSF

2.4.95 Dv

2.4.96 DVal

2.4.97 DXF

2.4.98 DxGCol

2.4.99 End

2.4.100 EndBlock

2.4.101 EndObject

2.4.102 EntExU2

2.4.103 EOF

2.4.104 Excel9File

2.4.105 ExternName

2.4.106 ExternSheet

2.4.108 ExtString

2.4.109 Fbi

2.4.110 Fbi2

2.4.111 Feat

2.4.112 FeatHdr

2.4.113 FeatHdr11

2.4.114 Feature11

2.4.115 Feature12

2.4.116 FileLock

2.4.117 FilePass

2.4.118 FileSharing

2.4.119 FilterMode

2.4.120 FnGroupName

2.4.121 FnGrp12

2.4.122 Font

2.4.123 FontX

2.4.125 ForceFullCalculation

2.4.127 Formula

2.4.128 Frame

2.4.129 FrtFontList

2.4.130 FrtWrapper

2.4.131 GelFrame

2.4.132 GridSet

2.4.133 GUIDTypeLib

2.4.134 Guts

2.4.135 HCenter

2.4.137 HeaderFooter

2.4.138 HFPicture

2.4.139 HideObj

2.4.140 HLink

2.4.141 HLinkTooltip

2.4.142 HorizontalPageBreaks

2.4.143 IFmtRecord

2.4.144 Index

2.4.145 InterfaceEnd

2.4.146 InterfaceHdr

2.4.147 Intl

2.4.148 Label

2.4.149 LabelSst

2.4.150 Lbl

2.4.151 LeftMargin

2.4.153 LegendException

2.4.154 Lel

2.4.155 Line

2.4.156 LineFormat

2.4.158 LPr

2.4.159 LRng

2.4.160 MarkerFormat

2.4.161 MDB

2.4.162 MDTInfo

2.4.164 MDXProp

2.4.167 MDXTuple

2.4.168 MergeCells

2.4.169 Mms

2.4.170 MsoDrawing

2.4.171 MsoDrawingGroup

2.4.172 MsoDrawingSelection

2.4.173 MTRSettings

2.4.174 MulBlank

2.4.175 MulRk

2.4.176 NameCmt

2.4.177 NameFnGrp12

2.4.178 NamePublish

2.4.179 Note

2.4.181 Obj

2.4.182 ObjectLink

2.4.183 ObjProtect

2.4.184 ObNoMacros

2.4.186 OleDbConn

2.4.187 OleObjectSize

2.4.188 Palette

2.4.189 Pane

2.4.190 ParamQry

2.4.191 Password

2.4.192 PhoneticInfo

2.4.193 PicF

2.4.194 Pie

2.4.195 PieFormat

2.4.196 PivotChartBits

2.4.197 PlotArea

2.4.198 PlotGrowth

2.4.199 Pls

2.4.200 PLV

2.4.201 Pos

2.4.202 PrintGrid

2.4.203 PrintRowCol

2.4.204 PrintSize

2.4.205 Prot4Rev

2.4.206 Prot4RevPass

2.4.207 Protect

2.4.208 Qsi

2.4.209 Qsif

2.4.210 Qsir

2.4.211 QsiSXTag

2.4.212 Radar

2.4.213 RadarArea

2.4.214 RealTimeData

2.4.215 RecalcId

2.4.216 RecipName

2.4.217 RefreshAll

2.4.218 RichTextStream

2.4.219 RightMargin

2.4.220 RK

2.4.221 Row

2.4.222 RRAutoFmt

2.4.223 RRDChgCell

2.4.224 RRDConflict

2.4.225 RRDDefName

2.4.226 RRDHead

2.4.227 RRDInfo

2.4.228 RRDInsDel

2.4.229 RRDInsDelBegin

2.4.230 RRDInsDelEnd

2.4.231 RRDMove

2.4.232 RRDMoveBegin

2.4.233 RRDMoveEnd

2.4.234 RRDRenSheet

2.4.235 RRDRstEtxp

2.4.236 RRDTQSIF

2.4.237 RRDUserView

2.4.238 RRFormat

2.4.239 RRInsertSh

2.4.241 RRTabId

2.4.242 SBaseRef

2.4.243 Scatter

2.4.244 SCENARIO

2.4.245 ScenarioProtect

2.4.246 ScenMan

2.4.247 Scl

2.4.248 Selection

2.4.249 SerAuxErrBar

2.4.250 SerAuxTrend

2.4.253 SeriesList

2.4.254 SeriesText

2.4.255 SerParent

2.4.256 SerToCrt

2.4.257 Setup

2.4.258 ShapePropsStream

2.4.259 SheetExt

2.4.260 ShrFmla

2.4.261 ShtProps

2.4.262 SIIndex

2.4.263 Sort

2.4.264 SortData

2.4.265 SST

2.4.266 StartBlock

2.4.267 StartObject

2.4.269 Style

2.4.270 StyleExt

2.4.271 SupBook

2.4.272 Surf

2.4.273 SXAddl Records

2.4.275 SXDB

2.4.276 SXDBB

2.4.278 SXDI

2.4.279 SXDtr

2.4.280 SxDXF

2.4.281 SxErr

2.4.282 SXEx

2.4.283 SXFDB

2.4.284 SXFDBType

2.4.287 SxFormat

2.4.288 SXFormula

2.4.289 SXInt

2.4.290 SxIsxoper

2.4.291 SxItm

2.4.292 SxIvd

2.4.293 SXLI

2.4.295 SxNil

2.4.296 SXNum

2.4.298 SXPI

2.4.300 SXRng

2.4.302 SxSelect

2.4.303 SXStreamID

2.4.304 SXString

2.4.305 SXTbl

2.4.307 SXTBRGIITM

2.4.308 SXTH

2.4.309 Sxvd

2.4.311 SXVDTEx

2.4.312 SXVI

2.4.314 SXViewEx

2.4.315 SXViewEx9

2.4.316 SXViewLink

2.4.317 SXVS

2.4.318 Sync

2.4.319 Table

2.4.320 TableStyle

2.4.321 TableStyleElement

2.4.322 TableStyles

2.4.323 Template

2.4.324 Text

2.4.325 TextPropsStream

2.4.326 Theme

2.4.327 Tick

2.4.328 TopMargin

2.4.329 TxO

2.4.331 Uncalced

2.4.332 Units

2.4.333 UserBView

2.4.334 UserSViewBegin

2.4.335 UserSViewBegin_Chart

2.4.336 UserSViewEnd

2.4.337 UsesELFs

2.4.339 UsrExcl

2.4.340 UsrInfo

2.4.341 ValueRange

2.4.342 VCenter

2.4.343 VerticalPageBreaks

2.4.345 Window1

2.4.346 Window2

2.4.347 WinProtect

2.4.348 WOpt

2.4.349 WriteAccess

2.4.350 WriteProtect

2.4.352 XCT

2.4.353 XF

2.4.354 XFCRC

2.4.355 XFExt

2.4.356 YMult

Minimize

This topic has not yet been rated - Rate this topic

2.4.38 CatLab

Office

The CatLab record specifies the attributes of the axis label.

0	1	2	3	4	5	6	7	8	9	1 0	1	2	3	4	5	6	7	8	9	2 0	1	2	3	4	5	6	7	8	9	3 0	1
frtHeaderOld
wOffset																at
A	unused															reserved (optional)

frtHeaderOld (4 bytes): An FrtHeaderOld structure. The frtHeaderOld.rt field MUST be 0x0856.

wOffset (2 bytes): An unsigned integer that specifies the distance between the axis and axis label. It contains the offset as a percentage of the default distance. The default distance is equal to 1/3 the height of the font calculated in pixels. MUST be a value greater than or equal to 0 (0%) and less than or equal to 1000 (1000%).

at (2 bytes): An unsigned integer that specifies the alignment of the axis label. MUST be a value from the following table:

Value	Alignment
0x0001	Top-aligned if the trot field of the Text record of the axis is not equal to 0. Left-aligned if the iReadingOrder field of the Text record of the axis specifies left-to-right reading order; otherwise, right-aligned.
0x0002	Center-alignment
0x0003	Bottom-aligned if the trot field of the Text record of the axis is not equal to 0. Right-aligned if the iReadingOrder field of the Text record of the axis specifies left-to-right reading order; otherwise, left-aligned.

A - cAutoCatLabelReal (1 bit): A bit that specifies whether the number of categories (3) between axis labels is set to the default value. MUST be a value from the following table:

Value	Description
0	The value is set to catLabel field as specified by CatSerRange record.
1	The value is set to the default value. The number of category (3) labels is automatically calculated by the application based on the data in the chart.

unused (15 bits): Undefined, and MUST be ignored.

reserved (2 bytes): MUST be zero, and MUST be ignored.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.