ColumnInfo element

Contains information about a column.

Usage

      
<ColumnInfo
	Href="xsd:string"
/>

    

Element Information

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

Elements and Attributes

Parent Elements

Element Description
RefreshInfo Contains refresh information for the query.
RefreshInfo Contains information to be used when data is refreshed.

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:element name="ColumnInfo" type="ColumnInfoType" minOccurs="0" maxOccurs="unbounded" >
</xsd:element>


    
©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