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.5.2 AF12CellIcon

2.5.3 AF12Criteria

2.5.4 AF12DateInfo

2.5.5 AFDOper

2.5.6 AFDOperBoolErr

2.5.7 AFDOperRk

2.5.8 AFDOperStr

2.5.10 Bes

2.5.11 Bold

2.5.12 BookExt_Conditional11

2.5.13 BookExt_Conditional12

2.5.15 BorderStyle

2.5.16 BuiltInStyle

2.5.17 CachedDiskHeader

2.5.18 Cch255

2.5.19 Cell

2.5.20 CellXF

2.5.22 CFDatabar

2.5.23 CFExAveragesTemplateParams

2.5.24 CFExDateTemplateParams

2.5.25 CFExDefaultTemplateParams

2.5.26 CFExFilterParams

2.5.27 CFExNonCF12

2.5.28 CFExTemplateParams

2.5.29 CFExTextTemplateParams

2.5.30 CFFilter

2.5.31 CFFlag

2.5.32 CFGradient

2.5.33 CFGradientInterpItem

2.5.34 CFGradientItem

2.5.35 CFMStateItem

2.5.36 CFMultistate

2.5.37 CFrtId

2.5.38 CFT

2.5.39 CFVO

2.5.40 ChartNumNillable

2.5.41 Col

2.5.42 Col_NegativeOne

2.5.43 Col12

2.5.46 ColByteU

2.5.48 ColorICV

2.5.49 ColorTheme

2.5.50 ColRelNegU

2.5.52 ColSlco8U

2.5.53 ColU

2.5.54 Colx

2.5.55 CondDataValue

2.5.56 CondFmtStructure

2.5.57 ConnGrbitDbt

2.5.58 ConnGrbitDbtAdo

2.5.59 ConnGrbitDbtOledb

2.5.60 ConnGrbitDbtWeb

2.5.61 ControlInfo

2.5.62 CrtLayout12Mode

2.5.63 DataFunctionalityLevel

2.5.64 DataSourceType

2.5.65 DateAsNum

2.5.66 DateUnit

2.5.67 DCol

2.5.68 DColByteU

2.5.69 DConFile

2.5.70 DConnConnectionOleDb

2.5.71 DConnConnectionWeb

2.5.73 DConnParamBinding

2.5.74 DConnParamBindingValByte

2.5.75 DConnParamBindingValInt

2.5.76 DConnParamBindingValString

2.5.77 DConnParamBindingValType

2.5.78 DConnParameter

2.5.79 DConnStringSequence

2.5.80 DConnUnicodeStringSegmented

2.5.81 DJoin

2.5.82 DRw

2.5.83 DRwByteU

2.5.84 Duce

2.5.85 DuceRadical

2.5.86 DuceStacked

2.5.87 Ducr

2.5.88 DucrConditionalLbl

2.5.89 DucrConditionalNoLbl

2.5.90 DwQsiFuture

2.5.91 DXFALC

2.5.92 DXFBdr

2.5.94 DXFId

2.5.95 DXFN

2.5.96 DXFN12

2.5.97 DXFN12List

2.5.98 DXFN12NoCB

2.5.99 DXFNum

2.5.100 DXFNumIFmt

2.5.101 DXFNumUsr

2.5.103 DXFProt

2.5.104 EnhancedProtection

2.5.105 ExternDdeLinkNoOper

2.5.106 ExternDocName

2.5.107 ExternOleDdeLink

2.5.108 ExtProp

2.5.110 FactoidData

2.5.111 Feat11CellStruct

2.5.112 Feat11FdaAutoFilter

2.5.113 Feat11FieldDataItem

2.5.114 Feat11Fmla

2.5.115 Feat11RgInvalidCells

2.5.116 Feat11RgSharepointIdChange

2.5.117 Feat11RgSharepointIdDel

2.5.118 Feat11TotalFmla

2.5.119 Feat11WSSListInfo

2.5.120 Feat11XMap

2.5.121 Feat11XMapEntry

2.5.122 Feat11XMapEntry2

2.5.123 FeatFormulaErr2

2.5.124 FeatProtection

2.5.125 FeatSmartTag

2.5.126 FFErrorCheck

2.5.127 FillPattern

2.5.128 FillStylePropertiesForShapePropsStreamChecksum

2.5.129 FontIndex

2.5.130 FontInfo

2.5.131 FontScheme

2.5.132 FormatRun

2.5.133 FormulaValue

2.5.134 FrtFlags

2.5.135 FrtHeader

