ColumnInfoType complexType

Contains information about a column.

Type Information

Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Child Elements

Element Description
Id Contains a unique identifier assigned to a column or, when the page is saved as a Web page, to a cell range.
Clipped Specifies whether there are enough columns to import all fields and columns returned by a query.
Descending Specifies the direction of the sort.
FillDown 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.
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.
RowNumbers Specifies whether row numbers are included in a database query.
SortKey Specifies the sort order of a column.
User Specifies whether the column was inserted by the user.

Attributes

Attribute Type Required Description Possible Values
Href xsd:string optional Specifies the location and name of a text file. See external namespace.

Definition

      
<xsd:complexType name="ColumnInfoType" >
  <xsd:sequence>
    <xsd:element name="Id" type="xsd:long">
    </xsd:element>
    <xsd:element name="Clipped" minOccurs="0">
    </xsd:element>
    <xsd:element name="Descending" minOccurs="0">
    </xsd:element>
    <xsd:element name="FillDown" minOccurs="0">
    </xsd:element>
    <xsd:element name="Name">
      <xsd:complexType>
        <xsd:simpleContent>
          <xsd:extension base="xsd:string">
            <xsd:attribute name="Href" type="xsd:string" use="optional">
            </xsd:attribute>
          </xsd:extension>
        </xsd:simpleContent>
      </xsd:complexType>
    </xsd:element>
    <xsd:element name="RowNumbers" minOccurs="0">
    </xsd:element>
    <xsd:element name="SortKey" minOccurs="0">
      <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:element>
  </xsd:sequence>
</xsd:complexType>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp