GrapeCity.Excel Namespace : IExcelWorksheet Interface |
The following tables list the members exposed by IExcelWorksheet.
Name | Description | |
---|---|---|
ActiveColumnIndex | Gets or sets the index of the active column. | |
ActiveRowIndex | Gets or sets the index of the active row. | |
AutoFilter | Gets or sets the auto filter used in the worksheet. | |
ColumnCount | Gets or sets the column count of the sheet. | |
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. | |
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 | Gets the IExcelCell with the specified location | |
MergedCells | Gets or sets the merged cells information. | |
Name | Gets or sets the sheet name. | |
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 | Gets or sets the row count of the sheet. | |
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 sets the zoom factor of the sheet. |
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. |