Class GridCells
Contents
[
Hide
]GridCells class
Encapsulates a collection of GridCell objects.
public class GridCells : IEnumerable
Properties
| Name | Description |
|---|---|
| Columns { get; } | Gets the collection of GridColumn objects that represents the individual columns in this worksheet. |
| Count { get; } | Gets the number of cells. |
| FirstCell { get; } | Gets the first cell in this worksheet. |
| Item { get; } | Gets the GridCell element at the specified cell row index and column index. (2 indexers) |
| LastCell { get; } | Gets the last cell in this worksheet. |
| MaxColumn { get; } | Maximum column index of cell which contains data or style. |
| MaxDataColumn { get; } | Maximum column index of cell which contains data. |
| MaxDataRow { get; } | Maximum row index of cell which contains data. |
| MaxRow { get; } | Maximum row index of cell which contains data or style. |
| MergedCells { get; } | Gets the collection of merged cells. |
| MinColumn { get; } | Minimum column index of those cells that have been instantiated in the collection(does not include the column where style is defined for the whole column but no cell has been instantiated in it). |
| MinDataColumn { get; } | Minimum column index of cell which contains data. |
| MinDataRow { get; } | Minimum row index of cell which contains data. |
| MinRow { get; } | Minimum row index of cell which contains data or style. |
| RowEnumerator { get; } | Gets the rows enumerator |
| Rows { get; } | Gets the collection of GridRow objects that represents the individual rows in this worksheet. |
| StandardHeight { get; set; } | Gets or sets the default row height in this worksheet,in unit of points. |
| StandardHeightPixels { get; set; } | Gets or sets the default row height in this worksheet,in unit of pixels. |
| StandardWidth { get; set; } | Gets or sets the default column width in the worksheet,in unit of characters. |
| StandardWidthInch { get; set; } | Gets or sets the default column width in the worksheet, in unit of inches. |
| StandardWidthPixels { get; set; } | Gets or sets the default column width in the worksheet, in unit of pixels. |
Methods
| Name | Description |
|---|---|
| CheckCell(int, int) | Gets the GridCell element or null at the specified cell row index and column index. |
| CheckColumn(int) | Gets the GridColumn element or null at the specified column index. |
| CheckRow(int) | Gets the GridRow element or null at the specified cell row index. |
| Clear() | Clear all cells in the collection. |
| ClearContents(GridCellArea) | Clears contents of a range. |
| ClearContents(int, int, int, int) | Clears contents of a range. |
| ClearFormats(GridCellArea) | Clears formatting of a range. |
| ClearFormats(int, int, int, int) | Clears formatting of a range. |
| ClearRange(GridCellArea) | Clears contents and formatting of a range. |
| ClearRange(int, int, int, int) | Clears contents and formatting of a range. |
| CopyColumn(GridCells, int, int) | Copies data and formattings of a whole column. |
| CopyColumns(GridCells, int, int, int) | Copies data and formattings of a whole column. |
| CopyRow(GridCells, int, int) | Copies data and formattings of a whole row. |
| CopyRows(GridCells, int, int, int) | Copies data and formattings of some whole rows. |
| DeleteBlankColumns() | Delete all blank columns which do not contain any data. |
| DeleteBlankRows() | Delete all blank rows which do not contain any data. |
| DeleteColumn(int) | Deletes a column. |
| DeleteColumn(int, bool) | Deletes a column. |
| DeleteColumns(int, int, bool) | Deletes several columns. |
| DeleteRange(int, int, int, int, GridShiftType) | Deletes a range of cells and shift cells according to the shift option. |
| DeleteRow(int) | Deletes a row. |
| DeleteRows(int, int) | Deletes several rows. |
| DeleteRows(int, int, bool) | Deletes multiple rows in the worksheet. |
| Export(int, int, int, int, bool, bool) | Exports data in the Cells collection of a WebWorksheet to a new DataTable object |
| ExportArray(int, int, int, int) | Exports data in the GridCells collection to a two-dimension array object. |
| GetCell(int, int) | Gets the GridCell element at the specified cell row index and column index. |
| GetColumnWidth(int) | Gets the width of the specified column |
| GetColumnWidthInch(int) | Gets the width of the specified column, in units of inches. |
| GetColumnWidthPixel(int) | Gets the width of the specified column, in units of pixel. |
| GetEnumerator() | Gets the rows enumerator |
| GetRow(int) | Gets the GridRow element or at the specified cell row index. |
| GetRowHeight(int) | Gets the height of a specified row. |
| GetRowHeightInch(int) | Gets the height of a specified row in unit of inches. |
| GetRowHeightPixel(int) | Gets the height of a specified row in unit of pixel. |
| GetRowOutlineLevel(int) | Gets the outline level of the row. |
| GetViewColumnWidthPixel(int) | Get the width in different view type. |
| GroupColumns(int, int) | Groups columns. |
| GroupColumns(int, int, bool) | Groups columns. |
| GroupRows(int, int) | Groups rows. |
| HideColumn(int) | Hides a column. |
| HideRow(int) | Hides a row. |
| InsertColumn(int) | Inserts a new column into the worksheet. |
| InsertColumn(int, bool) | Inserts a new column into the worksheet. |
| InsertColumns(int, int) | Inserts some columns into the worksheet. |
| InsertColumns(int, int, bool) | Inserts some columns into the worksheet. |
| InsertRange(GridCellArea, GridShiftType) | Inserts a range of cells and shift cells according to the shift option. |
| InsertRange(GridCellArea, int, GridShiftType, bool) | Inserts a range of cells and shift cells according to the shift option. |
| InsertRow(int) | Inserts a new row into the worksheet. |
| InsertRows(int, int) | Inserts multiple rows into the worksheet. |
| InsertRows(int, int, bool) | Inserts multiple rows into the worksheet. |
| IsBlankColumn(int) | Checks whether given column is blank(does not contain any data). |
| IsColumnHidden(int) | Checks whether a column at given index is hidden. |
| IsRowHidden(int) | Checks whether a row at given index is hidden. |
| Merge(int, int, int, int) | Merges a specified range of cells into a single cell. |
| MoveRange(GridCellArea, int, int) | Moves the range. |
| RemoveDuplicates(int, int, int, int) | Remove duplicate values in the range. |
| RemoveFormulas() | Removes all formula and replaces with the value of the formula. |
| SetBorders(int, int, int, int, SetBorderPosition, WebBorderStyle) | Sets borders for a cells range. |
| SetColumnWidth(int, double) | Sets the width of the specified column. |
| SetColumnWidthInch(int, double) | Sets column width in unit of inches. |
| SetColumnWidthPixel(int, int) | Sets column width in unit of pixels. |
| SetRowHeight(int, double) | Sets the height of the specified row. |
| SetRowHeightInch(int, double) | Sets row height in unit of inches. |
| SetRowHeightPixel(int, int) | Sets row height in unit of pixels. |
| SetRowOutlineLevel(int, int) | Sets the outline level of the row. |
| SetStyle(string, GridTableItemStyle) | Sets the style to a specified range of cells. |
| SetStyle(int, int, int, int, GridTableItemStyle) | Sets the style to a specified range of cells. |
| Sort(int, int, int, int, int, bool, bool, bool) | Sorts the datas ascend/decend top to bottom in a range of a Worksheet by specified column index. Sorts the datas ascend/decend left to right in a range of a Worksheet by specified row index. |
| Sort(int, int, int, int, int[], SortByOrder[], SortOrientation, bool) | Sorts the datas ascend/decend top to bottom in a range of a Worksheet by specified column index. Sorts the datas ascend/decend left to right in a range of a Worksheet by specified row index. |
| UngroupColumns(int, int) | Ungroups columns. |
| UngroupRows(int, int) | Ungroups rows. |
| UnhideColumn(int, double) | Unhides a column |
| UnhideRow(int) | Unhides a row. |
| UnMerge(int, int, int, int) | Unmerges a specified range of merged cells. |
| static CellIndexToName(int, int) | Gets cell name according to its row and column indexes. |
| static CellNameToIndex(string, out int, out int) | Gets the cell row and column indexes according to its name |
| static ColumnIndexToName(int) | Gets column name according to column index. |
| static ColumnNameToIndex(string) | Gets column index according to column name. |
See Also
- namespace Aspose.Cells.GridWeb.Data
- assembly Aspose.Cells.GridWeb
