ICell Interface
Free Trial Web API version Licensing Request A Quote
HAVE QUESTIONS OR NEED HELP?SUBMIT THE SUPPORT REQUEST FORM or write email toSUPPORT@BYTESCOUT.COM
Cell interface
Namespace:Bytescout.Spreadsheet.COMAssembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.7.0.2045-master
Syntax
The ICell type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | ContainsArrayFormula | Gets a value indicating whether this cell contains an array formula. |
| Formula | Gets or sets the formula for the cell. |
| IsInteger | Gets a value indicating whether this Cell contains integer number. |
| Merged | Gets a value indicating whether this Cell is merged. |
| MergedWith | Gets the Range merged with this cell. |
| MergedWithCell | Gets the top left cell of Range merged this with cell. |
| NumberFormatString | Gets or sets the number format string. |
| Value | Gets or sets the value of cell. |
| ValueAsBoolean | Gets a value as boolean. |
| ValueAsDateTime | Gets or sets the value as date time, see type DateTime |
| ValueAsDouble | Gets the value as double. |
| ValueAsExcelDisplays | Returns the formatted string value of the cell in the sam way you would see in Excel or another spreadsheet editor. Formatting uses the NumberFormatString formatting string settings to format the value. |
| ValueAsHTML | Gets or sets the formatted text (Rich-Text) in HTML coded format |
| ValueAsInteger | Gets the value as integer. |
| ValueAsString | Returns the formatted string value of the cell in the sam way you would see in Excel or another spreadsheet editor. Formatting uses the NumberFormatString settings to format the value. |
| ValueAsUnformattedString | Gets the value as unformatted string. |
| ValueDataType | Gets the type of the value data. |
| ValueDataTypeByNumberFormatString | Changes (NumberFormatString to the predefined format string depending according to the (NumberFormatType) type |
Methods
| Name | Description | |
|---|---|---|
 | Calculate | Calculates of formula this cell (if formula is set for this cell) |
| Clear | Clears this cell. |
| GetAddress | Returns address of the cell as CellAddress object. |
| ToDateTime | Return the cell value as date time, see type DateTime |
| ToDouble | Return cell value as double, see type Double. |
| ToHTML | Return the formatted text (Rich-Text) in HTML coded format |
| ToInteger | Return cell value as integer, see type Int32. |
| ToString | Toes the string. |
See Also