2.5.136 FrtHeaderOld

2.5.137 FrtRefHeader

2.5.138 FrtRefHeaderNoGrbit

2.5.139 FrtRefHeaderU

2.5.141 FtCblsData

2.5.142 FtCf

2.5.143 FtCmo

2.5.144 FtEdoData

2.5.145 FtGboData

2.5.146 FtGmo

2.5.147 FtLbsData

2.5.148 FtMacro

2.5.149 FtNts

2.5.150 FtPictFmla

2.5.151 FtPioGrbit

2.5.152 FtRbo

2.5.153 FtRboData

2.5.154 FtSbs

2.5.155 FullColorExt

2.5.156 GradStop

2.5.157 HiddenMemberSet

2.5.158 HideObjEnum

2.5.159 HorizAlign

2.5.160 HorzBrk

2.5.161 Icv

2.5.162 IcvChart

2.5.163 IcvFont

2.5.164 IcvXF

2.5.165 IFmt

2.5.166 InteriorColorPropertiesForShapePropsStreamChecksum

2.5.167 ISSTInf

2.5.168 IXFCell

2.5.169 KPIProp

2.5.170 KPISets

2.5.171 LbsDropData

2.5.172 LEMMode

2.5.173 LinePropertiesForShapePropsStreamChecksum

2.5.174 List12BlockLevel

2.5.175 List12DisplayName

2.5.176 List12TableStyleClientInfo

2.5.177 LongRGB

2.5.178 LongRGBA

2.5.179 LPWideString

2.5.180 MDir

2.5.181 MDTInfoIndex

2.5.182 MDXStrIndex

2.5.183 MOper

2.5.184 NilChartNum

2.5.187 ObjFmla

2.5.188 ObjId

2.5.189 ObjLinkFmla

2.5.190 ODBCType

2.5.191 OfficeArtClientAnchorChart

2.5.192 OfficeArtClientAnchorHF

2.5.193 OfficeArtClientAnchorSheet

2.5.194 OfficeArtClientData

2.5.195 OfficeArtClientTextbox

2.5.196 PaneType

2.5.197 PARAMQRY_Fixed

2.5.198 Parsed Expressions

2.5.199 PBT

2.5.201 Phs

2.5.202 PictFmlaEmbedInfo

2.5.203 PictFmlaKey

2.5.204 PivotCompProp

2.5.205 PositionMode

2.5.206 ReadingOrder

2.5.207 Ref

2.5.208 Ref8

2.5.209 Ref8U

2.5.210 Ref8U2007

2.5.211 RefU

2.5.212 RevisionType

2.5.213 RFX

2.5.214 RichTextStreamChecksumData

2.5.215 RichTextStreamChecksumFontInformation

2.5.216 RichTextStreamChecksumFontInformationArrayItem

2.5.217 RkNumber

2.5.218 RkRec

2.5.219 RPHSSub

2.5.220 RRD

2.5.221 RRDDefNameFlags

2.5.222 RRLoc

2.5.223 RTDEItem

2.5.224 RTDOper

2.5.225 RTDOperStr

2.5.226 Run

2.5.227 Rw

2.5.228 Rw12

2.5.229 RwLongU

2.5.230 RwU

2.5.231 Rwx

2.5.233 SD_SetSortOrder

2.5.234 SDContainer

2.5.235 SecurityDescriptor

2.5.236 ShapePropsStreamChecksumData

2.5.237 SharedFeatureType

2.5.238 SheetExtOptional

2.5.239 ShortDTR

2.5.240 ShortXLUnicodeString

2.5.241 SLCO8

2.5.242 SortCond12

2.5.243 SortItem

2.5.244 SourceType

2.5.245 SQElfFlags

2.5.246 SqRef

2.5.248 Stxp

2.5.249 StyleXF

2.5.250 SXAddl_SXDEnd

2.5.251 SXAddl_SXDVerUpdInv

2.5.252 SXAddl_SXString

2.5.253 SXAddlHdr

2.5.255 SXEZDoper

2.5.256 SxFT

2.5.257 SxIvdCol

2.5.258 SxIvdRw

2.5.259 SXLIItem

2.5.260 SXPI_Item

2.5.261 SXVDEx_Opt

2.5.262 SXView9Save

2.5.263 SXVIFlags

2.5.264 TabId

2.5.265 TabIndex

2.5.266 TableFeatureType

2.5.267 Tag_Fn_MDX

2.5.268 TextPropsStreamChecksumData

