Worksheet element

Defines a worksheet within the current workbook. At least one instance of this element is required for a valid XML spreadsheet.

Usage

      
<Worksheet
	Name="xsd:string"
	Protected="TrueFalseType"
	RightToLeft="TrueFalseType"
/>

    

Element Information

Element type WorksheetType
Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Parent Elements

Element Description
Workbook Defines a workbook that will contain one or more Worksheet elements.

Child Elements

Element Description
Names Defines a collection of named ranges within a workbook or worksheet.
Table Defines the table to contain the cells of the current worksheet. Only one instance of a Table element is valid for a single worksheet.
x:WorksheetOptions See external namespace.
x:Watches See external namespace.
x:DataTable See external namespace.
x:PageBreaks See external namespace.
x:PivotTable See external namespace.
x:DataValidation See external namespace.
x:AutoFilter See external namespace.
x:ConditionalFormatting See external namespace.
x:Sorting See external namespace.
c:worksheetoptions See external namespace.
x:QueryTable See external namespace.

Attributes

Attribute Type Required Description Possible Values
Name xsd:string required Specifies the name of a worksheet. This value must be unique within the list of worksheet names of a given workbook. See external namespace.
Protected TrueFalseType optional Specifies whether a worksheet is protected. When protection is not enabled for a worksheet, protection settings for individual cells have no effect.
  • 0
  • 1
RightToLeft TrueFalseType optional 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.
  • 0
  • 1

Definition

      
<xsd:element name="Worksheet" type="WorksheetType" minOccurs="0" maxOccurs="unbounded" >
</xsd:element>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp