Defines the formatting and properties for one or more adjacent columns.
<Column
AutoFitWidth="TrueFalseType"
Index="xsd:positiveInteger"
Span="xsd:nonNegativeInteger"
StyleID="xsd:IDREF"
Width="xsd:double"
Hidden="See attribute definition. c:Caption="[external type]"
/>
Element type | Anonymous |
Namespace | urn:schemas-microsoft-com:office:spreadsheet |
Schema name | XML Spreadsheet 2002 |
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. |
None.
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. |
|
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. |
<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>