Cell Class

PicoXLSX

previous page next page

PicoXLSX Library Documentation

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

Copy

public class Cell : IComparable<Cell>

The Cell type exposes the following members.

Constructors

	Name	Description
	Cell	Default constructor. Cells created with this constructor do not have a link to a worksheet initially
	Cell(Object, CellCellType)	Constructor with value and cell type. Cells created with this constructor do not have a link to a worksheet initially
	Cell(Object, CellCellType, Int32, Int32, Worksheet)	Constructor with value, cell type, row number, column number and the link to a worksheet

Top

Properties

	Name	Description
	CellAddress	Gets or sets the combined cell Address as string in the format A1 - XFD1048576
	CellAddress2	Gets or sets the combined cell Address as Address object
	CellStyle	Gets the assigned style of the cell
	ColumnNumber	Gets or sets the number of the column (zero-based)
	DataType	Gets or sets the type of the cell
	RowNumber	Gets or sets the number of the row (zero-based)
	Value	Gets or sets the value of the cell (generic object type)
	WorksheetReference	Gets or sets the parent worksheet reference

Top

Methods

	Name	Description
	CompareTo	Implemented CompareTo method
	ConvertArrayT	Converts a List of supported objects into a list of cells
	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.)
	GetCellRange(String)	Gets a list of cell addresses from a cell range (format A1:B3 or AAD556:AAD1000)
	GetCellRange(String, String)	Get a list of cell addresses from a cell range
	GetCellRange(CellAddress, CellAddress)	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 a hash function for a particular type. (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
	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. CellTypes FORMULA and EMPTY will skip this method
	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.)

Top

Reference

PicoXLSX Namespace

previous page start next page