Worksheet Properties

PicoXLSX

PicoXLSX

Worksheet Properties

The Worksheet type exposes the following members.

Properties
  NameDescription
Public propertyAutoFilterRange
Gets the range of the auto-filter. Wrapped to Nullable to provide null as value. If null, no auto-filter is applied
Public propertyCells
Gets the cells of the worksheet as dictionary with the cell address as key and the cell object as value
Public propertyColumns
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
Public propertyCurrentCellDirection
Gets or sets the direction when using AddNextCell method
Public propertyDefaultColumnWidth
Gets or sets the default column width
Public propertyDefaultRowHeight
Gets or sets the default Row height
Public propertyHiddenRows
Gets the hidden rows as dictionary with the zero-based row number as key and a boolean as value. True indicates hidden, false visible.
Public propertyMergedCells
Gets the merged cells (only references) as dictionary with the cell address as key and the range object as value
Public propertyRowHeights
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
Public propertySelectedCells
Gets the cell range of selected cells of this worksheet. Null if no cells are selected
Public propertySheetID
Gets or sets the internal ID of the sheet
Public propertySheetName
Gets or sets the name of the worksheet
Public propertySheetProtectionPassword
Gets the password used for sheet protection
Public propertySheetProtectionValues
Gets the list of SheetProtectionValues. These values define the allowed actions if the worksheet is protected
Public propertyUseSheetProtection
Gets or sets whether the worksheet is protected. If true, protection is enabled
Public propertyWorkbookReference
Gets or sets the Reference to the parent Workbook
Top
See Also