 | Cell Class |
Class representing a cell of a worksheet
Inheritance HierarchySystemObject
NanoXLSXCell
NanoXLSXCell
Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.7+3223c8b99fcd3402b4ae016daa480abac16f8a9f
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, Address) | Constructor with value, cell type and address as struct. The worksheet reference is set to null and must be assigned later |
| Cell(Object, CellCellType, String) | Constructor with value, cell type and address as string. The worksheet reference is set to null and must be assigned later |
| Cell(Object, CellCellType, Int32, Int32) | Constructor with value, cell type, row number and column number |
Properties| Name | Description | |
|---|---|---|
 | CellAddress | Gets or sets the combined cell Address as string in the format A1 - XFD1048576. The address may contain a CellAddressType modifier (e.g. C$50) |
| CellAddress2 | Gets or sets the combined cell Address as Address object |
| CellAddressType | Gets or sets the optional address type that can be part of the cell address. |
| 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). When setting a value, the DataType is automatically resolved |
Methods| Name | Description | |
|---|---|---|
| CompareTo | Implemented CompareTo method |
 | ConvertArrayT | Converts a List of supported objects into a list of cells |
 | Copy | Copies this cell into a new one. The style is considered if not null. |
| Equals | (Overrides ObjectEquals(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) |
| GetAddressScope | Gets the scope of the passed address (string expression). Scope means either single cell address or range |
| GetCellRange(String) | Gets a list of cell addresses from a cell range (format A1:B3 or AAD556:AAD1000) |
| GetCellRange(Address, Address) | Get a list of cell addresses from a cell range |
| GetCellRange(String, String) | 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 the default hash function. (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 |
| ResolveCellCoordinate(String, Int32, Int32, CellAddressType) | 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 or automatically if a value was set by Value. CellType FORMULA will skip this method and EMPTY will discard the value of the cell |
| 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) |
| ValidateColumnNumber | Validates the passed (zero-based) column number. An exception will be thrown if the column is invalid |
| ValidateRowNumber | Validates the passed (zero-based) row number. An exception will be thrown if the row is invalid |
See Also