 | Cell Class |
Class representing a cell of a worksheet
Inheritance HierarchySystemObject
PicoXLSXCell
PicoXLSXCell
Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.2+f55916d49ef2baa43fc7dc8f5c7d751a77c50baf
SyntaxC#
public class Cell : IComparable<Cell>
The Cell type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | Cell | Initializes a new instance of the Cell class |
| Cell(Object, CellCellType) | Initializes a new instance of the Cell class |
| Cell(Object, CellCellType, CellAddress) | 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) | Initializes a new instance of the Cell class |
| Cell(Object, CellCellType, Int32, Int32) | Initializes a new instance of the Cell class |
Properties| Name | Description | |
|---|---|---|
 | CellAddress | Gets or sets the combined cell Address as string in the format A1 - XFD1048576 |
| CellAddress2 | Gets or sets the CellAddress2 |
| 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 ColumnNumber |
| DataType | Gets or sets the DataType |
| RowNumber | Gets or sets the RowNumber |
| Value | Gets or sets the Value |
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 | Determines whether the specified object is equal to the current object. (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) |
| 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(CellAddress, CellAddress) | 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