2.5.269 Top10FT

2.5.270 Ts

2.5.271 TxOLastRun

2.5.272 TxORuns

2.5.273 TxtWf

2.5.274 Underline

2.5.275 VertAlign

2.5.276 VertBrk

2.5.277 VirtualPath

2.5.278 WebPubString

2.5.279 XColorType

2.5.280 XFExtGradient

2.5.281 XFExtNoFRT

2.5.282 XFIndex

2.5.284 XFPropBorder

2.5.285 XFPropColor

2.5.286 XFPropGradient

2.5.287 XFPropGradientStop

2.5.288 XFProps

2.5.289 XFPropTextRotation

2.5.290 XLNameUnicodeString

2.5.291 XlsFilter_Criteria

2.5.292 XlsFilter_Top10

2.5.293 XLUnicodeRichExtendedString

2.5.294 XLUnicodeString

2.5.295 XLUnicodeStringMin2

2.5.296 XLUnicodeStringNoCch

2.5.297 XLUnicodeStringSegmented

2.5.298 XLUnicodeStringSegmentedRTD

2.5.299 XLUnicodeStringSegmentedSXAddl

2.5.300 XmlTkBackWallThicknessFrt

2.5.301 XmlTkBaseTimeUnitFrt

2.5.302 XmlTkBlob

2.5.303 XmlTkBool

2.5.304 XmlTkChain

2.5.305 XmlTkColorMappingOverride

2.5.306 XmlTkDispBlanksAsFrt

2.5.307 XmlTkDouble

2.5.308 XmlTkDWord

2.5.309 XmlTkEnd

2.5.310 XmlTkEndSurface

2.5.311 XmlTkFloorThicknessFrt

2.5.312 XmlTkFormatCodeFrt

2.5.313 XmlTkHeader

2.5.314 XmlTkHeightPercent

2.5.315 XmlTkLogBaseFrt

2.5.316 XmlTkMajorUnitFrt

2.5.317 XmlTkMajorUnitTypeFrt

2.5.318 XmlTkMaxFrt

2.5.319 XmlTkMinFrt

2.5.320 XmlTkMinorUnitFrt

2.5.321 XmlTkMinorUnitTypeFrt

2.5.322 XmlTkNoMultiLvlLbl

2.5.323 XmlTkOverlay

2.5.324 XmlTkPerspectiveFrt

2.5.325 XmlTkPieComboFrom12Frt

2.5.326 XmlTkRAngAxOffFrt

2.5.327 XmlTkRotXFrt

2.5.328 XmlTkRotYFrt

2.5.329 XmlTkShowDLblsOverMax

2.5.330 XmlTkSpb

2.5.331 XmlTkStart

2.5.332 XmlTkStartSurface

2.5.333 XmlTkString

2.5.334 XmlTkStyle

2.5.335 XmlTkSymbolFrt

2.5.336 XmlTkThemeOverride

2.5.337 XmlTkTickLabelPositionFrt

2.5.338 XmlTkTickLabelSkipFrt

2.5.339 XmlTkTickMarkSkipFrt

2.5.340 XmlTkToken

2.5.341 XmlTkTpb

2.5.342 Xnum

2.5.343 XORObfuscation

2.5.344 XTI

Minimize

This topic has not yet been rated - Rate this topic

2.5.69 DConFile

Office

The DConFile structure specifies the workbook file or workbook file and sheet that contain a data source (1)range. This structure is used by the DConBin, DConRef and DConName records.

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
stFile (variable)
...

stFile (variable): An XLUnicodeStringNoCch that specifies the workbook file or workbook file and sheet that contain the range specified in the DConBin, DConRef or DConName record.

MUST be a string that conforms to the following ABNF grammar:

dcon-file = external-virt-path / self-reference

external-virt-path = volume / unc-volume / rel-volume / transfer-protocol / startup / alt-startup / library / simple-file-path-dcon

simple-file-path-dcon = %x0001 file-path

self-reference = %x0002 sheet-name

See VirtualPath for the definition of the volume, unc-volume, rel-volume, transfer-protocol, startup, alt-startup, library, file-path and sheet-name rules used in the ABNF grammar. Note that the volume, unc-volume, rel-volume, transfer-protocol, startup, alt-startup, library, and file-path rules specify that an optional sheet name can be included.

If this structure is contained in a DConName or DConBin record and the defined name has a workbook scope, then this string MUST satisfy the external-virt-path rule and MUST NOT specify a sheet name. Otherwise a sheet name MUST be specified.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.