Share via

2.1.1 Workbook

  • Article

Specifies information about a workbook.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

 <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>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).