Excel文件格式

OpenOffice.org'sDocumentationoftheMicrosoftExcelFileFormatExcelVersions2,3,4,5,95,97,2000,XP,2003AuthorDanielRentz✉mailto:[e-mail]öcker,CharlesWybleOthersourcesHyperlinkstoWikipedia()forvariousextendedinformationMailinglist✉mailto:[e-mail]✉mailto:[e-mail](BIFF8)11024.12ConditionalFormattingTable(BIFF8)1124.13HyperlinkTable(BIFF8)1124.14DataValidityTable(BIFF8)1124.15AutoFilter,AdvancedFilter1134.16Scenarios1134.17WebQueries(BIFF8)1134.18Worksheet/WorkbookProtection1144.19FileProtection1175Worksheet/WorkbookRecords........................................................................1205.1Overview,OrderedbyRecordIdentifier1205.2Overview,OrderedbyRecordNames1245.3Overview,OrderedbyBIFFVersions1275.4ARRAY1325.5BACKUP1335.6BITMAP1335.7BLANK1345.8BOF–BeginningofFile1355.9BOOKBOOL1375.10BOOLERR1375.11BOTTOMMARGIN1385.12BUILTINFMTCOUNT1385.13CALCCOUNT1395.14CALCMODE1395.15CFHEADER1395.16CFRULE–ConditionalFormattingRule1405.17CODEPAGE1455.18COLINFO1465.19COLUMNDEFAULT1475.20COLWIDTH1475.21CONTINUE1485.22COUNTRY1495.23CRN1505.24DATATABLE–MultipleOperationTable1515.25DATATABLE2–MultipleOperationTable1525.26DATAVALIDATION1535.27DATAVALIDATIONS1545.28DATEMODE1545.29DBCELL1555.30DCONREF–DataConsolidationReference1555.31DEFAULTROWHEIGHT1565.32DEFCOLWIDTH1565.33DEFINEDNAME1575.34DELTA1605.35DIMENSION1605.36DSF–DoubleStreamFile1615.37EOF–EndofFile1615.38EXTERNALBOOK–ExternalWorkbook1625.39EXTERNALNAME1645.40EXTERNCOUNT1665.41EXTERNSHEET1665.42EXTSST–ExtendedSST1675.43FILEPASS1685.44FILESHARING1705.45FONT1715.46FONT217335.47FONTCOLOR1735.48FOOTER1735.49FORMAT1745.50FORMULA1765.51GCW–GlobalColumnWidth1785.52GRIDSET1795.53GUTS1795.54HCENTER1795.55HEADER1805.56HIDEOBJ1815.57HORIZONTALPAGEBREAKS1815.58HYPERLINK1825.59INDEX1855.60INTEGER1865.61ITERATION1865.62IXFE–IndextoXF1865.63LABEL1875.64LABELRANGES1875.65LABELSST1885.66LEFTMARGIN1885.67MERGEDCELLS1885.68MULBLANK–MultipleBLANK1895.69MULRK–MultipleRK1895.70NOTE1905.71NUMBER1915.72OBJECTPROTECT1915.73PAGESETUP1925.74PALETTE1955.75PANE1975.76PASSWORD1975.77PHONETICPR1985.78PLS1985.79PRECISION1985.80PRINTGRIDLINES1995.81PRINTHEADERS1995.82PROTECT2005.83QUICKTIP2005.84RANGEPROTECTION2005.85REFMODE2015.86RIGHTMARGIN2015.87RK2015.88ROW2025.89RSTRING2045.90SAVERECALC2045.91SCENPROTECT2055.92SCL2055.93SELECTION2055.94SHAREDFMLA–SharedFormula2065.95SHEET2065.96SHEETLAYOUT2075.97SHEETPR2075.98SHEETPROTECTION2085.99SORT2095.100SST–SharedStringTable2105.101STANDARDWIDTH2105.102STRING2115.103STYLE21245.104TOPMARGIN2135.105UNCALCED2135.106USESELFS2135.107VCENTER2145.108VERTICALPAGEBREAKS2145.109WINDOW12155.110WINDOW22165.111WINDOWPROTECT2175.112WRITEACCESS2185.113WRITEPROT2185.114XCT–CRNCount2185.115XF–ExtendedFormat2196DrawingObjects..............................................................................................2257Charts...............................................................................................................2267.1DocumentIntegration2267.2GeneralChartStructure2297.3CommonRecordBlocks2317.4RecordOverview,OrderedbyIdentifier2347.5RecordOverview,OrderedbyName2357.6CHAREAFORMAT2367.7CHAXISLINE2377.8CHBEGIN–BeginofBlock2387.9CHEND–EndofBlock2397.10CHFRAME2407.11CHLINEFORMAT2417.12CHSOURCELINK2427.13CHSTRING2438PivotTables...................................................................