complexType TableType

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

Abstractfalse (This can be used in an instance)
Target Namespaceurn:schemas-microsoft-com:office:spreadsheet
Declared Namespacesxmlns: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


Source

<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>


Documentation

Defines the table to contain the cells that constitute a worksheet.


complexType TableType


Stylus Studio XML Schema Library Home
Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio®, a product from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2006 All Rights Reserved.