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. |