Definition Type: Element
Name: Column
Namespace: urn:schemas-microsoft-com:office:spreadsheet
Containing Schema: excelss.xsd
MinOccurs 0
MaxOccurs unbounded
Abstract
Documentation:
Defines the formatting and properties for one or more adjacent columns.
Collapse XSD Schema Diagram:
Drilldown into Caption in schema c_xsd Drilldown into Width in schema excelss_xsd Drilldown into StyleID in schema excelss_xsd Drilldown into Span in schema excelss_xsd Drilldown into Index in schema excelss_xsd Drilldown into Hidden in schema excelss_xsd Drilldown into AutoFitWidth in schema excelss_xsdXSD Diagram of Column in schema excelss_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:element name="Column" minOccurs="0" maxOccurs="unbounded">
    <xsd:annotation>
        <xsd:documentation>Defines the formatting and properties for one or more adjacent columns.</xsd:documentation>
    </xsd:annotation>
    <xsd:complexType>
        <xsd:attribute form="qualified" name="AutoFitWidth" type="TrueFalseType" use="optional" default="1">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a column is automatically resized to fit numeric and date values. Columns are not resized to fit text data.</xsd:documentation>
            </xsd:annotation>
        </xsd:attribute>
        <xsd:attribute ref="Hidden" default="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a column is hidden.</xsd:documentation>
            </xsd:annotation>
        </xsd:attribute>
        <xsd:attribute form="qualified" name="Index" type="xsd:positiveInteger" use="optional">
            <xsd:annotation>
                <xsd:documentation>Specifies the position of a column in a table.</xsd:documentation>
            </xsd:annotation>
        </xsd:attribute>
        <xsd:attribute form="qualified" name="Span" type="xsd:nonNegativeInteger" use="optional" default="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the number of adjacent columns with the same formatting as the defined column.</xsd:documentation>
            </xsd:annotation>
        </xsd:attribute>
        <xsd:attribute form="qualified" name="StyleID" type="xsd:IDREF" use="optional">
            <xsd:annotation>
                <xsd:documentation>Contains a reference to an ID attribute previously defined in a Style element. Used to apply that defined style to a column.</xsd:documentation>
            </xsd:annotation>
        </xsd:attribute>
        <xsd:attribute form="qualified" name="Width" use="optional">
            <xsd:annotation>
                <xsd:documentation>Specifies the width of a column in points. This value must be greater than or equal to zero.</xsd:documentation>
            </xsd:annotation>
            <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>
Collapse Child Attributes:
Name Type Default Value Use
AutoFitWidth ss:AutoFitWidth 1 Optional
Hidden ss:Hidden (Optional)
Index ss:Index Optional
Span ss:Span 0 Optional
StyleID ss:StyleID Optional
Width ss:Width Optional
Caption c:Caption Optional