Worksheet Properties

The Worksheet type exposes the following members.

Properties

	Name	Description
	ActivePane	Gets the active Pane is splitting is applied. The value is nullable. If null, no splitting was defined
	ActiveStyle	Gets the active Style of the worksheet. If null, no style is defined as active
	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
	FreezeSplitPanes	Gets the FreezeSplitPanes Gets whether split panes are frozen. The value is nullable. If null, no freezing is applied. This property also does not apply if PaneSplitAddress is null
	Hidden	Gets or sets whether the worksheet is hidden. If true, the worksheet is not listed as tab in the workbook's worksheet selection If the worksheet is not part of a workbook, or the only one in the workbook, an exception will be thrown. If the worksheet is the selected one, and attempted to set hidden, an exception will be thrown. Define another selected worksheet prior to this call, in this case.
	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
	PaneSplitAddress	Gets the split address for frozen panes or if pane split was defined in number of columns and / or rows. For vertical splits, only the column component is considered. For horizontal splits, only the row component is considered. The value is nullable. If null, no frozen panes or split by columns / rows are applied to the worksheet. However, splitting can still be applied, if the value is defined in characters. See also: PaneSplitLeftWidth and PaneSplitTopHeight for splitting in characters (without freezing)
	PaneSplitLeftWidth	Gets the width of the left, vertical split pane, measured from the left of the window. The value is nullable. If null, no vertical split of the worksheet is applied The value is only applicable to split the worksheet into panes, but not to freeze them. See also: PaneSplitAddress
	PaneSplitTopHeight	Gets the height of the upper, horizontal split pane, measured from the top of the window. The value is nullable. If null, no horizontal split of the worksheet is applied. The value is only applicable to split the worksheet into panes, but not to freeze them. See also: PaneSplitAddress
	PaneSplitTopLeftCell	Gets the Top Left cell address of the bottom right pane if applicable and splitting is applied. The column is only relevant for vertical split, whereas the row component is only relevant for a horizontal split. The value is nullable. If null, no splitting was defined.
	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
	SelectedCellRanges	Gets all ranges of selected cells of this worksheet. An empty list is returned if no cells are selected
	SelectedCells	Obsolete. Returns either null (if no cells are selected), or the first defined range of selected cells
	SheetID	Gets or sets the internal ID of the worksheet
	SheetName	Gets or sets the name of the worksheet
	SheetProtectionPassword	Gets the password used for sheet protection. See SetSheetProtectionPassword(String) to set the password
	SheetProtectionPasswordHash	gets the encrypted hash of the password, defined with SheetProtectionPassword. The value will be null, if no password is defined
	SheetProtectionValues	Gets the list of SheetProtectionValues. These values define the allowed actions if the worksheet is protected
	ShowGridLines	Gets or sets whether grid lines are visible on the current worksheet. Default is true
	ShowRowColumnHeaders	Gets or sets whether the column and row headers are visible on the current worksheet. Default is true
	ShowRuler	Gets or sets whether a ruler is displayed over the column headers. This value only applies if ViewType is set to pageLayout. Default is true
	UseSheetProtection	Gets or sets whether the worksheet is protected. If true, protection is enabled
	ViewType	Gets or sets how the current worksheet is displayed in the spreadsheet application (Excel)
	WorkbookReference	Gets or sets the Reference to the parent Workbook
	ZoomFactor	Gets or sets the zoom factor of the ViewType of the current worksheet. If AUTO_ZOOM_FACTOR, the zoom factor is set to automatic
	ZoomFactors	Gets all defined zoom factors per WorksheetSheetViewType of the current worksheet. Use SetZoomFactor(WorksheetSheetViewType, Int32) to define the values

Top

See Also