GrapeCity.Excel Namespace : ExcelWorksheet Class |
For a list of all members of this type, see ExcelWorksheet members.
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. |