Excel 2003二进制文件格式详解

2003

需积分: 9 77 浏览量更新于2024-07-16 收藏 43.94MB PDF 举报

"此文档详细介绍了Excel二进制文件格式（.xls）的结构，是Microsoft Excel 2003的标准，旨在解析Excel字节文档的数据组成。内容涵盖知识产权声明、技术文档的使用权限以及文件的具体格式细节。" Excel二进制文件格式（.xls）是Microsoft Excel 2003及以前版本用于存储电子表格数据的主要格式。这种格式是非文本的，以二进制数据存储，从而能更高效地处理大量数据和计算，同时提供更快的文件打开和关闭速度。文档[MS-XLS]详细阐述了.xls文件的结构，包括以下几个关键方面： 1. 文件头：每个.xls文件都以一个文件头开始，包含有关文件版本、校验和信息和其他元数据的记录。这些信息用于确保文件的完整性和正确读取。 2. 工作簿结构：工作簿由一系列的工作表构成，每个工作表包含单元格数据、公式、样式和其他属性。工作表数据以连续的字节数组存储，每个工作表都有自己的索引和标识符。 3. 单元格数据：单元格数据可以是数值、字符串、日期、时间或公式。它们在文件中以压缩或未压缩的形式存储，并且可能带有格式信息，如字体、颜色和对齐方式。 4. 公式和引用：Excel中的公式和引用是二进制文件结构的重要组成部分。它们通常以R1C1格式编码，其中R表示行，C表示列。公式解析和计算依赖于这些编码。 5. 表达式树：公式和函数的计算逻辑以表达式树的形式存在，这有助于优化计算效率。 6. 图表和图形：.xls文件支持内嵌图表和图形，它们的结构也包含在二进制文件中，包括数据源、类型、样式等信息。 7. 页眉和页脚：页眉和页脚的信息存储在特定的位置，包含了用户设置的页码、日期等打印元素。 8. 自定义视图和工作表选项：文件还保存了用户的视图设置，如冻结窗格、隐藏行和列等。 9. 保护和安全性：Excel提供了文件和工作表的密码保护功能，这些安全设置也在二进制文件中编码。 10. OLE对象：.xls文件可以嵌入其他Office应用程序创建的对象，如Word文档、图片或图表。OLE（Object Linking and Embedding）数据存储在特定的结构中，允许对象与其他应用程序的交互。知识产权方面，微软明确指出，尽管文档受版权保护，但开发者有权使用文档开发实现相关技术的软件，并可以在实现中分发文档的片段，以便正确地记录实现。 .xls文件格式是一个复杂的数据结构，包含了大量的元数据和格式信息，为Excel的高效运行和数据存储提供了基础。通过深入理解这个结构，开发者可以更好地进行数据解析、文件转换或者创建与Excel兼容的应用程序。

16 / 1124

[MS-XLS] - v20171212

Excel Binary File Format (.xls) Structure

Release: December 12, 2017

2.4.336 UserSViewEnd ........................................................................................... 569

2.4.337 UsesELFs .................................................................................................. 569

2.4.338 UsrChk ..................................................................................................... 569

2.4.339 UsrExcl ..................................................................................................... 570

2.4.340 UsrInfo ..................................................................................................... 571

2.4.341 ValueRange .............................................................................................. 571

2.4.342 VCenter .................................................................................................... 574

2.4.343 VerticalPageBreaks .................................................................................... 574

2.4.344 WebPub .................................................................................................... 574

2.4.345 Window1 .................................................................................................. 577

2.4.346 Window2 .................................................................................................. 578

2.4.347 WinProtect ................................................................................................ 580

2.4.348 WOpt ....................................................................................................... 581

2.4.349 WriteAccess .............................................................................................. 582

2.4.350 WriteProtect .............................................................................................. 583

2.4.351 WsBool ..................................................................................................... 583

2.4.352 XCT ......................................................................................................... 584

2.4.353 XF ........................................................................................................... 584

2.4.354 XFCRC ...................................................................................................... 585

2.4.355 XFExt ....................................................................................................... 585

2.4.356 YMult ....................................................................................................... 586

2.5 Structures ...................................................................................................... 587

2.5.1 AddinUdf .................................................................................................. 587

2.5.2 AF12CellIcon ............................................................................................. 587

2.5.3 AF12Criteria .............................................................................................. 588

2.5.4 AF12DateInfo ............................................................................................ 588

