For a list of all members of this type, see IExcelWorksheet members.
Public Methods
| Name | Description | |
|---|---|---|
 | GetCell | Gets the cell at the specified row and column. |
| GetColumn | Gets the column at the specified column index |
| GetDataValidations | Gets the all data validation setting in the worksheet. |
| GetNonEmptyCells | Gets the non empty cells. |
| GetNonEmptyColumns | Gets the non-empty columns. |
| GetNonEmptyRows | Gets the non-empty rows. |
| GetRow | Gets the row at the specified column index |
| GetSheetCharts | Returns all charts defined in the current worksheet. |
| GetSheetImages | Returns all images defined in the current worksheet. |
| GetSheetTables | Returns all tables defined in the current worksheet. |
| GetSpanCell | Gets the range of cells that are spanned at a specified cell in this sheet. |
| GetTopLeft | Get the location of the top left visible cell in the current sheet |
| GetValue | Sets the value of the cell. |
| SetColumn | Initialize the column at the specified index. |
| SetDataValidations | Sets the data validation used in the worksheet |
| SetSheetChart | Add a chart to the current worksheet. |
| SetSheetImage | Add a image to the current worksheet. |
| SetSheetTable | Add a sheet table to the current worksheet. |
| SetTopLeft | Set the location of the top left visible cell. |
| SetValue | Sets the value of the cell. |
See Also