Class WebCells
Contents
[
Hide
]WebCells class
[Obsolete("This class is obsolete; use GridCells instead")]
public class WebCells
Properties
| Name | Description |
|---|---|
| Count { get; } | Gets the number of cells. |
| Item { get; } | Gets the Cell element at the specified cell row index and column index. (2 indexers) |
| MaxColumn { get; } | |
| MaxRow { get; } | |
| MergedCells { get; } | Gets the collection of merged cells. |
| MinColumn { get; } | Min column number of cell which contains data or style. |
| MinRow { get; } | Min row number of cell which contains data or style. |
| StandardHeight { get; set; } | Gets or sets the default row height in this worksheet,in unit of points. |
| StandardWidth { get; set; } | Gets or sets the default column width in the worksheet,in unit of characters. |
Methods
| Name | Description |
|---|---|
| Clear() | |
| ClearContents(int, int, int, int) | Clears contents of a range. |
| DeleteColumn(int) | Deletes a column. |
| DeleteRow(int) | Deletes a row. |
| DeleteRows(int, int) | Deletes a number of rows. This method is much faster than DeleteRow when doing a batch row deleting. |
| 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. |
| GetColumnCaption(int) | Gets the column caption. If the caption is not set, returns empty string. |
| GetColumnReadonly(int) | Gets if a column is readonly. this is extended method of GridWeb specifically,it will not keep and take affect in actual excel file |
| GetColumnWidth(int) | Gets the width of the specified column |
| GetEnumerator() | Gets the cells enumerator |
| GetRowCaption(int) | Gets the row caption. If the caption is not set, returns empty string. |
| GetRowHeight(int) | Gets the height of a specified row. |
| GetRowHiddenStatus(int) | Get hidden status of a specified row. |
| GetRowOutlineLevel(int) | Gets the outline level of the row. |
| GetRowReadonly(int) | Gets if a row is readonly. this is extended method of GridWeb specifically,it will not keep and take affect in actual excel file |
| InsertColumn(int) | Inserts a new column into the worksheet. |
| InsertRow(int) | Inserts a new row into the worksheet. |
| InsertRows(int, int) | Inserts multiple rows into the worksheet. |
| Merge(int, int, int, int) | |
| SetBorders(int, int, int, int, SetBorderPosition, WebBorderStyle) | Sets borders for a cells range. |
| SetColumnCaption(int, string) | Sets the caption for the column.please note this is an extension attribute and can not keep in excel file |
| SetColumnReadonly(int, bool) | Sets a column to readonly so user can’t delete it from client side. this is extended method of GridWeb specifically,it will not keep and take affect in actual excel file |
| SetColumnWidth(int, Unit) | Sets the width of the specified column.the accepted width type is Point,Pixel or Inch |
| SetRowCaption(int, string) | Sets the caption for the row. |
| SetRowHeight(int, Unit) | Sets the height of the specified row.the accepted width type is Point,Pixel or Inch |
| SetRowHiddenStatus(int, bool) | Set hidden status of a specified row. |
| SetRowOutlineLevel(int, int) | Sets the outline level of the row. |
| SetRowOutlineLevelAndStatus(int, int, bool) | Sets the outline level of the row. |
| SetRowReadonly(int, bool) | Sets a row to readonly so user can’t delete it from client side. this is extended method of GridWeb specifically,it will not keep and take affect in actual excel file |
| SetStyle(string, TableItemStyle) | Sets the style to a specified range of cells. |
| SetStyle(int, int, int, int, TableItemStyle) | Sets the style to a specified range of cells. |
| Sort(int, int, int, int, int) | Sorts the datas ascend top to bottom in a range of a WebWorksheet by specified column index. |
| Sort(int, int, int, int, int[]) | Sorts the datas ascend top to bottom in a range of a WebWorksheet by some field that are specifed by column indexes array. |
| Sort(int, int, int, int, int, SortByOrder, SortOrientation, bool) | Sorts the datas ascend top to bottom in a range of a WebWorksheet by specified column index. |
| Sort(int, int, int, int, int[], SortByOrder[], SortOrientation, bool) | Sorts the datas ascend in a range of a WebWorksheet by some field that are specifed by indexes array. |
| 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. |
Remarks
NOTE: This class is now obsolete. please use GridCells Instead. This class will be removed after 6 months since Aug. 2014. Aspose apologizes for any inconvenience you may have experienced.
See Also
- namespace Aspose.Cells.GridWeb.Data
- assembly Aspose.Cells.GridWeb