Cell Methods

PicoXLSX

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
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodStatic memberGetCellRange(String)
Gets a list of cell addresses from a cell range (format A1:B3 or AAD556:AAD1000)
Public methodStatic memberGetCellRange(String, String)
Get a list of cell addresses from a cell range
Public methodStatic memberGetCellRange(CellAddress, CellAddress)
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 methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates 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 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. CellTypes FORMULA and EMPTY will skip this method
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 methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also