Contains information about a column.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
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. |
Attribute | Type | Required | Description | Possible Values |
---|---|---|---|---|
Href | xsd:string | optional | Specifies the location and name of a text file. | See external namespace. |
<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>