2.5.5 AFDOper ................................................................................................... 589

2.5.6 AFDOperBoolErr ........................................................................................ 590

2.5.7 AFDOperRk ............................................................................................... 591

2.5.8 AFDOperStr .............................................................................................. 591

2.5.9 AutoFmt8 ................................................................................................. 592

2.5.10 Bes .......................................................................................................... 593

2.5.11 Bold ......................................................................................................... 594

2.5.12 BookExt_Conditional11 ............................................................................... 594

2.5.13 BookExt_Conditional12 ............................................................................... 594

2.5.14 Boolean .................................................................................................... 595

2.5.15 BorderStyle ............................................................................................... 595

2.5.16 BuiltInStyle ............................................................................................... 596

2.5.17 CachedDiskHeader ..................................................................................... 596

2.5.18 Cch255..................................................................................................... 597

2.5.19 Cell .......................................................................................................... 597

2.5.20 CellXF ...................................................................................................... 597

2.5.21 CFColor .................................................................................................... 601

2.5.22 CFDatabar ................................................................................................ 601

2.5.23 CFExAveragesTemplateParams .................................................................... 603

2.5.24 CFExDateTemplateParams .......................................................................... 603

2.5.25 CFExDefaultTemplateParams ....................................................................... 604

2.5.26 CFExFilterParams ....................................................................................... 604

2.5.27 CFExNonCF12 ........................................................................................... 605

2.5.28 CFExTemplateParams ................................................................................. 607

2.5.29 CFExTextTemplateParams ........................................................................... 608

2.5.30 CFFilter .................................................................................................... 608

2.5.31 CFFlag ...................................................................................................... 609

2.5.32 CFGradient ............................................................................................... 610

2.5.33 CFGradientInterpItem ................................................................................ 610

2.5.34 CFGradientItem ......................................................................................... 611

2.5.35 CFMStateItem ........................................................................................... 612

2.5.36 CFMultistate .............................................................................................. 612

17 / 1124

[MS-XLS] - v20171212

Excel Binary File Format (.xls) Structure

Release: December 12, 2017

2.5.37 CFrtId ...................................................................................................... 613

2.5.38 CFT .......................................................................................................... 614

2.5.39 CFVO ....................................................................................................... 615

2.5.40 ChartNumNillable ....................................................................................... 616

2.5.41 Col ........................................................................................................... 616

2.5.42 Col_NegativeOne ....................................................................................... 616

2.5.43 Col12 ....................................................................................................... 617

2.5.44 Col256U ................................................................................................... 617

2.5.45 ColByte .................................................................................................... 617

2.5.46 ColByteU .................................................................................................. 618

2.5.47 ColElfU ..................................................................................................... 618

2.5.48 ColorICV ................................................................................................... 618

2.5.49 ColorTheme .............................................................................................. 619

2.5.50 ColRelNegU ............................................................................................... 619

2.5.51 ColRelU .................................................................................................... 620

2.5.52 ColSlco8U ................................................................................................. 620

2.5.53 ColU ......................................................................................................... 620

2.5.54 Colx ......................................................................................................... 621

2.5.55 CondDataValue.......................................................................................... 621

2.5.56 CondFmtStructure ..................................................................................... 621

2.5.57 ConnGrbitDbt ............................................................................................ 622

2.5.58 ConnGrbitDbtAdo ....................................................................................... 622

2.5.59 ConnGrbitDbtOledb .................................................................................... 623

2.5.60 ConnGrbitDbtWeb ...................................................................................... 624

2.5.61 ControlInfo ............................................................................................... 625

2.5.62 CrtLayout12Mode ...................................................................................... 625

2.5.63 DataFunctionalityLevel ............................................................................... 626

2.5.64 DataSourceType ........................................................................................ 626

2.5.65 DateAsNum............................................................................................... 626

2.5.66 DateUnit ................................................................................................... 626

2.5.67 DCol ........................................................................................................ 627

2.5.68 DColByteU ................................................................................................ 627

2.5.69 DConFile ................................................................................................... 627

2.5.70 DConnConnectionOleDb .............................................................................. 628

2.5.71 DConnConnectionWeb ................................................................................ 629

2.5.72 DConnId ................................................................................................... 629

2.5.73 DConnParamBinding .................................................................................. 630

2.5.74 DConnParamBindingValByte ........................................................................ 630

