ExcelWorksheet Properties
From Office Open XML
The ExcelWorksheet type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | AutoFilterAddress |
Address for autofilter
|
| BackgroundImage |
An image displayed as the background of the worksheet.
|
| Cells |
Provides access to a range of cells
|
| Comments |
Collection of comments
|
| DataValidations |
DataValidation defined in the worksheet. Use the Add methods to create DataValidations and add them to the worksheet. Then
set the properties on the instance returned.
|
| DefaultColWidth |
Get/set the default width of all rows in the worksheet
|
| DefaultRowHeight |
Get/set the default height of all rows in the worksheet
|
| Dimension |
Dimension address for the worksheet.
Top left cell to Bottom right.
If the worksheet has no cells, null is returned
|
| Drawings |
Collection of drawing-objects like shapes, images and charts
|
| HeaderFooter |
A reference to the header and footer class which allows you to
set the header and footer for all odd, even and first pages of the worksheet
|
| Hidden |
Indicates if the worksheet is hidden in the workbook
|
| Index |
The index in the worksheets collection
|
| MergedCells |
Addresses to merged ranges
|
| Name |
The worksheet's display name as it appears on the tab
|
| Names |
Provides access to named ranges
|
| OutLineApplyStyle |
Automatic styles
|
| OutLineSummaryBelow |
Summary rows below details
|
| OutLineSummaryRight |
Summary rows to right of details
|
| PivotTables |
Pivottables defined in the worksheet.
|
| PrinterSettings |
Printer settings
|
| Protection |
Access to sheet protection properties
|
| SelectedRange |
Provides access to the selected range of cells
|
| TabColor |
Color of the sheet tab
|
| Tables |
Tables defined in the worksheet.
|
| View |
Returns a ExcelWorksheetView object that allows you to set the view state properties of the worksheet
|
| Workbook |
The workbook object
|
| WorksheetXml |
The XML document holding the worksheet data.
All column, row, cell, pagebreak, merged cell and hyperlink-data are loaded into memory and removed from the document when loading the document.
|
