PicoXLSX Library Documentation
 | Worksheet Properties |
The Worksheet type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | AutoFilterRange |
Gets the range of the auto-filter. Wrapped to Nullable to provide null as value. If null, no auto-filter is applied
|
| Cells |
Gets the cells of the worksheet as dictionary with the cell address as key and the cell object as value
|
| Columns |
Gets all columns with non-standard properties, like auto filter applied or a special width as dictionary with the zero-based column index as key and the column object as value
|
| CurrentCellDirection |
Gets or sets the direction when using AddNextCell method
|
| DefaultColumnWidth |
Gets or sets the default column width
|
| DefaultRowHeight |
Gets or sets the default Row height
|
| HiddenRows |
Gets the hidden rows as dictionary with the zero-based row number as key and a boolean as value. True indicates hidden, false visible.
|
| MergedCells |
Gets the merged cells (only references) as dictionary with the cell address as key and the range object as value
|
| RowHeights |
Gets defined row heights as dictionary with the zero-based row number as key and the height (float from 0 to 409.5) as value
|
| SelectedCells |
Gets the cell range of selected cells of this worksheet. Null if no cells are selected
|
| SheetID |
Gets or sets the internal ID of the sheet
|
| SheetName |
Gets or sets the name of the worksheet
|
| SheetProtectionPassword |
Gets the password used for sheet protection
|
| SheetProtectionValues |
Gets the list of SheetProtectionValues. These values define the allowed actions if the worksheet is protected
|
| UseSheetProtection |
Gets or sets whether the worksheet is protected. If true, protection is enabled
|
| WorkbookReference |
Gets or sets the Reference to the parent Workbook
|
See Also