NanoXLSX Library Documentation
Cell Class |
Class representing a cell of a worksheet
Inheritance Hierarchy
Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)
Syntax
C#
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