Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: WorksheetType
Namespace: urn:schemas-microsoft-com:office:spreadsheet
Containing Schema: excelss.xsd
Abstract
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.
Collapse XSD Schema Diagram:
Drilldown into QueryTable in schema excel_xsd Drilldown into worksheetoptions in schema c_xsd Drilldown into Sorting in schema excel_xsd Drilldown into ConditionalFormatting in schema excel_xsd Drilldown into AutoFilter in schema excel_xsd Drilldown into DataValidation in schema excel_xsd Drilldown into PivotTable in schema excel_xsd Drilldown into PageBreaks in schema excel_xsd Drilldown into DataTable in schema excel_xsd Drilldown into Watches in schema excel_xsd Drilldown into WorksheetOptions in schema excel_xsd Drilldown into Table in schema excelss_xsd Drilldown into Names in schema excelss_xsd Drilldown into RightToLeft in schema excelss_xsd Drilldown into Protected in schema excelss_xsd Drilldown into Name in schema excelss_xsdXSD Diagram of WorksheetType in schema excelss_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<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>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Names ss:Names 0 (1)
Table ss:Table 0 (1)
WorksheetOptions x:WorksheetOptions 0 (1)
Watches x:Watches 0 (1)
DataTable x:DataTable 0 (1)
PageBreaks x:PageBreaks 0 (1)
PivotTable x:PivotTable 0 unbounded
DataValidation x:DataValidation 0 unbounded
AutoFilter x:AutoFilter 0 (1)
ConditionalFormatting x:ConditionalFormatting 0 unbounded
Sorting x:Sorting 0 (1)
worksheetoptions c:worksheetoptions 0 (1)
QueryTable x:QueryTable 0 unbounded
Collapse Child Attributes:
Name Type Default Value Use
Name ss:Name Required
Protected ss:Protected 0 Optional
RightToLeft ss:RightToLeft 0 Optional
Collapse Derivation Tree:
Collapse References:
ss:Worksheet
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0