openxml开发系列课程7spreadsheetml基础指南

SpreadsheetML

基础开发先开发工程师中达金桥技术服务议题Workbook

体系结构Office

Open

XML

Developer

WorkshopSpreadsheetML

文档结构WorkbookpropertiesstylessharedStringscalcChainsheet1..NtablechartdrawingOpen

XML

Developer

WorkshopSpreadsheetML

设计目标:性能SpreadsheetML

有很我方法可以达到最优化,基于对现实世界中spreadsheet的使用模式进行分析:Optional

r=“A1”

attribute

for

faster

loading最小的XLSX所必须的部件需要:workbook.xml,文档的“start

part”worksheet.xml.rels_rels[Content

T

es].xmlPackage

relationships

(for

the

required

relationships)其它部件是可选择的Worksheet

<sheetdata>也是必须的,但是可以空Office

Open

XML

Developer

Workshop最小的Workbook/WorksheetrelationshipDEMOOffice

Open

XML

Developer

WorkshopCreate

SpreadsheetML

文档Office

Open

XML

Developer

Workshop议题剖析XLSX文档Office

Open

XML

Developer

WorkshopSheet

类型Sheet

实例=‘C:\[ExternalBook.xlsx]Sheet1’!$A$1Worksheet

Part–主要部件Office

Open

XML

Developer

WorkshopSheet

属性Cell

Table:<sheetData>

元素mergeCellsSheet‐Level

的各个部件无数据Workbook

属性:元素<fileVersion><workbookPr><calcPr><bookViews><sheets>Get

SpreadsheetML

infoOffice

Open

XML

Developer

Workshop议题Strings:

inline

plain

text,

rich

text,

shared

stringsSpreadsheetML中的Strings

介绍Inline

Strings<sheetData><row><c

t="inlineStr"><is><t>Paris</t></is></c></row><row><c

t="inlineStr"><is><t>Seattle</t></is></c></row><row><c

t="inlineStr"><is><t>London</t></is></c></row><row><c

t="inlineStr"><is><t>Copenhagen</t></is></c></row><row><c

t="inlineStr"><is><t>Paris</t></is></c></row><row><c

t="inlineStr"><is><t>London</t></is></c></row></sheetData>Shared

StringsShared

Strings:实例<sst

xmlns="..."

count="6"

uniqueCount="4"><si><t>Paris</t></si><si><t>Seattle</t></si><si><t>London</t></si><si><t>Copenhagen</t></si></sst><row

r="1"

spans="1:1"><c

r="A1"

t="s"><v>0</v></c></row>Rich

Text

Strings<rPr>"

"

"

"<sst

xmlns=“…"

count="1"

uniqueCount="1"><si><r><t

xml:space="preserve">This

cell

contains</t></r><r><rPr><b/><sz

val="11"/><color

theme="1"/><rFont

val="Calibri"/><family

val="2"/><scheme

val="minor"/></rPr><t>bold</t></r><r><t

xml:space="preserve">

and

</t></r><r><rPr><i/><sz

val="11"/><color

theme="1"/><rFont

val="Calibri"/><family

val="2"/><scheme

val="minor"/></rPr><t>italics</t></r><r><t

xml:space="preserve">

text.</t></r></si></sst><row

r=

1 spans=

1:1

><c

r="A1"

t="s"><v>0</v></c></row>Office

Open

XML

Developer

Workshop议题格式化选项SpreadsheetML

格式化选项Office

Open

XML

Developer

Workshop直接格式化议题Calculation

Chain计算公式计算链Multi‐threading

optimizations不需要改变应用程序去使计算的顺序发生改变Multi‐Threaded

计算Office

Open

XML

Developer

Workshop计算链实例Office

Open

XML

Developer

Workshop计算链实例1st

Calculation:2nd

Calculation:20th

Calculation:Office

Open

XML

De