The following tables list the members exposed by ExcelWorksheet.
Public Constructors
| Name | Description | |
|---|---|---|
 | ExcelWorksheet Constructor | Overloaded. |
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveColumnIndex | Gets or sets the index of the active column. |
| ActiveRowIndex | Gets or sets the index of the active row. |
| ActualColumnCount | Actual total columns count used by the current worksheet |
| ActualRowCount | Actual total rows count used by the current worksheet |
| AutoFilter | Gets or sets the auto filter used in the worksheet. |
| ColumnCount | Get or set the column count. |
| ColumnGutter | Gets or sets the column gutter. |
| ColumnMaxOutlineLevel | Gets or sets the column max outline level. |
| ConditionalFormat | Gets or sets the conditional formats used in the worksheet. |
| DefaultColumnWidth | Gets or sets the default width of the column. |
| DefaultRowHeight | Gets or sets the default height of the row. |
| DefaultViewport | Gets or sets the default viewport information of the worksheet. |
| ExcelCharts | Gets the excel charts. |
| ExcelImages | Gets the excel images. |
| ExtendedFormats | Gets or sets the extended formats for the worksheet. |
| FrozenColumnCount | Gets or sets the frozen column count. |
| FrozenRowCount | Gets or sets the frozen row count. |
| GridLineColor | Gets or sets the color of the grid line. |
| IsLocked | Gets or sets a value indicating whether this instance is locked. |
| IsVisible | Gets or sets a value indicating whether this instance is visible. |
| Item | Get the ExcelCell at the specified by row and column. |
| MergedCells | Gets or sets the merged cells information. |
| Name | Gets or sets the name of the ExcelWorksheet. |
| NamedCellRanges | Gets or sets the named cell ranges information |
| PrintArea | Gets or sets the print area information of the worksheet. |
| PrintSettings | Gets or sets the print settings of the sheet. |
| PrintTitle | Gets or sets the print title information of the worksheet. |
| RightToLeftColumns | Gets or sets a value indicating whether the sheet is in 'right to left' display mode |
| RowCount | Get or set the row count. |
| RowGutter | Gets or sets the row gutter. |
| RowMaxOutlineLevel | Gets or sets the row max outline level. |
| Selections | Gets the selection information. |
| SheetTabColor | Gets or sets the color of the sheet tab. |
| ShowFormulas | Gets or sets a value indicating whether this sheet should display formulas. |
| ShowGridLines | Gets or sets a value indicating whether show gridlines or not. |
| ShowHeaders | Gets or sets a value indicating whether show headers. |
| ShowZeros | Gets or sets a value indicating whether the window should show 0 (zero) in cells containing zero value. |
| SparklineGroups | Gets or sets the groups of sparklines on the sheet. |
| SummaryColumnsToRightOfDetail | Get or set the direction of the summary columns. |
| SummaryRowsBelowDetail | Get or set the direction of the summary rows. |
| Zoom | Gets or set the zoom factor of the entire ExcelWorksheet. |
Public Methods
| Name | Description | |
|---|---|---|
 | AddChart | Adds the chart. |
| 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 in the current sheet |
| SetValue | Sets the value of the cell. |
See Also