Link Search Menu Expand Document

ICell Properties

The ICell type exposes the following members.

Properties
NameDescription
Public propertyContainsArrayFormula
Gets a value indicating whether this cell contains an array formula.
Public propertyFormula
Gets or sets the formula for the cell.
Public propertyIsInteger
Gets a value indicating whether this Cell contains integer number.
Public propertyMerged
Gets a value indicating whether this Cell is merged.
Public propertyMergedWith
Gets the Range merged with this cell.
Public propertyMergedWithCell
Gets the top left cell of Range merged this with cell.
Public propertyNumberFormatString
Gets or sets the number format string.
Public propertyValue
Gets or sets the value of cell.
Public propertyValueAsBoolean
Gets a value as boolean.
Public propertyValueAsDateTime
Gets or sets the value as date time, see type DateTime
Public propertyValueAsDouble
Gets the value as double.
Public propertyValueAsExcelDisplays
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.
Public propertyValueAsHTML
Gets or sets the formatted text (Rich-Text) in HTML coded format
Public propertyValueAsInteger
Gets the value as integer.
Public propertyValueAsString
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.
Public propertyValueAsUnformattedString
Gets the value as unformatted string.
Public propertyValueDataType
Gets the type of the value data.
Public propertyValueDataTypeByNumberFormatString
Changes (NumberFormatString to the predefined format string depending according to the (NumberFormatType) type
Top
See Also

Reference