Contains the properties of a worksheet.
Contained In
Subelements
ActiveCol, ActivePane, ActiveRow, AlternateExpressionEvaluation, AlternateFormulaEntry, ApplyAutomaticOutlineStyles, CodeName, DefaultColumnWidth, DefaultRowHeight, DisplayFormulas, DisplayRightToLeft, DoNotDisplayGridlines, DoNotDisplayHeadings, DoNotDisplayOutline, DoNotDisplayZeros, ExcelWorksheetType, FilterOn, FitToPage, FreezePanes, FrozenNoSplit, GridlineColorIndex, IntlMacro, LeftColumnRightPane, Name, NoSummaryColumnsRightDetail, NoSummaryRowsBelowDetail, PageBreakZoom, Panes, Print, ProtectContents, ProtectObjects, ProtectScenarios, RangeSelection, Selected, ShowPageBreakZoom, SplitHorizontal, SplitVertical, StandardWidth, TopRowBottomPane, TopRowVisible, TransitionExpressionEvaluation, TransitionFormulaEntry, Visible, Zoom
Remarks
For a workbook, all subelements are optional. For the PivotList component, the Panes and Selected subelements are required. When the data comes from a PivotList component, the DefaultRowHeight subelement is also required.
See the example in the ExcelWorkbook element topic.