2.5.75 DConnParamBindingValInt .......................................................................... 630

2.5.76 DConnParamBindingValString ...................................................................... 630

2.5.77 DConnParamBindingValType ....................................................................... 631

2.5.78 DConnParameter ....................................................................................... 631

2.5.79 DConnStringSequence ................................................................................ 632

2.5.80 DConnUnicodeStringSegmented .................................................................. 632

2.5.81 DJoin ....................................................................................................... 633

2.5.82 DRw ......................................................................................................... 633

2.5.83 DRwByteU ................................................................................................ 633

2.5.84 Duce ........................................................................................................ 633

2.5.85 DuceRadical .............................................................................................. 634

2.5.86 DuceStacked ............................................................................................. 635

2.5.87 Ducr ........................................................................................................ 635

2.5.88 DucrConditionalLbl ..................................................................................... 636

2.5.89 DucrConditionalNoLbl ................................................................................. 637

2.5.90 DwQsiFuture ............................................................................................. 637

2.5.91 DXFALC .................................................................................................... 638

2.5.92 DXFBdr..................................................................................................... 639

2.5.93 DXFFntD ................................................................................................... 640

2.5.94 DXFId ...................................................................................................... 641

18 / 1124

[MS-XLS] - v20171212

Excel Binary File Format (.xls) Structure

Release: December 12, 2017

2.5.95 DXFN ....................................................................................................... 641

2.5.96 DXFN12 .................................................................................................... 644

2.5.97 DXFN12List ............................................................................................... 645

2.5.98 DXFN12NoCB ............................................................................................ 645

2.5.99 DXFNum ................................................................................................... 645

2.5.100 DXFNumIFmt ............................................................................................ 646

2.5.101 DXFNumUsr .............................................................................................. 646

2.5.102 DXFPat ..................................................................................................... 646

2.5.103 DXFProt .................................................................................................... 647

2.5.104 EnhancedProtection ................................................................................... 647

2.5.105 ExternDdeLinkNoOper ................................................................................ 648

2.5.106 ExternDocName ........................................................................................ 648

2.5.107 ExternOleDdeLink ...................................................................................... 649

2.5.108 ExtProp .................................................................................................... 649

2.5.109 ExtRst ...................................................................................................... 650

2.5.110 FactoidData .............................................................................................. 651

2.5.111 Feat11CellStruct ........................................................................................ 651

2.5.112 Feat11FdaAutoFilter ................................................................................... 651

2.5.113 Feat11FieldDataItem .................................................................................. 652

2.5.114 Feat11Fmla ............................................................................................... 659

2.5.115 Feat11RgInvalidCells .................................................................................. 659

2.5.116 Feat11RgSharepointIdChange ..................................................................... 659

2.5.117 Feat11RgSharepointIdDel ........................................................................... 660

2.5.118 Feat11TotalFmla ........................................................................................ 660

2.5.119 Feat11WSSListInfo .................................................................................... 660

2.5.120 Feat11XMap .............................................................................................. 663

2.5.121 Feat11XMapEntry ...................................................................................... 663

2.5.122 Feat11XMapEntry2 ..................................................................................... 664

2.5.123 FeatFormulaErr2 ........................................................................................ 664

2.5.124 FeatProtection ........................................................................................... 664

2.5.125 FeatSmartTag ........................................................................................... 665

2.5.126 FFErrorCheck ............................................................................................ 666

2.5.127 FillPattern ................................................................................................. 666

2.5.128 FillStylePropertiesForShapePropsStreamChecksum ........................................ 667

2.5.129 FontIndex ................................................................................................. 677

2.5.130 FontInfo ................................................................................................... 677

2.5.131 FontScheme .............................................................................................. 678

2.5.132 FormatRun ................................................................................................ 678

2.5.133 FormulaValue ............................................................................................ 678

2.5.134 FrtFlags .................................................................................................... 679

2.5.135 FrtHeader ................................................................................................. 680

2.5.136 FrtHeaderOld ............................................................................................ 680

2.5.137 FrtRefHeader ............................................................................................. 680

2.5.138 FrtRefHeaderNoGrbit .................................................................................. 681

2.5.139 FrtRefHeaderU........................................................................................... 681

2.5.140 FtCbls ...................................................................................................... 682

2.5.141 FtCblsData ................................................................................................ 682

2.5.142 FtCf ......................................................................................................... 683

2.5.143 FtCmo ...................................................................................................... 683

