complexType WorksheetType

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

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="WorksheetType">
    <
xsd:annotation>
        <
xsd:documentation>Defines a worksheet within the current workbook. An document must contain at least one instance of this element to be a valid XML Spreadsheet document.</xsd:documentation>
    </
xsd:annotation>
    <
xsd:sequence>
        <
xsd:element name="Names" type="NamesType" minOccurs="0">
            <
xsd:annotation>
                <
xsd:documentation>Defines a collection of named ranges within a workbook or worksheet.</xsd:documentation>
            </
xsd:annotation>
        </
xsd:element>
        <
xsd:element name="Table" type="TableType" minOccurs="0">
            <
xsd:annotation>
                <
xsd:documentation>Defines the table to contain the cells of the current worksheet. Only one instance of a Table element is valid for a single worksheet.</xsd:documentation>
            </
xsd:annotation>
        </
xsd:element>
        <
xsd:element ref="x:WorksheetOptions" minOccurs="0"/>
        <
xsd:element ref="x:Watches" minOccurs="0"/>
        <
xsd:element ref="x:DataTable" minOccurs="0"/>
        <
xsd:element ref="x:PageBreaks" minOccurs="0"/>
        <
xsd:element ref="x:PivotTable" minOccurs="0" maxOccurs="unbounded"/>
        <
xsd:element ref="x:DataValidation" minOccurs="0" maxOccurs="unbounded"/>
        <
xsd:element ref="x:AutoFilter" minOccurs="0"/>
        <
xsd:element ref="x:ConditionalFormatting" minOccurs="0" maxOccurs="unbounded"/>
        <
xsd:element ref="x:Sorting" minOccurs="0"/>
        <
xsd:element ref="c:worksheetoptions" minOccurs="0"/>
        <
xsd:element ref="x:QueryTable" minOccurs="0" maxOccurs="unbounded"/>
    </
xsd:sequence>
    <
xsd:attribute form="qualified" name="Name" type="xsd:string" use="required">
        <
xsd:annotation>
            <
xsd:documentation>Specifies the name of a worksheet. This value must be unique within the list of worksheet names of a given workbook.</xsd:documentation>
        </
xsd:annotation>
    </
xsd:attribute>
    <
xsd:attribute form="qualified" name="Protected" type="TrueFalseType" use="optional" default="0">
        <
xsd:annotation>
            <
xsd:documentation>Specifies whether a worksheet is protected. When protection is not enabled for a worksheet, protection settings for individual cells have no effect.</xsd:documentation>
        </
xsd:annotation>
    </
xsd:attribute>
    <
xsd:attribute form="qualified" name="RightToLeft" type="TrueFalseType" use="optional"
        
default="0">
        <
xsd:annotation>
            <
xsd:documentation>Specifies whether the worksheet window displays information from left to right or from right to left. If this attribute is set to display from right to left, column A in a worksheet is the first column on the right.</xsd:documentation>
        </
xsd:annotation>
    </
xsd:attribute>
</
xsd:complexType>


Documentation

Defines a worksheet within the current workbook. An document must contain at least one instance of this element to be a valid XML Spreadsheet document.


complexType WorksheetType


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.