Definition Type Complex Type
Name ColumnInfoType
Namespace urn:schemas-microsoft-com:office:excel
Abstract False
Documentation Contains information about a column.
XSD Schema excel.xsd
XSD Schema Diagram
XSD Schema Code
<xsd:complexType xmlns:xsd="http://www.w3.org/2001/XMLSchema" 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 minOccurs="0" name="Clipped">
      <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 minOccurs="0" name="Descending">
      <xsd:annotation>
        <xsd:documentation>Specifies the direction of the sort.</xsd:documentation>
      </xsd:annotation>

    </xsd:element>

    <xsd:element minOccurs="0" name="FillDown">
      <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 minOccurs="0" name="RowNumbers">
      <xsd:annotation>
        <xsd:documentation>Specifies whether row numbers are included in a database query.</xsd:documentation>
      </xsd:annotation>

    </xsd:element>

    <xsd:element minOccurs="0" name="SortKey">
      <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 minOccurs="0" name="User">
      <xsd:annotation>
        <xsd:documentation>Specifies whether the column was inserted by the user.</xsd:documentation>
      </xsd:annotation>

    </xsd:element>

  </xsd:sequence>

</xsd:complexType>
Child Elements
Name Type Min Occurs Max Occurs
Derivation Tree
[No Sub Types]
ColumnInfoType
    x:ColumnInfo
References
x:ColumnInfo
Generated using Liquid XML Studio by Liquid Technologies Ltd