Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: TableType
Namespace: urn:schemas-microsoft-com:office:spreadsheet
Containing Schema: excelss.xsd
Abstract
Documentation:
Defines the table to contain the cells that constitute a worksheet.
Collapse XSD Schema Diagram:
Drilldown into Row in schema excelss_xsd Drilldown into Column in schema excelss_xsd Drilldown into DefaultColumnWidth in schema excel_xsd Drilldown into DefaultRowHeight in schema excel_xsd Drilldown into FullRows in schema excel_xsd Drilldown into FullColumns in schema excel_xsd Drilldown into XTableElements in schema excel_xsd Drilldown into FullRows in schema excelss_xsd Drilldown into FullColumns in schema excelss_xsd Drilldown into TopCell in schema excelss_xsd Drilldown into LeftCell in schema excelss_xsd Drilldown into StyleID in schema excelss_xsd Drilldown into ExpandedRowCount in schema excelss_xsd Drilldown into ExpandedColumnCount in schema excelss_xsd Drilldown into DefaultRowHeight in schema excelss_xsd Drilldown into DefaultColumnWidth in schema excelss_xsdXSD Diagram of TableType in schema excelss_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<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>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Column ss:Column 0 unbounded
Row ss:Row 0 unbounded
Collapse Child Attributes:
Name Type Default Value Use
ExpandedColumnCount ss:ExpandedColumnCount Optional
ExpandedRowCount ss:ExpandedRowCount Optional
StyleID ss:StyleID Optional
LeftCell ss:LeftCell 1 Optional
TopCell ss:TopCell 1 Optional
FullColumns x:FullColumns 0 Optional
FullRows x:FullRows 0 Optional
DefaultRowHeight x:DefaultRowHeight 255 Optional
DefaultColumnWidth x:DefaultColumnWidth 8 Optional
Collapse Derivation Tree:
Collapse References:
ss:Table
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0