GridCells

GridCells class

Encapsulates a collection of Cell objects.

public class GridCells : IEnumerable

Properties

Name Description
Columns { get; }
Count { get; } Gets the number of cells.
FirstCell { get; }
Item { get; } Gets Cell item within the worksheet (3 indexers)
LastCell { get; }
MaxColumn { get; } Maximum column index of cell which contains data or style.
MaxDataColumn { get; }
MaxDataRow { get; }
MaxRow { get; } Maximum row index of cell which contains data or style.
MergedCells { get; } Gets the collection of merged cells.
MinColumn { get; }
MinDataColumn { get; }
MinDataRow { get; }
MinRow { get; }
RowEnumerator { get; } Gets the rows enumerator
Rows { get; }
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; }
StandardWidthPixels { get; set; }

Methods

Name Description
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 Cells collection to a two-dimension array object.
GetCell(int, int) Gets the Cell element or null 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 Row 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.
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[], SortOrder[], SortOrientation, bool)
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