MS Office 2003 complexType TableType

Abstract	false (This can be used in an instance)
Target Namespace	urn:schemas-microsoft-com:office:spreadsheet
Declared Namespaces	xmlns:o=urn:schemas-microsoft-com:office:office xmlns:x2=http://schemas.microsoft.com/office/excel/2003/xml xmlns:html=http://www.w3.org/TR/REC-html40 xmlns:c=urn:schemas-microsoft-com:office:component:spreadsheet xmlns:xsd=http://www.w3.org/2001/XMLSchema xmlns:x=urn:schemas-microsoft-com:office:excel xmlns=urn:schemas-microsoft-com:office:spreadsheet

<xsd:complexType name="TableType">
    <xsd:annotation>
        <xsd:documentation>Defines the table to contain the cells that constitute a worksheet.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <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>
        <xsd:element name="Row" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Defines the formatting and properties for one or more adjacent rows.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:sequence>
                    <xsd:element ref="Cell" minOccurs="0" maxOccurs="unbounded"/>
                </xsd:sequence>
                <xsd:attribute form="qualified" name="AutoFitHeight" type="TrueFalseType"
                    use="optional" default="1">
                    <xsd:annotation>
                        <xsd:documentation>Specifies whether the height of a row is automatically resized to fit the contents of cells.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
                <xsd:attribute form="qualified" name="Height" use="optional">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the height of a row 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="Hidden" default="0">
                    <xsd:annotation>
                        <xsd:documentation>Specifies whether a row 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 row within 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 rows with the same formatting as the defined row.</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 row.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
                <xsd:attribute ref="c:caption" use="optional"/>
            </xsd:complexType>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute form="qualified" name="DefaultColumnWidth" type="PositiveDoubleType"
        use="optional" default="48">
        <xsd:annotation>
            <xsd:documentation>Specifies the default width in points of columns in a table.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute form="qualified" name="DefaultRowHeight" type="PositiveDoubleType" use="optional"
        default="12.75">
        <xsd:annotation>
            <xsd:documentation>Specifies the default height in points of rows in a table.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute form="qualified" name="ExpandedColumnCount" type="xsd:nonNegativeInteger"
        use="optional">
        <xsd:annotation>
            <xsd:documentation>Specifies the total number of columns in a table. If included in an XML document, this attribute must have a value that is equal to the actual number of columns in the table for the document to be valid.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute form="qualified" name="ExpandedRowCount" type="xsd:nonNegativeInteger"
        use="optional">
        <xsd:annotation>
            <xsd:documentation>Specifies the total number of rows in a table. If included in an XML document, this attribute must have a value that is equal to the actual number of rows in the table for the document to be valid.</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 table.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="LeftCell" type="xsd:positiveInteger" use="optional" default="1">
        <xsd:annotation>
            <xsd:documentation>Specifies the index of the column in a spreadsheet that defines the first column of a table. This value must be greater than zero.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="TopCell" type="xsd:integer" use="optional" default="1">
        <xsd:annotation>
            <xsd:documentation>Specifies the index of the row in a spreadsheet that defines the top row of a table. This value must be greater than zero.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="FullColumns" type="TrueFalseType" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Specifies that the columns in this table should occupy the entire height (all rows) of the worksheet.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="FullRows" type="TrueFalseType" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Specifies that the rows in this table should occupy the entire width (all columns) of the worksheet.</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attributeGroup ref="x:XTableElements"/>
</xsd:complexType>

complexType {urn:schemas-microsoft-com:office:spreadsheet}TableType

Source

Documentation