Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: ColumnInfoType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information about a column.
Collapse XSD Schema Diagram:
Drilldown into User in schema excel_xsd Drilldown into SortKey in schema excel_xsd Drilldown into RowNumbers in schema excel_xsd Drilldown into Name in schema excel_xsd Drilldown into FillDown in schema excel_xsd Drilldown into Descending in schema excel_xsd Drilldown into Clipped in schema excel_xsd Drilldown into Id in schema excel_xsdXSD Diagram of ColumnInfoType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="ColumnInfoType">
    <xsd:annotation>
        <xsd:documentation>Contains information about a column.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Id" type="xsd:long">
            <xsd:annotation>
                <xsd:documentation>Contains a unique identifier assigned to a column or, when the page is saved as a Web page, to a cell range.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Clipped" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether there are enough columns to import all fields and columns returned by a query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Descending" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the direction of the sort.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="FillDown" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether formulas to the right of a query table that use values in this column are copied when the data is refreshed and new rows of data are added to a query table.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Name">
            <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:complexType>
                <xsd:simpleContent>
                    <xsd:extension base="xsd:string">
                        <xsd:attribute name="Href" type="xsd:string" use="optional">
                            <xsd:annotation>
                                <xsd:documentation>Specifies the location and name of a text file.</xsd:documentation>
                            </xsd:annotation>
                        </xsd:attribute>
                    </xsd:extension>
                </xsd:simpleContent>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="RowNumbers" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether row numbers are included in a database query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SortKey" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the sort order of a column.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:int">
                    <xsd:minInclusive value="0" />
                    <xsd:maxExclusive value="3" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="User" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the column was inserted by the user.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Id x:Id (1) (1)
Clipped x:Clipped 0 (1)
Descending x:Descending 0 (1)
FillDown x:FillDown 0 (1)
Name x:Name (1) (1)
RowNumbers x:RowNumbers 0 (1)
SortKey x:SortKey 0 (1)
User x:User 0 (1)
Collapse Derivation Tree:
Collapse References:
x:ColumnInfo
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0