2.2.4.96 ExcelDataSet

Namespace: http://www.microsoft.com/performancepoint/scorecards

Specifies the Excel workbook ([MS-XLS]) data for an ExcelWorkbook data source.

 <xs:complexType name="ExcelDataSet" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:sequence>
     <xs:element minOccurs="0" maxOccurs="1" name="CompressedDataTable" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="ExcelFileBlob" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="TableMapping" type="tns:DataTableMapping"/>
   </xs:sequence>
   <xs:attribute name="UseFirstRowHeaders" type="xs:boolean" use="required"/>
 </xs:complexType>

CompressedDataTable: An ADO.NET DataTable object (as described in [DataTable]), which contains all of the rows and columns of data in the embedded workbook. The DataTable object MUST be serialized into binary format as specified in [MS-NRBF], then compressed using GZIP compression as specified in [RFC1952], and then encoded with base64 encoding.

ExcelFileBlob: Contains the embedded Excel workbook. This element MUST be present and MUST contain a valid workbook file containing the data for the data source. The file contents MUST be compressed using GZIP compression as specified in [RFC1952] and then MUST be encoded with base64 encoding.

TableMapping: This attribute is deprecated from the protocol and MUST NOT be used.

UseFirstRowHeaders: This attribute MUST be present and MUST be true if the first row in the embedded spreadsheet consists of headers; otherwise, false.