open xml開發(fā)系列課程7spreadsheetml基礎(chǔ)指南

SpreadsheetML基礎(chǔ)先開發(fā)工中達(dá)金橋技術(shù)服OfficeOpenXMLDeveloper議議Workbook體系結(jié)構(gòu)Strings:inlineplaintext,richtext,sharedOfficeOfficeOpenXMLDeveloperSpreadsheetML文檔結(jié) OpenXMLDeveloperSpreadsheetML有很我方法可以達(dá)到最優(yōu)化,基于對(duì)現(xiàn)實(shí)世界SpreadsheetMLSpreadsheetML有很我方法可以達(dá)到最優(yōu)化,基于對(duì)現(xiàn)實(shí)世界Smalltagsize(oftenasinglecharacter)SharedstringsSharedSparsetablemarkupOptionalOptionalr=“A1”attributeforfasterOfficeOpenXMLDeveloper最小的XLSX所必須的部需要:workbook.xml,start需要:至少一sheet,需要:一個(gè)關(guān)系部件需要:[Content RequiredpartforallOpen 三種內(nèi)容類型必須被定義SpreadsheetML (forthestartPackagerelationships(fortherequired其它部件是可選Worksheet<sheetdata>也是必須的,但是可OfficeOpenXMLDeveloper最小的

name="Sheet1" " OfficeOpenXMLDeveloperCreateCreateSpreadsheetMLOfficeOfficeOpenXMLDeveloper議Workbook體系結(jié)構(gòu)Strings:inlineplaintext,richtext,sharedOfficeOfficeOpenXMLDeveloperChartSheetDialogChartSheetDialogOfficeOpenXMLDeveloperSheet實(shí)OfficeOpenXMLDeveloperWorksheetPart主要部Sheet屬性(everythingbeforeViewing:selectedtab,activecell,Printoptions:orientation,resolution,pagemargins,Miscellaneous:defaultrowheight,sheetprotection,Thecelltable(sheetData,emptyifnotaRow,cells,values,strings(shared‐stringsindexes),OfficeOfficeOpenXMLDeveloperOfficeOpenXMLDeveloperCellTable:<sheetData>OfficeOpenXMLDeveloperOfficeOpenXMLDeveloperSheet‐Level的各個(gè)部SpecialDirectory OfficeOpenXMLDeveloperWorkbook屬性O(shè)fficeOpenXMLDeveloperGetSpreadsheetMLOfficeOfficeOpenXMLDeveloper議Workbook體系結(jié)構(gòu)Strings:inlineplaintext,richtext,sharedCalculationOfficeOpenXMLDeveloperSpreadsheetML中的Strings 方法InlineXSLT場(chǎng)景下特別shared‐strings表可以是一個(gè)簡(jiǎn)單的字這些方法可以被組合或混合OfficeOpenXMLDeveloperInline在XSLT的場(chǎng)景下尤為Excel2007 的時(shí)候就會(huì)被轉(zhuǎn)化為shared如果您要使用OpenXML文檔,您就需要處理兩種方式inline和/或者shared如果我們要shared‐strings實(shí)例轉(zhuǎn)化inline只需要替換<row><c<row><c<row><c<row><c<row><c<row><cOfficeOpenXMLDeveloperShared默認(rèn)情況下,字符信息都 在shared‐strings每一個(gè)字符信息 一 的是string的index這種設(shè)計(jì)取決于分析典型的spreadsheet內(nèi)容:字符信好處 :所有的字符信息 公用的string‐handling目標(biāo)OfficeOpenXMLDeveloperSharedStrings:實(shí)Worksheet內(nèi)容sharedStrings.xml內(nèi)容<sstxmlns="..."count="6"

6string4uniquestringsParis=string0<rowr="1"<cr="A1"OfficeOpenXMLDeveloperRichText

<sz<color<rFont<family<scheme于Oneentryfortheentire

NoterunpropertiesCellreferstostring" <rowr=1" <cr="A1"

<szval="11"/><color<rFont<family<schemeOfficeOpenXMLDeveloper議Workbook體系結(jié)構(gòu)Strings:inlineplaintext,richtext,sharedCalculationOfficeOpenXMLDeveloperSpreadsheetML格式化選直接Cell格式化NumericCellTablePivotTableOfficeOfficeOpenXMLDeveloper直接格式OfficeOpenXMLDeveloper議Workbook體系結(jié)構(gòu)Strings:inlineplaintext,richtext,sharedCalculationOfficeOpenXMLDeveloper計(jì)算公I(xiàn)mplication:Excelre‐parsestheformulaonload,andserializesitonsave 到外部的抽象的文件路徑到relationshipsExcelcaches可 外部workbook的結(jié)構(gòu)(sheets&cellOfficeOpenXMLDeveloper計(jì)算最后被計(jì)算的cells的順計(jì)算鏈的運(yùn)行順序發(fā)生改變,取決于以下條件Dependency發(fā)生改變的Multi‐threadingMulti‐threading不需要改變應(yīng)用程序去使計(jì)算的順序發(fā)生OfficeOpenXMLDeveloperMulti‐Threaded“ChildChain”(@s)標(biāo)記 Notfiguredusingdependencies,onlyusingcalculation“Depen