Contains the name, properties, and source of a worksheet.
Contained In
Subelements
Name, QueryTable, PageBreaks, PivotTable, PublishObjects, WorksheetOptions, WorksheetSource
Remarks
In a workbook, you can have zero or more PivotTable and QueryTable subelements. When the data comes from a PivotList component, the Name, PivotTable, and WorksheetOptions subelements are required.
When a workbook contains a single worksheet, the Name, WorksheetOptions, and WorksheetSource subelements are required and stored in the workbook HTML file.
When a workbook contains multiple worksheets, only the Name and WorksheetSource subelements are required in the workbook HTML file. The WorksheetOptions element is specified in the corresponding worksheet HTML file as a subelement of the XML element.
See the example in the ExcelWorkbook element topic.