2.5.144 FtEdoData................................................................................................. 686

2.5.145 FtGboData ................................................................................................ 687

2.5.146 FtGmo ...................................................................................................... 687

2.5.147 FtLbsData ................................................................................................. 688

2.5.148 FtMacro .................................................................................................... 690

2.5.149 FtNts ........................................................................................................ 691

2.5.150 FtPictFmla ................................................................................................. 691

2.5.151 FtPioGrbit ................................................................................................. 692

2.5.152 FtRbo ....................................................................................................... 694

19 / 1124

[MS-XLS] - v20171212

Excel Binary File Format (.xls) Structure

Release: December 12, 2017

2.5.153 FtRboData ................................................................................................ 694

2.5.154 FtSbs ....................................................................................................... 695

2.5.155 FullColorExt .............................................................................................. 696

2.5.156 GradStop .................................................................................................. 696

2.5.157 HiddenMemberSet ..................................................................................... 697

2.5.158 HideObjEnum ............................................................................................ 697

2.5.159 HorizAlign ................................................................................................. 698

2.5.160 HorzBrk .................................................................................................... 698

2.5.161 Icv ........................................................................................................... 698

2.5.162 IcvChart ................................................................................................... 702

2.5.163 IcvFont ..................................................................................................... 702

2.5.164 IcvXF ....................................................................................................... 702

2.5.165 IFmt ........................................................................................................ 702

2.5.166 InteriorColorPropertiesForShapePropsStreamChecksum .................................. 703

2.5.167 ISSTInf .................................................................................................... 704

2.5.168 IXFCell ..................................................................................................... 704

2.5.169 KPIProp .................................................................................................... 704

2.5.170 KPISets .................................................................................................... 705

2.5.171 LbsDropData ............................................................................................. 705

2.5.172 LEMMode .................................................................................................. 706

2.5.173 LinePropertiesForShapePropsStreamChecksum .............................................. 707

2.5.174 List12BlockLevel ........................................................................................ 708

2.5.175 List12DisplayName .................................................................................... 710

2.5.176 List12TableStyleClientInfo .......................................................................... 711

2.5.177 LongRGB .................................................................................................. 711

2.5.178 LongRGBA ................................................................................................ 712

2.5.179 LPWideString ............................................................................................ 712

2.5.180 MDir......................................................................................................... 712

2.5.181 MDTInfoIndex ........................................................................................... 713

2.5.182 MDXStrIndex ............................................................................................ 713

2.5.183 MOper ...................................................................................................... 713

2.5.184 NilChartNum ............................................................................................. 714

2.5.185 NoteRR ..................................................................................................... 714

2.5.186 NoteSh ..................................................................................................... 715

2.5.187 ObjFmla ................................................................................................... 716

2.5.188 ObjId ....................................................................................................... 717

2.5.189 ObjLinkFmla .............................................................................................. 717

2.5.190 ODBCType ................................................................................................ 718

2.5.191 OfficeArtClientAnchorChart ......................................................................... 718

2.5.192 OfficeArtClientAnchorHF ............................................................................. 719

2.5.193 OfficeArtClientAnchorSheet ......................................................................... 720

2.5.194 OfficeArtClientData .................................................................................... 721

2.5.195 OfficeArtClientTextbox ................................................................................ 722

2.5.196 PaneType ................................................................................................. 722

2.5.197 PARAMQRY_Fixed ...................................................................................... 723

2.5.198 Parsed Expressions .................................................................................... 724

2.5.198.1 ArrayParsedFormula ............................................................................. 724

2.5.198.2 BErr ................................................................................................... 724

2.5.198.3 CellParsedFormula ............................................................................... 725

2.5.198.4 Cetab ................................................................................................. 725

2.5.198.5 CFParsedFormula ................................................................................. 754

2.5.198.6 CFParsedFormulaNoCCE ........................................................................ 754

2.5.198.7 CFVOParsedFormula ............................................................................. 754

2.5.198.8 ChartParsedFormula ............................................................................. 755

2.5.198.9 DVParsedFormula................................................................................. 755

2.5.198.10 ExtNameParsedFormula ........................................................................ 756

2.5.198.11 ExtPtgArea3D ...................................................................................... 757

2.5.198.12 ExtPtgAreaErr3D .................................................................................. 757

20 / 1124

[MS-XLS] - v20171212

Excel Binary File Format (.xls) Structure

