Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: ConsolidationReferenceType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains the properties of a range data source.
Collapse XSD Schema Diagram:
Drilldown into Reference in schema excel_xsd Drilldown into Name in schema excel_xsd Drilldown into FileName in schema excel_xsdXSD Diagram of ConsolidationReferenceType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="ConsolidationReferenceType">
    <xsd:annotation>
        <xsd:documentation>Contains the properties of a range data source.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="FileName" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the name of the file that contains the source range of a PivotTable report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:choice>
            <xsd:element name="Name" type="xsd:string">
                <xsd:annotation>
                    <xsd:documentation>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.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Reference" type="xsd:string">
                <xsd:annotation>
                    <xsd:documentation>Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
        </xsd:choice>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
FileName x:FileName 0 (1)
Name x:Name (1) (1)
Reference x:Reference (1) (1)
Collapse Derivation Tree:
Collapse References:
x:ConsolidationReference, x:ConsolidationReference
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0