NanoXLSX 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