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