Cell Class
From NanoXLSX
NanoXLSX Library Documentation
 | Cell Class |
Class representing a cell of a worksheet
Inheritance HierarchyNamespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)
SyntaxC#
public class Cell : IComparable<Cell>
The Cell type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | Cell | Default constructor. Cells created with this constructor do not have a link to a worksheet initially |
| Cell(Object, CellCellType) |
Constructor with value and cell type. Cells created with this constructor do not have a link to a worksheet initially
|
| Cell(Object, CellCellType, String) |
Constructor with value, cell type and address. The worksheet reference is set to null and must be assigned later
|
| Cell(Object, CellCellType, Int32, Int32, Worksheet) |
Constructor with value, cell type, row number, column number and the link to a worksheet
|
Properties| Name | Description | |
|---|---|---|
 | CellAddress |
Gets or sets the combined cell Address as string in the format A1 - XFD1048576
|
| CellAddress2 | Gets or sets the combined cell Address as Address object |
| CellStyle |
Gets the assigned style of the cell
|
| ColumnNumber | Gets or sets the number of the column (zero-based) |
| DataType | Gets or sets the type of the cell |
| RowNumber | Gets or sets the number of the row (zero-based) |
| Value | Gets or sets the value of the cell (generic object type) |
| WorksheetReference |
Gets or sets the parent worksheet reference
|
Methods| Name | Description | |
|---|---|---|
| CompareTo |
Implemented CompareTo method
|
 | ConvertArrayT |
Converts a List of supported objects into a list of cells
|
| Equals | (Inherited from Object.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetCellRange(String) |
Gets a list of cell addresses from a cell range (format A1:B3 or AAD556:AAD1000)
|
| GetCellRange(String, String) |
Get a list of cell addresses from a cell range
|
| GetCellRange(CellAddress, CellAddress) |
Get a list of cell addresses from a cell range
|
| GetCellRange(Int32, Int32, Int32, Int32) |
Get a list of cell addresses from a cell range
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| RemoveStyle |
Removes the assigned style from the cell
|
| ResolveCellAddress |
Gets the address of a cell by the column and row number (zero based)
|
| ResolveCellCoordinate(String) |
Gets the column and row number (zero based) of a cell by the address
|
| ResolveCellCoordinate(String, Int32, Int32) |
Gets the column and row number (zero based) of a cell by the address
|
| ResolveCellRange |
Resolves a cell range from the format like A1:B3 or AAD556:AAD1000
|
| ResolveCellType |
Method resets the Cell type and tries to find the actual type. This is used if a Cell was created with the CellType DEFAULT. CellTypes FORMULA and EMPTY will skip this method
|
| ResolveColumn |
Gets the column number from the column address (A - XFD)
|
| ResolveColumnAddress |
Gets the column address (A - XFD)
|
| SetCellLockedState |
Sets the lock state of the cell
|
| SetStyle |
Sets the style of the cell
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
See Also