Cell Class |
public class Cell : IComparable<Cell>
The Cell type exposes the following members.
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, String) | Initializes a new instance of the Cell class | |
Cell(Object, CellCellType, Int32, Int32) | Initializes a new instance of the Cell class |
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 |
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 |