Cell Class

PicoXLSX

PicoXLSX

Cell Class

Class representing a cell of a worksheet
Inheritance Hierarchy
SystemObject  PicoXLSXCell

Namespace:  PicoXLSX
Assembly:  PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)
Syntax
C#
public class Cell : IComparable<Cell>

The Cell type exposes the following members.

Constructors
  NameDescription
Public methodCell
Default constructor. Cells created with this constructor do not have a link to a worksheet initially
Public methodCell(Object, CellCellType)
Constructor with value and cell type. Cells created with this constructor do not have a link to a worksheet initially
Public methodCell(Object, CellCellType, Int32, Int32, Worksheet)
Constructor with value, cell type, row number, column number and the link to a worksheet
Top
Properties
  NameDescription
Public propertyCellAddress
Gets or sets the combined cell Address as string in the format A1 - XFD1048576
Public propertyCellAddress2
Gets or sets the combined cell Address as Address object
Public propertyCellStyle
Gets the assigned style of the cell
Public propertyColumnNumber
Gets or sets the number of the column (zero-based)
Public propertyDataType
Gets or sets the type of the cell
Public propertyRowNumber
Gets or sets the number of the row (zero-based)
Public propertyValue
Gets or sets the value of the cell (generic object type)
Public propertyWorksheetReference
Gets or sets the parent worksheet reference
Top
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