Search
Worksheet Properties
 


 Public Properties

  Name Description

AutoFilter

Gets an AutoFilter object if autofiltering is enabled; otherwise, null (Nothing in Visual Basic).

AutoFilterMode

Gets or sets a value indicating whether there is an active autofilter in the worksheet.

CellRanges

Gets an object that can be used to access and manipulate rectangular ranges of worksheet cells.

Cells

Gets an object that can be used to access worksheet cells by (column, row) index or by name.

Columns

Gets an object that can be used to insert, delete and modify worksheet columns.

DefaultColumnWidth

Gets or sets the default width of columns.

DefaultRowHeight

Gets or sets the default height of rows.

Drawing

Gets the Drawing object associated with the worksheet.

FrozenColumnCount

Gets or sets the number of frozen columns in the worksheet.

FrozenRowCount

Gets or sets the number of frozen rows in the worksheet.

Locale

Gets the locale of the parent workbook.

MergedCells

Gets a list with the currently merged cells.

Name

Gets or sets the name of the worksheet.

Rows

Gets an object that can be used to insert, delete and modify worksheet rows.

Tag

Gets or sets a custom object associated with the worksheet.

Visible

Gets or sets a value indicating whether this worksheet is visible.

Zoom

Gets or sets the zoom factor of the worksheet when displayed in a view.

 See Also