ICell Properties
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
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 |
See Also