| Name | Description | |
|---|---|---|
 | AutoFilter | Gets an IAutoFilter object if filtering is on. |
| AutoFilterMode | Gets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet. |
| Cells | Gets an IRange object which represents the entire worksheet cells (not just the cells that are currently in use). |
| CircularReference | Gets an IRange object that represents the range containing the first circular reference on the worksheet, or returns null if there's no circular reference on the worksheet. |
| ColumnCount | Gets or sets the number of columns in this IWorksheet. |
| ColumnFooter | Gets the column footer of a worksheet. |
| ColumnHeader | Gets the column header of a worksheet. |
| Columns | Get an IRange object that represents all the columns on the worksheet. |
| Index | Gets the index number of the worksheet within the collection of worksheets. |
| Name | Gets or sets the name of worksheet. |
| Names | Gets a Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). |
| Outline | Gets an IOutline object that represents the outline for the specified worksheet. |
| ProtectionMode | Gets a value indicates whether user-interface-only protection is turned on. To turn on user interface protection, use the Protect method. |
| RowCount | Gets or sets the number of rows in this IWorksheet. |
| RowHeader | Gets the row header of a worksheet. |
| Rows | Get an IRange object that represents all the rows on the worksheet. |
| Sort | Gets the sort object. |
| Styles | Gets a IWorksheetStyles collection that represents all the styles in the worksheet. |
| Tables | Gets the ITables object which manages all tables in this IWorksheet. |
| Type | Gets the worksheet type. |
| Visible | Gets or sets a SheetVisibility value that determines whether the worksheet is visible. |
| Workbook | Gets the Workbook object contains current Worksheet object. |
The following tables list the members exposed by IWorksheet.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | Activate | Makes the current sheet the active sheet. |
| Calculate | Calculates this worksheet. |
| CircleInvalid | Overloaded. Circles invalid entries on the worksheet. |
| ClearCircles | Clears circles from invalid entries on the worksheet. |
| Copy | Copies this IWorksheet to the specified position in the IWorksheet collection of the Workbook. |
| Delete | Deletes this IWorksheet from its owner Workbook. |
| GetValue | Gets raw data from the specified cell on this sheet. |
| InsertColumns | Inserts column(s) to the Worksheet at the specified position. |
| InsertRows | Inserts row(s) to the Worksheet at the specified position. |
| Move | Moves this IWorksheet to the specified position in the IWorksheet collection of the Workbook. |
| Protect | Protects a worksheet so that it cannot be modified. |
| Range | Overloaded. Get an IRange object that represents a cell or a range of cells. |
| RemoveColumns | Removes one or more columns starting with the column at the specified position. |
| RemoveRows | Removes one or more rows starting with the row at the specified position. |
| SetValue | Overloaded. Sets the System.Boolean value for the cell of the specified row and column. |
| Unprotect | Unprotects the worksheet which is protected by password. |
See Also