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.