GrapeCity.Excel Namespace : ExcelWorksheet Class |
The following tables list the members exposed by ExcelWorksheet.
Name | Description | |
---|---|---|
ExcelWorksheet Constructor | Overloaded. |
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. |
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. |