Release: December 12, 2017

2.5.198.13 ExtPtgErr ............................................................................................ 757

2.5.198.14 ExtPtgRef3D ........................................................................................ 758

2.5.198.15 ExtPtgRefErr3D .................................................................................... 758

2.5.198.16 ExtSheetPair ....................................................................................... 758

2.5.198.17 Ftab ................................................................................................... 759

2.5.198.18 Ilel ..................................................................................................... 786

2.5.198.19 ListParsedArrayFormula ........................................................................ 787

2.5.198.20 ListParsedFormula ................................................................................ 787

2.5.198.21 NameParsedFormula ............................................................................ 787

2.5.198.22 ObjectParsedFormula............................................................................ 788

2.5.198.23 ParameterParsedFormula ...................................................................... 788

2.5.198.24 PivotParsedFormula .............................................................................. 789

2.5.198.25 Ptg ..................................................................................................... 789

2.5.198.26 PtgAdd ............................................................................................... 792

2.5.198.27 PtgArea .............................................................................................. 792

2.5.198.28 PtgArea3d ........................................................................................... 793

2.5.198.29 PtgAreaErr .......................................................................................... 793

2.5.198.30 PtgAreaErr3d ....................................................................................... 794

2.5.198.31 PtgAreaN ............................................................................................ 794

2.5.198.32 PtgArray ............................................................................................. 795

2.5.198.33 PtgAttrBaxcel ...................................................................................... 795

2.5.198.34 PtgAttrChoose ..................................................................................... 796

2.5.198.35 PtgAttrGoto ......................................................................................... 796

2.5.198.36 PtgAttrIf ............................................................................................. 797

2.5.198.37 PtgAttrSemi......................................................................................... 797

2.5.198.38 PtgAttrSpace ....................................................................................... 797

2.5.198.39 PtgAttrSpaceSemi ................................................................................ 798

2.5.198.40 PtgAttrSpaceType ................................................................................ 798

2.5.198.41 PtgAttrSum ......................................................................................... 799

2.5.198.42 PtgBool ............................................................................................... 799

2.5.198.43 PtgConcat ........................................................................................... 799

2.5.198.44 PtgDataType ....................................................................................... 799

2.5.198.45 PtgDiv ................................................................................................ 800

2.5.198.46 PtgElfCol ............................................................................................. 800

2.5.198.47 PtgElfColS ........................................................................................... 800

2.5.198.48 PtgElfColSV ......................................................................................... 801

2.5.198.49 PtgElfColV ........................................................................................... 801

2.5.198.50 PtgElfLel ............................................................................................. 801

2.5.198.51 PtgElfRadical ....................................................................................... 802

2.5.198.52 PtgElfRadicalLel ................................................................................... 802

2.5.198.53 PtgElfRadicalS ..................................................................................... 803

2.5.198.54 PtgElfRw ............................................................................................. 803

2.5.198.55 PtgElfRwV ........................................................................................... 804

2.5.198.56 PtgEq ................................................................................................. 804

2.5.198.57 PtgErr ................................................................................................. 804

2.5.198.58 PtgExp ................................................................................................ 804

2.5.198.59 PtgExtraArray ...................................................................................... 805

2.5.198.60 PtgExtraElf .......................................................................................... 805

2.5.198.61 PtgExtraMem ....................................................................................... 806

2.5.198.62 PtgFunc .............................................................................................. 806

2.5.198.63 PtgFuncVar ......................................................................................... 806

2.5.198.64 PtgGe ................................................................................................. 807

2.5.198.65 PtgGt .................................................................................................. 807

2.5.198.66 PtgInt ................................................................................................. 807

2.5.198.67 PtgIsect .............................................................................................. 808

2.5.198.68 PtgLe .................................................................................................. 808

2.5.198.69 PtgLt .................................................................................................. 808

2.5.198.70 PtgMemArea ........................................................................................ 808

剩余1123页未读，继续阅读

butingyu

粉丝: 15
资源: 21

Excel 2003二进制文件格式详解

Excel File Format

Microsoft Excel File Format

Microsoft Excel Binary File Format (.xls) Structure Specification

Word (.doc) Binary File Format

PowerPoint (.ppt) Binary File Format

Shell Link (.LNK) Binary File Format

CPP-binary-file-.rar_c++ file binary

Binary file common.log matches

Binary file libapp.a matches

Binary file insp.log matches

最新资源