In This Topic ▼
Cell Class Members
Summary
The following tables list the members exposed by Cell.
Public Methods
| 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. |
|
SetCellBooleanValue | Assigns a boolean value to a specific cell within a sheet. |
|
SetCellDateValue | Sets a cell's content to a DateTime value within an Excel sheet. Allows for the direct assignment of date and time information to a cell. |
|
SetCellFormula | Sets the cell formula value. |
|
SetCellNumericValue | Sets a cell's content to a numeric value of type double within a sheet. Enables the direct input of numbers into a cell, facilitating numerical data handling in applications. |
|
SetCellStringValue | 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. |
Public Properties
| 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 column index 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. |
