The following tables list the members exposed by Cell.
Name | Description | |
---|---|---|
GetDisplayStringValue | Retrieves the text representation of a cell's value as it is displayed in sheet processing applications.Useful for obtaining the formatted output of a cell, regardless of the cell's actual data type or value. | |
GetStyle | Retrieves the CellStyle object that encapsulates various styling details, such as font and border settings of a cell. | |
SetCellFormula | Sets the cell formula value. | |
SetCellValue | Assigns a string value to a specific cell within a sheet, used for populating cells with text data. | |
SetStyle | Applies a specific style as defined by a CellStyle object to a cell within a sheet.Thus, enabling the customization of cell appearance, including aspects like font, alignment, and border settings. |
Name | Description | |
---|---|---|
BoolCellValue | Gets the value of the cell that is expected to be a boolean.This property is designed to access the logical value contained within the cell and it is useful in logical operations, condition checks, or representing binary states. | |
CellFormula | Gets the formula for a cell. | |
CellType | Gets the cell type. | |
ColumnIndex | Gets the cell column index which used to determine the column position of a cell within the sheet. | |
DateCellValue | Gets the value of a cell as a date. This property is relevant for cells that are formatted as dates or contain date information. | |
Hyperlink | Gets or sets a hyperlink associated with a cell. This property enables the embedding of URLs or links to other resources within a cell, facilitating navigation and referencing. | |
NumericCellValue | Retrieves the numerical value of a cell such as formatted numbers and dates. | |
RowIndex | Gets the index of the row in which the cell is located within a sheet. | |
StringCellValue | Gets the text content of a cell within a sheet. |