Share via

2.2.4.24 SpreadsheetDataXML

  • Article

SpreadsheetDataXML specifies information about a workbook.

 <s:complexType name="SpreadsheetDataXML">
   <s:sequence>
     <s:element name="Workbook" type="Workbook">
       <s:key name="styleIDKey">
         <s:selector xpath="./Styles/Style"/>
         <s:field xpath="@ID"/>
       </s:key>
       <s:keyref name="tableStyleIDKeyRef" refer="styleIDKey">
         <s:selector xpath="./Worksheet/Table"/>
         <s:field xpath="@StyleID"/>
       </s:keyref>
       <s:keyref name="columnStyleIDKeyRef" refer="styleIDKey">
         <s:selector xpath="./Worksheet/Table/Column"/>
         <s:field xpath="@StyleID"/>
       </s:keyref>
       <s:keyref name="columnBorderStyleIDKeyRef" refer="styleIDKey">
         <s:selector xpath="./Worksheet/Table/Column"/>
         <s:field xpath="@BorderID"/>
       </s:keyref>
       <s:keyref name="rowStyleIDKeyRef" refer="styleIDKey">
         <s:selector xpath="./Worksheet/Table/Row"/>
         <s:field xpath="@StyleID"/>
       </s:keyref>
       <s:keyref name="rowBorderStyleIDKeyRef" refer="styleIDKey">
         <s:selector xpath="./Worksheet/Table/Row"/>
         <s:field xpath="@BorderID"/>
       </s:keyref>
       <s:keyref name="cellStyleIDKeyRef" refer="styleIDKey">
         <s:selector xpath="./Worksheet/Table/Row/Cell"/>
         <s:field xpath="@StyleID"/>
       </s:keyref>
       <s:keyref name="cellBorderStyleIDKeyRef" refer="styleIDKey">
         <s:selector xpath="./Worksheet/Table/Row/Cell"/>
         <s:field xpath="@BorderID"/>
       </s:keyref>
       <s:keyref name="imagesBorderStyleIDKeyRef" refer="styleIDKey">
         <s:selector xpath="./Worksheet/Images/Image"/>
         <s:field xpath="@BorderID"/>
       </s:keyref>
     </s:element>
   </s:sequence>
 </s:complexType>

Workbook: This node contains information about a workbook based on the range requested by the protocol client as specified in the SpreadsheetData element of CommandResult (section 2.2.4.12).