Click or drag to resize
PicoXLSX

Cell Methods

The Cell type exposes the following members.

Methods
 NameDescription
Public methodCompareTo Implemented CompareTo method
Public methodStatic memberConvertArrayT Converts a List of supported objects into a list of cells
Protected methodCopy Copies this cell into a new one. The style is considered if not null
Public methodEqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
Protected methodFinalizeAllows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object)
Public methodStatic memberGetAddressScope Gets the scope of the passed address (string expression). Scope means either single cell address or range
Public methodStatic memberGetCellRange(String) Gets a list of cell addresses from a cell range (format A1:B3 or AAD556:AAD1000)
Public methodStatic memberGetCellRange(CellAddress, CellAddress) Get a list of cell addresses from a cell range
Public methodStatic memberGetCellRange(String, String) Get a list of cell addresses from a cell range
Public methodStatic memberGetCellRange(Int32, Int32, Int32, Int32) Get a list of cell addresses from a cell range
Public methodGetHashCodeServes as the default hash function.
(Inherited from Object)
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Protected methodMemberwiseCloneCreates a shallow copy of the current Object.
(Inherited from Object)
Public methodRemoveStyle Removes the assigned style from the cell
Public methodStatic memberResolveCellAddress Gets the address of a cell by the column and row number (zero based)
Public methodStatic memberResolveCellCoordinate(String) Gets the column and row number (zero based) of a cell by the address
Public methodStatic memberResolveCellCoordinate(String, Int32, Int32) Gets the column and row number (zero based) of a cell by the address
Public methodStatic memberResolveCellCoordinate(String, Int32, Int32, CellAddressType) Gets the column and row number (zero based) of a cell by the address
Public methodStatic memberResolveCellRange Resolves a cell range from the format like A1:B3 or AAD556:AAD1000
Public methodResolveCellType 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
Public methodStatic memberResolveColumn Gets the column number from the column address (A - XFD)
Public methodStatic memberResolveColumnAddress Gets the column address (A - XFD)
Public methodSetCellLockedState Sets the lock state of the cell
Public methodSetStyle Sets the style of the cell
Public methodToStringReturns a string that represents the current object.
(Inherited from Object)
Public methodStatic memberValidateColumnNumber Validates the passed (zero-based) column number. an exception will be thrown if the column is invalid
Public methodStatic memberValidateRowNumber Validates the passed (zero-based) row number. an exception will be thrown if the row is invalid
Top
See Also