 | Worksheet |
The WorksheetReader type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | AutoFilterRange | Gets the auto filter range. If null, no auto filters were defined |
| Columns | Gets a list of defined Columns |
| CurrentZoomScale | Gets the zoom factor of the current view type |
| Data | Gets the data of the worksheet as Dictionary of cell address-cell object tuples |
| DefaultColumnWidth | Gets the default column width if defined, otherwise null |
| DefaultRowHeight | Gets the default row height if defined, otherwise null |
| MergedCells | Gets a list of merged cells |
| PaneSplitValue | Gets the definition of pane split-related information |
| Rows | Gets a dictionary of internal Row definitions |
| SelectedCells | Gets the selected cells (panes are currently not considered) |
| ShowGridLines | Gets whether grid lines are shown |
| ShowRowColHeaders | Gets whether column and row headers are shown |
| ShowRuler | Gets whether rulers are shown in view type: pageLayout |
| StyleAssignment | Gets the assignment of resolved styles to cell addresses |
| ViewType | Gets the sheet view type of the current worksheet |
| WorksheetProtection | Gets the applicable worksheet protection values |
| WorksheetProtectionHash | Gets the (legacy) password hash of a worksheet if protection values are applied with a password |
| ZoomFactors | Gets all preserved zoom factors of the worksheet |
See Also