Contains the properties of a range data source.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
FileName | Contains the name of the file that contains the source range of a PivotTable report. |
Name | Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range. |
Reference | Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element. |
None.
<xsd:complexType name="ConsolidationReferenceType" >
<xsd:sequence>
<xsd:element name="FileName" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:choice>
<xsd:element name="Name" type="xsd:string">
</xsd:element>
<xsd:element name="Reference" type="xsd:string">
</xsd:element>
</xsd:choice>
</xsd:sequence>
</xsd:complexType>