5.1 SpreadsheetDataXML
-
<xs:schema id="SpreadsheetDataXML" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="Workbook" type="CT_Workbook"> <xs:key name="styleIDKey"> <xs:selector xpath="./Styles/Style"/> <xs:field xpath="@ID"/> </xs:key> <xs:keyref name="tableStyleIDKeyRef" refer="styleIDKey"> <xs:selector xpath="./Worksheet/Table"/> <xs:field xpath="@StyleID"/> </xs:keyref> <xs:keyref name="columnStyleIDKeyRef" refer="styleIDKey"> <xs:selector xpath="./Worksheet/Table/Column"/> <xs:field xpath="@StyleID"/> </xs:keyref> <xs:keyref name="columnBorderStyleIDKeyRef" refer="styleIDKey"> <xs:selector xpath="./Worksheet/Table/Column"/> <xs:field xpath="@BorderID"/> </xs:keyref> <xs:keyref name="rowStyleIDKeyRef" refer="styleIDKey"> <xs:selector xpath="./Worksheet/Table/Row"/> <xs:field xpath="@StyleID"/> </xs:keyref> <xs:keyref name="rowBorderStyleIDKeyRef" refer="styleIDKey"> <xs:selector xpath="./Worksheet/Table/Row"/> <xs:field xpath="@BorderID"/> </xs:keyref> <xs:keyref name="cellStyleIDKeyRef" refer="styleIDKey"> <xs:selector xpath="./Worksheet/Table/Row/Cell"/> <xs:field xpath="@StyleID"/> </xs:keyref> <xs:keyref name="cellBorderStyleIDKeyRef" refer="styleIDKey"> <xs:selector xpath="./Worksheet/Table/Row/Cell"/> <xs:field xpath="@BorderID"/> </xs:keyref> <xs:keyref name="imagesBorderStyleIDKeyRef" refer="styleIDKey"> <xs:selector xpath="./Worksheet/Images/Image"/> <xs:field xpath="@BorderID"/> </xs:keyref> </xs:element> <xs:complexType name="CT_WorkbookOptions"> <xs:sequence> <xs:element name="HideWorkbookTabs" minOccurs="0" maxOccurs="1"/> </xs:sequence> </xs:complexType> <xs:simpleType name="ST_ObjectName"> <xs:restriction base="xs:string"> <xs:minLength value="1"/> <xs:maxLength value="255"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_SheetName"> <xs:restriction base="xs:string"> <xs:minLength value="1"/> <xs:maxLength value="31"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_SheetOrObjectName"> <xs:union memberTypes="ST_SheetName ST_ObjectName"/> </xs:simpleType> <xs:simpleType name="ST_Comment"> <xs:restriction base="xs:string"> <xs:maxLength value="255"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_Parameter"> <xs:attribute name="Name" use="required" type="ST_ObjectName"/> <xs:attribute name="Comment" use="optional" type="ST_Comment"/> <xs:attribute name="IsPivotPageField" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="IsSlicer" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="RequiresConnection" type="xs:boolean" default="false" use="optional"/> </xs:complexType> <xs:complexType name="CT_Parameters"> <xs:sequence> <xs:element name="Parameter" minOccurs="1" maxOccurs="255" type="CT_Parameter"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_NamedObject"> <xs:attribute name="Name" type="ST_ObjectName" use="required"/> <xs:attribute name="Type" type="ST_enmNamedObjectType" use="required"/> <xs:attribute name="SheetName" type="ST_SheetName" use="required"/> <xs:attribute name="DisplayRightToLeft" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="LastNonEmptyRow" type="ST_excelRowNumber1Based" use="optional"/> <xs:attribute name="LastNonEmptyColumn" type="ST_excelColNumber1Based" use="optional"/> <xs:attribute name="CurrentFirstRow" type="ST_excelRowNumber1Based" use="optional"/> <xs:attribute name="FirstVisibleRow" type="ST_excelRowNumber1Based" use="optional"/> <xs:attribute name="LastVisibleRow" type="ST_excelRowNumber1Based" use="optional"/> <xs:attribute name="CurrentFirstColumn" type="ST_excelColNumber1Based" use="optional"/> <xs:attribute name="FirstVisibleColumn" type="ST_excelColNumber1Based" use="optional"/> <xs:attribute name="LastVisibleColumn" type="ST_excelColNumber1Based" use="optional"/> <xs:attribute name="DisplayOutlines" type="xs:boolean" default="false" use="optional"/> </xs:complexType> <xs:complexType name="CT_NamedObjects"> <xs:sequence> <xs:element name="NamedObject" minOccurs="1" maxOccurs="unbounded" type="CT_NamedObject"/> </xs:sequence> </xs:complexType> <xs:simpleType name="ST_Size"> <xs:restriction base="xs:double"> <xs:minInclusive value="1.0"/> <xs:maxInclusive value="409.0"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_Font"> <xs:attribute name="Size" default="11" use="optional" type="ST_Size"/> <xs:attribute name="FontName" type="xs:string" use="required"/> <xs:attribute name="Color" type="ST_rgbTuple" default="#000000" use="optional"/> <xs:attribute name="Bold" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="Italic" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="StrikeThrough" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="VerticalAlign" type="ST_enmFontVerticalAlignment" default="None" use="optional"/> <xs:attribute name="Underline" type="ST_enmFontUnderline" default="None" use="optional"/> </xs:complexType> <xs:simpleType name="ST_Rotate"> <xs:restriction base="xs:int"> <xs:minInclusive value="-90"/> <xs:maxInclusive value="90"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_Alignment"> <xs:attribute name="Horizontal" type="ST_enmHorizontalAlignment" default="Automatic" use="optional"/> <xs:attribute name="WrapText" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="Rotate" default="0" use="optional" type="ST_Rotate"/> <xs:attribute name="VerticalText" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="Vertical" type="ST_enmVerticalAlignment" default="Bottom" use="optional"/> <xs:attribute name="ReadingOrder" type="ST_enmReadOrder" default="Context" use="optional"/> <xs:attribute name="ShrinkToFit" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="Indent" type="xs:unsignedInt" default="0" use="optional"/> </xs:complexType> <xs:complexType name="CT_Interior"> <xs:attribute name="Color" type="ST_rgbTuple"/> <xs:attribute name="Pattern" type="ST_enmPattern" use="optional"/> <xs:attribute name="PatternColor" type="ST_rgbTuple" use="optional"/> </xs:complexType> <xs:complexType name="CT_stop"> <xs:attribute name="position" type="ST_percentage" use="required"/> <xs:attribute name="Color" type="ST_rgbTuple" use="required"/> </xs:complexType> <xs:simpleType name="ST_degree"> <xs:restriction base="xs:double"> <xs:minInclusive value="0.0"/> <xs:maxExclusive value="360.0"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_gradient"> <xs:sequence> <xs:element name="stop" minOccurs="2" maxOccurs="3" type="CT_stop"/> </xs:sequence> <xs:attribute name="degree" default="0.0" use="optional" type="ST_degree"/> <xs:attribute name="type" type="ST_enmGradientType" default="Linear" use="optional"/> <xs:attribute name="left" type="ST_percentage" default="0" use="optional"/> <xs:attribute name="right" type="ST_percentage" default="0" use="optional"/> <xs:attribute name="top" type="ST_percentage" default="0" use="optional"/> <xs:attribute name="bottom" type="ST_percentage" default="0" use="optional"/> </xs:complexType> <xs:simpleType name="ST_Weight"> <xs:restriction base="xs:int"> <xs:minInclusive value="0"/> <xs:maxInclusive value="3"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_Border"> <xs:attribute name="Position" type="ST_enmBorderPosition" use="required"/> <xs:attribute name="LineStyle" type="ST_enmBorderLineStyle" default="None" use="optional"/> <xs:attribute name="Weight" use="required" type="ST_Weight"/> <xs:attribute name="Color" type="ST_rgbTuple" use="required"/> </xs:complexType> <xs:complexType name="CT_Borders"> <xs:sequence> <xs:element name="Border" minOccurs="0" maxOccurs="4" type="CT_Border"/> </xs:sequence> </xs:complexType> <xs:simpleType name="ST_ID"> <xs:union memberTypes="ST_cellStyleID ST_borderStyleID"/> </xs:simpleType> <xs:complexType name="CT_Style"> <xs:choice> <xs:group ref="cellStyle"/> <xs:group ref="borderStyle"/> </xs:choice> <xs:attribute name="ID" use="required" type="ST_ID"/> </xs:complexType> <xs:group name="cellStyle"> <xs:sequence> <xs:element name="Font" minOccurs="0" maxOccurs="1" type="CT_Font"/> <xs:element name="Alignment" minOccurs="0" maxOccurs="1" type="CT_Alignment"/> <xs:choice minOccurs="0" maxOccurs="1"> <xs:element name="Interior" type="CT_Interior"/> <xs:element name="gradient" type="CT_gradient"/> </xs:choice> </xs:sequence> </xs:group> <xs:group name="borderStyle"> <xs:sequence> <xs:element name="Borders" minOccurs="0" maxOccurs="1" type="CT_Borders"/> </xs:sequence> </xs:group> <xs:complexType name="CT_Styles"> <xs:sequence> <xs:element name="Style" minOccurs="1" maxOccurs="unbounded" type="CT_Style"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_WorksheetOptions"> <xs:attribute name="DoNotDisplayGridlines" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="DoNotDisplayHeadings" type="xs:boolean" use="optional"/> <xs:attribute name="DisplayRightToLeft" type="xs:boolean" use="optional"/> <xs:attribute name="TabColor" type="ST_rgbTuple" use="optional"/> <xs:attribute name="DisplayOutlines" type="xs:boolean" default="false" use="optional"/> </xs:complexType> <xs:simpleType name="ST_value"> <xs:restriction base="xs:string"> <xs:maxLength value="32767"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_Criteria"> <xs:attribute name="Type" type="ST_enmAutoFilterCriteriaOperationType" default="EQ" use="optional"/> <xs:attribute name="Relation" type="ST_enmAutoFilterCriteriaRelationOperator" default="Nil" use="optional"/> <xs:attribute name="value" use="required" type="ST_value"/> </xs:complexType> <xs:simpleType name="ST_value1"> <xs:restriction base="xs:int"> <xs:minInclusive value="0"/> <xs:maxInclusive value="500"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_top10"> <xs:attribute name="percent" type="xs:boolean" use="required"/> <xs:attribute name="top" type="xs:boolean" use="required"/> <xs:attribute name="value" use="required" type="ST_value1"/> </xs:complexType> <xs:complexType name="CT_item"> <xs:sequence> <xs:element name="Criteria" minOccurs="0" maxOccurs="2" type="CT_Criteria"/> <xs:element name="top10" minOccurs="0" maxOccurs="1" type="CT_top10"/> </xs:sequence> <xs:attribute name="Index" type="ST_excelColNumber" default="0" use="optional"/> <xs:attribute name="Name" type="xs:string" use="optional"/> <xs:attribute name="Top10" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="Type" type="ST_enmFilterItemType" default="None" use="optional"/> <xs:attribute name="CriteriaType" type="ST_enmAutoFilterItemCriteriaType" default="Nil" use="optional"/> <xs:attribute name="DataType" type="ST_enmAutoFilterItemType" default="Number" use="optional"/> <xs:attribute name="Filter" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="Custom" type="xs:boolean" default="false" use="optional"/> </xs:complexType> <xs:simpleType name="ST_Type"> <xs:restriction base="xs:string"> <xs:enumeration value="Sheet"/> <xs:enumeration value="Table"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_autofilter"> <xs:sequence> <xs:element name="item" minOccurs="0" maxOccurs="16384" type="CT_item"/> </xs:sequence> <xs:attribute name="ID" type="xs:int" default="0" use="optional"/> <xs:attribute name="Row" type="ST_excelRowNumber" default="0" use="optional"/> <xs:attribute name="ColFirst" type="ST_excelColNumber" default="0" use="optional"/> <xs:attribute name="Type" use="required" type="ST_Type"/> </xs:complexType> <xs:complexType name="CT_autofilters"> <xs:sequence> <xs:element name="autofilter" minOccurs="1" maxOccurs="unbounded" type="CT_autofilter"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_Operation"> <xs:attribute name="Type" type="ST_enmPivotRangeOperation"/> </xs:complexType> <xs:complexType name="CT_Operations"> <xs:sequence> <xs:element name="Operation" minOccurs="1" maxOccurs="unbounded" type="CT_Operation"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_range"> <xs:sequence> <xs:element name="Operations" minOccurs="1" maxOccurs="1" type="CT_Operations"/> </xs:sequence> <xs:attribute name="FirstColumn" type="ST_excelColNumber" use="optional" default="0"/> <xs:attribute name="FirstRow" type="ST_excelRowNumber" use="optional" default="0"/> <xs:attribute name="LastColumn" type="ST_excelColNumber" use="optional" default="0"/> <xs:attribute name="LastRow" type="ST_excelRowNumber" use="optional" default="0"/> </xs:complexType> <xs:complexType name="CT_Ranges"> <xs:sequence> <xs:element name="range" minOccurs="0" maxOccurs="unbounded" type="CT_range"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_DataField"> <xs:attribute name="Name" type="ST_nonEmptyString"/> <xs:attribute name="Id" type="ST_nonEmptyString"/> </xs:complexType> <xs:complexType name="CT_DataFields"> <xs:sequence> <xs:element name="DataField" minOccurs="1" maxOccurs="unbounded" type="CT_DataField"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_PivotTable"> <xs:sequence> <xs:element name="Ranges" minOccurs="1" maxOccurs="1" type="CT_Ranges"/> <xs:element name="DataFields" minOccurs="0" maxOccurs="1" type="CT_DataFields"/> </xs:sequence> <xs:attribute name="ExternalSourceIndex" type="xs:nonNegativeInteger" default="0" use="optional"/> <xs:attribute name="AdvancedFilters" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="LocalSource" type="xs:boolean" use="optional" default="false"/> <xs:attribute name="Name" type="ST_nonEmptyString"/> <xs:attribute name="DataConnectionName" type="ST_nonEmptyString"/> <xs:attribute name="ShowDrillIndicators" type="xs:boolean" default="true" use="optional"/> <xs:attribute name="RequiresConnection" type="xs:boolean" use="optional" default="false"/> </xs:complexType> <xs:complexType name="CT_PivotTables"> <xs:sequence> <xs:element name="PivotTable" minOccurs="1" maxOccurs="unbounded" type="CT_PivotTable"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_Location"> <xs:attribute name="top" type="ST_excelRowNumber" use="required"/> <xs:attribute name="left" type="ST_excelColNumber" use="required"/> <xs:attribute name="bottom" type="ST_excelRowNumber" use="required"/> <xs:attribute name="right" type="ST_excelColNumber" use="required"/> <xs:attribute name="SheetName" type="ST_SheetName" use="required"/> <xs:attribute name="Type" type="ST_enmNamedObjectType" use="optional" default="InvalidNamedObjectType"/> <xs:attribute name="ObjectName" type="ST_ObjectName" use="optional"/> </xs:complexType> <xs:complexType name="CT_Hyperlink"> <xs:sequence> <xs:choice> <xs:element name="Target" type="ST_nonEmptyString"/> <xs:element name="Location" type="CT_Location"/> </xs:choice> <xs:element name="Tooltip" type="xs:string" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="top" type="ST_excelRowNumber" use="required"/> <xs:attribute name="left" type="ST_excelColNumber" use="required"/> <xs:attribute name="bottom" type="ST_excelRowNumber" use="required"/> <xs:attribute name="right" type="ST_excelColNumber" use="required"/> </xs:complexType> <xs:complexType name="CT_Hyperlinks"> <xs:sequence> <xs:element name="Hyperlink" minOccurs="0" maxOccurs="unbounded" type="CT_Hyperlink"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_ChartMetaData"> <xs:sequence/> <xs:attribute name="ChartCategory" type="ST_enmChartCategory" use="required"/> <xs:attribute name="IsStackedType" type="xs:boolean" use="required"/> <xs:attribute name="Is100PercentStackedType" type="xs:boolean" use="required"/> <xs:attribute name="HasSimpleDataRange" type="xs:boolean" use="optional"/> <xs:attribute name="DataRangeForDisplay" type="xs:string" use="optional"/> <xs:attribute name="IsPivotChart" type="xs:boolean" use="optional"/> <xs:attribute name="DataSourceEmpty" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="HasNoVisibleSeries" type="xs:boolean" default="false" use="optional"/> </xs:complexType> <xs:complexType name="CT_Image"> <xs:sequence> <xs:element name="ChartMetaData" minOccurs="0" maxOccurs="1" type="CT_ChartMetaData"/> </xs:sequence> <xs:attribute name="Id" type="ST_nonEmptyString" use="required"/> <xs:attribute name="ImageName" type="xs:string" use="required"/> <xs:attribute name="Type" type="ST_enmImageType" use="optional" default="chart"/> <xs:attribute name="Version" type="xs:int" use="required"/> <xs:attribute name="Width" type="ST_nonNegativeDouble" use="required"/> <xs:attribute name="Height" type="ST_nonNegativeDouble" use="required"/> <xs:attribute name="BorderID" type="ST_borderStyleID" use="optional"/> <xs:attribute name="ZOrder" type="xs:int" use="required"/> <xs:attribute name="XOriginDelta" type="xs:double" default="0" use="optional"/> <xs:attribute name="YOriginDelta" type="xs:double" default="0" use="optional"/> <xs:attribute name="AbsoluteLeft" type="xs:double" use="required"/> <xs:attribute name="AbsoluteTop" type="xs:double" use="required"/> <xs:attribute name="AbsoluteRight" type="xs:double" use="required"/> <xs:attribute name="AbsoluteBottom" type="xs:double" use="required"/> <xs:attribute name="ClippedWidth" type="ST_nonNegativeDouble" default="0" use="optional"/> <xs:attribute name="ClippedHeight" type="ST_nonNegativeDouble" default="0" use="optional"/> <xs:attribute name="Visible" type="xs:boolean" default="true" use="optional"/> <xs:attribute name="AltText" type="xs:string" use="optional"/> <xs:attribute name="LockAspectRatio" type="xs:boolean" default="false" use="optional"/> </xs:complexType> <xs:complexType name="CT_Images"> <xs:sequence> <xs:element name="Image" minOccurs="1" maxOccurs="unbounded" type="CT_Image"/> </xs:sequence> </xs:complexType> <xs:simpleType name="ST_DefaultRowHeight"> <xs:union> <xs:simpleType> <xs:restriction base="ST_rowHeight"/> </xs:simpleType> <xs:simpleType> <xs:restriction base="xs:double"> <xs:enumeration value="0"/> </xs:restriction> </xs:simpleType> </xs:union> </xs:simpleType> <xs:simpleType name="ST_DefaultColumnWidth"> <xs:union> <xs:simpleType> <xs:restriction base="ST_columnWidth"/> </xs:simpleType> <xs:simpleType> <xs:restriction base="xs:double"> <xs:enumeration value="0"/> </xs:restriction> </xs:simpleType> </xs:union> </xs:simpleType> <xs:simpleType name="ST_SelectionTop"> <xs:restriction base="xs:int"> <xs:minInclusive value="0"/> <xs:maxInclusive value="1048576"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_SelectionLeft"> <xs:restriction base="xs:int"> <xs:minInclusive value="0"/> <xs:maxInclusive value="16384"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_Table"> <xs:sequence> <xs:element name="Column" minOccurs="0" maxOccurs="16384" type="CT_ColumnAxisItem"/> <xs:element name="Row" minOccurs="0" maxOccurs="1048576" type="CT_RowAxisItem"/> </xs:sequence> <xs:attribute name="LastNonEmptyRow" type="ST_excelRowNumber1Based" use="required"/> <xs:attribute name="LastNonEmptyColumn" type="ST_excelColNumber1Based" use="required"/> <xs:attribute name="CurrentFirstRow" type="ST_excelRowNumber1Based" use="required"/> <xs:attribute name="FirstVisibleRow" type="ST_excelRowNumber1Based" use="required"/> <xs:attribute name="CurrentFirstRowVisibleOffset" type="ST_excelRowNumber" default="0" use="optional"/> <xs:attribute name="LastVisibleRow" type="ST_excelRowNumber1Based" default="1048576" use="optional"/> <xs:attribute name="CurrentFirstColumn" type="ST_excelColNumber1Based" use="required"/> <xs:attribute name="FirstVisibleColumn" type="ST_excelColNumber1Based" use="required"/> <xs:attribute name="CurrentFirstColumnVisibleOffset" type="ST_excelColNumber" default="0" use="optional"/> <xs:attribute name="LastVisibleColumn" type="ST_excelColNumber1Based" default="16384" use="optional"/> <xs:attribute name="DefaultRowHeight" default="12.75" use="optional" type="ST_DefaultRowHeight"/> <xs:attribute name="DefaultColumnWidth" default="48" use="optional" type="ST_DefaultColumnWidth"/> <xs:attribute name="DefaultIndentWidth" type="xs:double" default="9" use="optional"/> <xs:attribute name="SelectionTop" default="0" use="optional" type="ST_SelectionTop"/> <xs:attribute name="SelectionLeft" default="0" use="optional" type="ST_SelectionLeft"/> <xs:attribute name="summaryRight" type="xs:boolean" default="true" use="optional"/> <xs:attribute name="summaryBelow" type="xs:boolean" default="true" use="optional"/> <xs:attribute name="outlineLevelCol" type="ST_excelOutlineLevels" use="optional" default="0"/> <xs:attribute name="outlineLevelRow" type="ST_excelOutlineLevels" use="optional" default="0"/> </xs:complexType> <xs:complexType name="CT_Slicer"> <xs:sequence/> <xs:attribute name="Name" type="ST_nonEmptyString" use="required"/> <xs:attribute name="Caption" type="xs:string" use="required"/> <xs:attribute name="SlicerCacheId" type="xs:int" use="required"/> <xs:attribute name="SlicerViewId" type="xs:int" use="required"/> <xs:attribute name="ExternalSourceIndex" type="xs:int" default="0" use="optional"/> <xs:attribute name="Version" type="xs:int" use="required"/> <xs:attribute name="Width" type="ST_nonNegativeDouble" use="required"/> <xs:attribute name="Height" type="ST_nonNegativeDouble" use="required"/> <xs:attribute name="ZOrder" type="xs:int" use="required"/> <xs:attribute name="XOriginDelta" type="xs:double" default="0" use="optional"/> <xs:attribute name="YOriginDelta" type="xs:double" default="0" use="optional"/> <xs:attribute name="ClippedWidth" type="ST_nonNegativeDouble" default="0" use="optional"/> <xs:attribute name="ClippedHeight" type="ST_nonNegativeDouble" default="0" use="optional"/> <xs:attribute name="Visible" type="xs:boolean" default="true" use="optional"/> <xs:attribute name="HasConnection" type="xs:boolean" default="true" use="optional"/> </xs:complexType> <xs:complexType name="CT_Slicers"> <xs:sequence> <xs:element name="Slicer" minOccurs="0" maxOccurs="unbounded" type="CT_Slicer"/> </xs:sequence> </xs:complexType> <xs:complexType name="CT_Worksheet"> <xs:sequence> <xs:element name="WorksheetOptions" minOccurs="0" maxOccurs="1" type="CT_WorksheetOptions"/> <xs:element name="autofilters" minOccurs="0" maxOccurs="1" type="CT_autofilters"/> <xs:element name="PivotTables" minOccurs="0" maxOccurs="1" type="CT_PivotTables"/> <xs:element name="Slicers" maxOccurs="1" minOccurs="0" type="CT_Slicers"/> <xs:element name="Hyperlinks" minOccurs="0" maxOccurs="1" type="CT_Hyperlinks"/> <xs:element name="Images" maxOccurs="1" minOccurs="0" type="CT_Images"/> <xs:element name="Table" minOccurs="0" maxOccurs="1" type="CT_Table"/> </xs:sequence> <xs:attribute name="ActiveSheet" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="ChartSheet" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="Name" type="ST_SheetOrObjectName" use="required"/> <xs:attribute name="NameRTL" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="NamedRange" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="SheetName" type="ST_SheetName" use="optional"/> </xs:complexType> <xs:complexType name="CT_Workbook" final="restriction"> <xs:sequence> <xs:element name="WorkbookOptions" type="CT_WorkbookOptions"/> <xs:element name="Parameters" maxOccurs="1" minOccurs="0" type="CT_Parameters"/> <xs:element name="NamedObjects" minOccurs="0" maxOccurs="1" type="CT_NamedObjects"/> <xs:element name="Styles" minOccurs="0" maxOccurs="1" type="CT_Styles"/> <xs:element name="Worksheet" minOccurs="1" maxOccurs="unbounded" type="CT_Worksheet"/> </xs:sequence> </xs:complexType> <xs:simpleType name="ST_cellStyleID" final="restriction"> <xs:restriction base="xs:string"> <xs:pattern value="sD|0|[1-9][0-9]*"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_borderStyleID" final="restriction"> <xs:restriction base="xs:string"> <xs:pattern value="bD|\-[1-9][0-9]*"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_rgbTuple" final="restriction"> <xs:restriction base="xs:string"> <xs:pattern value="#[0-9|A-F|a-f]{6}"/> <xs:length value="7"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmBorderPosition"> <xs:restriction base="xs:string"> <xs:enumeration value="None"/> <xs:enumeration value="Left"/> <xs:enumeration value="Right"/> <xs:enumeration value="Top"/> <xs:enumeration value="Bottom"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmChartCategory"> <xs:restriction base="xs:string"> <xs:enumeration value="Unsupported"/> <xs:enumeration value="Combo"/> <xs:enumeration value="Surface"/> <xs:enumeration value="Column"/> <xs:enumeration value="Column3D"/> <xs:enumeration value="Bar"/> <xs:enumeration value="Bar3D"/> <xs:enumeration value="Line"/> <xs:enumeration value="Line3D"/> <xs:enumeration value="Pie"/> <xs:enumeration value="Scatter"/> <xs:enumeration value="Bubble"/> <xs:enumeration value="Area"/> <xs:enumeration value="Doughnut"/> <xs:enumeration value="Radar"/> <xs:enumeration value="Stock"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmBorderLineStyle"> <xs:restriction base="xs:string"> <xs:enumeration value="None"/> <xs:enumeration value="Continuous"/> <xs:enumeration value="Dash"/> <xs:enumeration value="Dot"/> <xs:enumeration value="DashDot"/> <xs:enumeration value="DashDotDot"/> <xs:enumeration value="SlantDashDot"/> <xs:enumeration value="Double"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmHorizontalAlignment"> <xs:restriction base="xs:string"> <xs:enumeration value="Automatic"/> <xs:enumeration value="Center"/> <xs:enumeration value="Left"/> <xs:enumeration value="Right"/> <xs:enumeration value="Fill"/> <xs:enumeration value="Justify"/> <xs:enumeration value="CenterAcrossSelection"/> <xs:enumeration value="Distributed"/> <xs:enumeration value="JustifyDistributed"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmVerticalAlignment"> <xs:restriction base="xs:string"> <xs:enumeration value="Automatic"/> <xs:enumeration value="Top"/> <xs:enumeration value="Bottom"/> <xs:enumeration value="Center"/> <xs:enumeration value="Justify"/> <xs:enumeration value="Distributed"/> <xs:enumeration value="JustifyDistributed"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmAutoFilterCriteriaOperationType"> <xs:restriction base="xs:string"> <xs:enumeration value="EQ"/> <xs:enumeration value="NEQ"/> <xs:enumeration value="GT"/> <xs:enumeration value="GTEQ"/> <xs:enumeration value="LT"/> <xs:enumeration value="LTEQ"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmAutoFilterCriteriaRelationOperator"> <xs:restriction base="xs:string"> <xs:enumeration value="Nil"/> <xs:enumeration value="And"/> <xs:enumeration value="Or"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmAutoFilterItemType"> <xs:restriction base="xs:string"> <xs:enumeration value="Number"/> <xs:enumeration value="Text"/> <xs:enumeration value="Date"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmAutoFilterItemCriteriaType"> <xs:restriction base="xs:string"> <xs:enumeration value="Nil"/> <xs:enumeration value="AboveAverage"/> <xs:enumeration value="BelowAverage"/> <xs:enumeration value="Tomorrow"/> <xs:enumeration value="Today"/> <xs:enumeration value="Yesterday"/> <xs:enumeration value="NextWeek"/> <xs:enumeration value="ThisWeek"/> <xs:enumeration value="LastWeek"/> <xs:enumeration value="NextMonth"/> <xs:enumeration value="ThisMonth"/> <xs:enumeration value="LastMonth"/> <xs:enumeration value="NextQuarter"/> <xs:enumeration value="ThisQuarter"/> <xs:enumeration value="LastQuarter"/> <xs:enumeration value="NextYear"/> <xs:enumeration value="ThisYear"/> <xs:enumeration value="LastYear"/> <xs:enumeration value="YearToDate"/> <xs:enumeration value="Q1"/> <xs:enumeration value="Q2"/> <xs:enumeration value="Q3"/> <xs:enumeration value="Q4"/> <xs:enumeration value="M1"/> <xs:enumeration value="M2"/> <xs:enumeration value="M3"/> <xs:enumeration value="M4"/> <xs:enumeration value="M5"/> <xs:enumeration value="M6"/> <xs:enumeration value="M7"/> <xs:enumeration value="M8"/> <xs:enumeration value="M9"/> <xs:enumeration value="M10"/> <xs:enumeration value="M11"/> <xs:enumeration value="M12"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_excelRowNumber"> <xs:restriction base="xs:int"> <xs:minInclusive value="0"/> <xs:maxInclusive value="1048575"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_excelColNumber"> <xs:restriction base="xs:int"> <xs:minInclusive value="0"/> <xs:maxInclusive value="16383"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_excelRowNumber1Based"> <xs:restriction base="xs:int"> <xs:minInclusive value="1"/> <xs:maxInclusive value="1048576"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_excelColNumber1Based"> <xs:restriction base="xs:int"> <xs:minInclusive value="1"/> <xs:maxInclusive value="16384"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_excelOutlineLevels"> <xs:restriction base="xs:short"> <xs:minInclusive value="0"/> <xs:maxInclusive value="8"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_rowHeight"> <xs:restriction base="xs:double"> <xs:minInclusive value="0.2"/> <xs:maxInclusive value="409.6"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_columnWidth"> <xs:restriction base="xs:double"> <xs:minInclusive value="0.75"/> <xs:maxInclusive value="1343"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmFilterItemType"> <xs:restriction base="xs:string"> <xs:enumeration value="None"/> <xs:enumeration value="Filtered"/> <xs:enumeration value="SortedAsc"/> <xs:enumeration value="SortedDesc"/> <xs:enumeration value="BothAsc"/> <xs:enumeration value="BothDesc"/> <xs:enumeration value="Sorted"/> <xs:enumeration value="Both"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_Data"> <xs:simpleContent> <xs:extension base="xs:string"> <xs:attribute name="RTF" type="xs:boolean" default="false" use="optional"/> </xs:extension> </xs:simpleContent> </xs:complexType> <xs:simpleType name="ST_KpiSet"> <xs:restriction base="xs:short"> <xs:enumeration value="-1"/> <xs:enumeration value="0"/> <xs:enumeration value="1"/> <xs:enumeration value="2"/> <xs:enumeration value="3"/> <xs:enumeration value="4"/> <xs:enumeration value="5"/> <xs:enumeration value="6"/> <xs:enumeration value="7"/> <xs:enumeration value="8"/> <xs:enumeration value="9"/> <xs:enumeration value="10"/> <xs:enumeration value="11"/> <xs:enumeration value="12"/> <xs:enumeration value="13"/> <xs:enumeration value="14"/> <xs:enumeration value="15"/> <xs:enumeration value="16"/> <xs:enumeration value="17"/> <xs:enumeration value="18"/> <xs:enumeration value="19"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_KpiIcon"> <xs:restriction base="xs:short"> <xs:minInclusive value="0"/> <xs:maxInclusive value="4"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_KpiSize"> <xs:restriction base="xs:short"> <xs:enumeration value="0"/> <xs:enumeration value="1"/> <xs:enumeration value="2"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_MergeDown"> <xs:restriction base="xs:int"> <xs:minInclusive value="1"/> <xs:maxInclusive value="1048575"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_MergeAcross"> <xs:restriction base="xs:int"> <xs:minInclusive value="1"/> <xs:maxInclusive value="16383"/> </xs:restriction> </xs:simpleType> <xs:complexType name="CT_Cell"> <xs:sequence> <xs:element name="Data" minOccurs="0" maxOccurs="1" type="CT_Data"/> </xs:sequence> <xs:attribute name="BorderID" type="ST_borderStyleID" default="bD" use="optional"/> <xs:attribute name="Index" type="ST_excelColNumber1Based" use="optional"/> <xs:attribute name="StyleID" type="ST_cellStyleID" default="sD" use="optional"/> <xs:attribute name="SpanType" type="ST_enmCellSpanType" use="optional" default="None"/> <xs:attribute name="SpillOrigin" type="ST_excelColNumber1Based" use="optional"/> <xs:attribute name="DatabarLength" type="ST_databarLengthPercentage" default="0" use="optional"/> <xs:attribute name="DatabarColor" type="ST_rgbTuple" use="optional"/> <xs:attribute name="DatabarStyle" type="ST_enmDatabarStyle" use="optional" default="Gradient"/> <xs:attribute name="DatabarBorderColor" type="ST_rgbTuple" use="optional"/> <xs:attribute name="DatabarDirection" type="ST_enmReadOrder" use="optional" default="Context"/> <xs:attribute name="DatabarAxisPosition" type="ST_databarLengthPercentage" default="0" use="optional"/> <xs:attribute name="DatabarAxisColor" type="ST_rgbTuple" use="optional"/> <xs:attribute name="HasDropDown" type="xs:boolean" use="optional"/> <xs:attribute name="KpiSet" use="optional" default="-1" type="ST_KpiSet"/> <xs:attribute name="KpiIcon" use="optional" type="ST_KpiIcon"/> <xs:attribute name="KpiSize" use="optional" type="ST_KpiSize"/> <xs:attribute name="MergeDown" use="optional" type="ST_MergeDown"/> <xs:attribute name="MergeAcross" use="optional" type="ST_MergeAcross"/> <xs:attribute name="FirstRow" type="ST_excelRowNumber" use="optional" default="0"/> <xs:attribute name="FirstColumn" type="ST_excelColNumber" use="optional" default="0"/> <xs:attribute name="LastRow" type="ST_excelRowNumber" use="optional" default="0"/> <xs:attribute name="LastColumn" type="ST_excelColNumber" use="optional" default="0"/> <xs:attribute name="XOriginDelta" type="ST_nonPositiveDouble" default="0" use="optional"/> <xs:attribute name="YOriginDelta" type="ST_nonPositiveDouble" default="0" use="optional"/> <xs:attribute name="Width" type="ST_nonNegativeDouble" default="0" use="optional"/> <xs:attribute name="Height" type="ST_nonNegativeDouble" default="0" use="optional"/> <xs:attribute name="OriginalText" use="optional" type="xs:string"/> <xs:attribute name="DropDownType" type="ST_enmFilterItemType" use="optional" default="None"/> <xs:attribute name="IsPivotPageField" type="xs:boolean" use="optional"/> <xs:attribute name="PageFieldID" type="xs:string" use="optional"/> <xs:attribute name="Drillable" type="xs:boolean" use="optional"/> <xs:attribute name="HasDrillIndicator" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="CompactAxis" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="ExtraIndentSpace" type="xs:boolean" use="optional"/> <xs:attribute name="WideIndent" type="xs:boolean" use="optional"/> <xs:attribute name="Expanded" type="xs:boolean" use="optional"/> <xs:attribute name="Horizontal" type="ST_enmHorizontalAlignment" default="Automatic" use="optional"/> <xs:attribute name="iconOnly" type="xs:boolean" use="optional"/> <xs:attribute name="FormulaError" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="HasPhonInfo" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="FormulaBarText" type="xs:string" use="optional"/> <xs:attribute name="HasSparkline" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="SparklineClusterOffsetTop" type="xs:nonNegativeInteger" default="0" use="optional"/> <xs:attribute name="SparklineClusterOffsetLeft" type="xs:nonNegativeInteger" use="optional" default="0"/> <xs:attribute name="SparklineClusterFirstRow" type="ST_excelRowNumber" use="optional"/> <xs:attribute name="SparklineClusterLastRow" type="ST_excelRowNumber" use="optional"/> <xs:attribute name="SparklineClusterFirstColumn" type="ST_excelColNumber" use="optional"/> <xs:attribute name="SparklineClusterLastColumn" type="ST_excelColNumber" use="optional"/> <xs:attribute name="SparklineVersion" type="xs:int" use="optional" default="0"/> </xs:complexType> <xs:complexType name="CT_RowAxisItem"> <xs:sequence> <xs:element name="Cell" minOccurs="0" maxOccurs="16384" type="CT_Cell"/> </xs:sequence> <xs:attribute name="Span" use="optional" default="0" type="ST_excelRowNumber"/> <xs:attribute name="Hidden" type="xs:boolean" use="optional" default="false"/> <xs:attribute name="collapsed" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="outlineLevel" type="ST_excelOutlineLevels" use="optional" default="0"/> <xs:attribute name="adjacentOutlineLevel" type="ST_excelOutlineLevels" use="optional" default="0"/> <xs:attribute name="Index" type="ST_excelRowNumber1Based" use="optional"/> <xs:attribute name="Height" type="ST_rowHeight" use="optional"/> </xs:complexType> <xs:complexType name="CT_ColumnAxisItem"> <xs:attribute name="Span" use="optional" default="0" type="ST_excelColNumber"/> <xs:attribute name="Hidden" type="xs:boolean" use="optional" default="false"/> <xs:attribute name="collapsed" type="xs:boolean" default="false" use="optional"/> <xs:attribute name="outlineLevel" type="ST_excelOutlineLevels" use="optional" default="0"/> <xs:attribute name="adjacentOutlineLevel" type="ST_excelOutlineLevels" use="optional" default="0"/> <xs:attribute name="Index" type="ST_excelColNumber1Based" use="optional"/> <xs:attribute name="Width" type="ST_columnWidth" use="optional"/> </xs:complexType> <xs:simpleType name="ST_enmImageType"> <xs:restriction base="xs:string"> <xs:enumeration value="none"/> <xs:enumeration value="chart"/> <xs:enumeration value="image"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmReadOrder"> <xs:restriction base="xs:string"> <xs:enumeration value="Context"/> <xs:enumeration value="LeftToRight"/> <xs:enumeration value="RightToLeft"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmGradientType"> <xs:restriction base="xs:string"> <xs:enumeration value="Linear"/> <xs:enumeration value="Path"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmFontVerticalAlignment"> <xs:restriction base="xs:string"> <xs:enumeration value="None"/> <xs:enumeration value="Subscript"/> <xs:enumeration value="Superscript"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmPivotRangeOperation"> <xs:restriction base="xs:string"> <xs:enumeration value="Refresh"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmFontUnderline"> <xs:restriction base="xs:string"> <xs:enumeration value="None"/> <xs:enumeration value="Single"/> <xs:enumeration value="Double"/> <xs:enumeration value="SingleAccounting"/> <xs:enumeration value="DoubleAccounting"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmNamedObjectType"> <xs:restriction base="xs:string"> <xs:enumeration value="InvalidNamedObjectType"/> <xs:enumeration value="Chart"/> <xs:enumeration value="PivotTable"/> <xs:enumeration value="Table"/> <xs:enumeration value="NamedRange"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmDatabarStyle"> <xs:restriction base="xs:string"> <xs:enumeration value="Gradient"/> <xs:enumeration value="Solid"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmCellSpanType"> <xs:restriction base="xs:string"> <xs:enumeration value="Merge"/> <xs:enumeration value="Spill"/> <xs:enumeration value="None"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_enmPattern"> <xs:restriction base="xs:string"> <xs:enumeration value="None"/> <xs:enumeration value="Solid"/> <xs:enumeration value="Gray50"/> <xs:enumeration value="Gray75"/> <xs:enumeration value="Gray25"/> <xs:enumeration value="HorzStripe"/> <xs:enumeration value="VertStripe"/> <xs:enumeration value="ReverseDiagStripe"/> <xs:enumeration value="DiagStripe"/> <xs:enumeration value="DiagCross"/> <xs:enumeration value="ThickDiagCross"/> <xs:enumeration value="ThinHorzStripe"/> <xs:enumeration value="ThinVertStripe"/> <xs:enumeration value="ThinReverseDiagStripe"/> <xs:enumeration value="ThinDiagStripe"/> <xs:enumeration value="ThinHorzCross"/> <xs:enumeration value="ThinDiagCross"/> <xs:enumeration value="Gray125"/> <xs:enumeration value="Gray0625"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_percentage"> <xs:restriction base="xs:double"> <xs:minInclusive value="0.0"/> <xs:maxInclusive value="1.0"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_databarLengthPercentage"> <xs:restriction base="xs:int"> <xs:minInclusive value="-100"/> <xs:maxInclusive value="100"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_nonNegativeDouble"> <xs:restriction base="xs:double"> <xs:minInclusive value="0"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_nonPositiveDouble"> <xs:restriction base="xs:double"> <xs:maxInclusive value="0"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="ST_nonEmptyString"> <xs:restriction base="xs:string"> <xs:minLength value="1"/> </xs:restriction> </xs:simpleType> </xs:schema>