2.2.4.97 ExcelServicesData

  • Article

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

Describes an Excel Services ([MS-ESP]) data connection used by Excel Services data sources and Excel Services reports.

 <xs:complexType name="ExcelServicesData" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:sequence>
     <xs:element minOccurs="0" maxOccurs="1" name="WorkbookParameters" type="tns:PropertyBag"/>
   </xs:sequence>
   <xs:attribute name="SharePointSite" type="xs:string"/>
   <xs:attribute name="DocumentLibrary" type="xs:string"/>
   <xs:attribute name="DocumentLibraryRootFolder" type="xs:string"/>
   <xs:attribute name="DocumentLibraryDisplay" type="xs:string"/>
   <xs:attribute name="FolderFileName" type="xs:string"/>
   <xs:attribute name="FileName" type="xs:string"/>
   <xs:attribute name="ItemName" type="xs:string"/>
   <xs:attribute name="ViewOptions" type="tns:ExcelServicesViewOptions" use="required"/>
   <xs:attribute name="ToolbarType" type="tns:ExcelServicesToolbarType" use="required"/>
   <xs:attribute name="ToolbarOptions" type="tns:ExcelServicesToolbarOptions" use="required"/>
 </xs:complexType>

WorkbookParameters: Specifies the PropertyBag (section 2.2.4.158) containing the parameters that are passed to the workbook when opening the data source. This element MUST be present.

SharePointSite: Specifies the URL of the site (2) containing an Excel Services data source. This attribute MUST be present. SharePointSite MUST only be used for Excel Services reports.

DocumentLibrary: Specifies the GUID of the document library that contains the data source. This attribute MUST be present.

DocumentLibraryRootFolder: Specifies the root folder of the document library. This attribute MUST be present.

DocumentLibraryDisplay: Specifies the display name of the document library. This attribute MUST be present.

FolderFileName: Specifies the path and file name of the Excel Services workbook. This attribute MUST be present. FolderFileName MUST only be used for Excel Services reports.

FileName: Specifies the file name of the Excel Services workbook. This attribute MUST be present. FileName MUST only be used for Excel Services reports.

ItemName: Specifies the name of the published item in the Excel Service workbook used as the data source. This attribute MUST be present.

ViewOptions: Specifies the combination of one or more ExcelServicesViewOptions (section 2.2.5.17) that control how the user is allowed to interact with the Excel Services report. This attribute MUST be present.

ToolbarType: Specifies the ExcelServicesToolbarType (section 2.2.5.16) that controls which toolbar is shown in the Excel Services report. This attribute MUST be present.

ToolbarOptions: Specifies the combination of one or more ExcelServicesToolbarOptions (section 2.2.5.15) for the toolbar displayed on the report. This attribute MUST be present.