Column element

Defines the formatting and properties for one or more adjacent columns.

Usage

      
<Column
	AutoFitWidth="TrueFalseType"
	Index="xsd:positiveInteger"
	Span="xsd:nonNegativeInteger"
	StyleID="xsd:IDREF"
	Width="xsd:double"
	Hidden="See attribute definition.	c:Caption="[external type]"
/>

    

Element Information

Element type Anonymous
Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Parent Elements

Element Description
Table Defines the table to contain the cells of the current worksheet. Only one instance of a Table element is valid for a single worksheet.

Child Elements

None.

Attributes

Attribute Type Required Description Possible Values
AutoFitWidth TrueFalseType optional Specifies whether a column is automatically resized to fit numeric and date values. Columns are not resized to fit text data.
  • 0
  • 1
Index xsd:positiveInteger optional Specifies the position of a column in a table. See external namespace.
Span xsd:nonNegativeInteger optional Specifies the number of adjacent columns with the same formatting as the defined column. See external namespace.
StyleID xsd:IDREF optional Contains a reference to an ID attribute previously defined in a Style element. Used to apply that defined style to a column. See external namespace.
Width Anonymous optional Specifies the width of a column in points. This value must be greater than or equal to zero.

minInclusive = 0

Hidden None optional Specifies whether an element is visible. The Hidden attribute can be applied to the NamedRange, Column, and Row elements. n/a
c:Caption external ref optional See external namespace. See external namespace.

Definition

      
<xsd:element name="Column" minOccurs="0" maxOccurs="unbounded" >
  <xsd:complexType>
    <xsd:attribute form="qualified" name="AutoFitWidth" type="TrueFalseType" use="optional" default="1">
    </xsd:attribute>
    <xsd:attribute ref="Hidden" default="0">
    </xsd:attribute>
    <xsd:attribute form="qualified" name="Index" type="xsd:positiveInteger" use="optional">
    </xsd:attribute>
    <xsd:attribute form="qualified" name="Span" type="xsd:nonNegativeInteger" use="optional" default="0">
    </xsd:attribute>
    <xsd:attribute form="qualified" name="StyleID" type="xsd:IDREF" use="optional">
    </xsd:attribute>
    <xsd:attribute form="qualified" name="Width" use="optional">
      <xsd:simpleType>
        <xsd:restriction base="xsd:double">
          <xsd:minInclusive value="0" />
        </xsd:restriction>
      </xsd:simpleType>
    </xsd:attribute>
    <xsd:attribute ref="c:Caption" use="optional" />
  </xsd:complexType>
</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