Link Search Menu Expand Document

ICell Interface

Cell interface

Namespace:Bytescout.Spreadsheet.COM
Assembly: Bytescout.Spreadsheet (in Bytescout.Spreadsheet.dll) Version: 4.5.1.2018-master
Syntax
public interface ICell

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
Methods
NameDescription
Public methodCalculate
Calculates of formula this cell (if formula is set for this cell)
Public methodClear
Clears this cell.
Public methodGetAddress
Returns address of the cell as CellAddress object.
Public methodToDateTime
Return the cell value as date time, see type DateTime
Public methodToDouble
Return cell value as double, see type Double.
Public methodToHTML
Return the formatted text (Rich-Text) in HTML coded format
Public methodToInteger
Return cell value as integer, see type Int32.
Public methodToString
Toes the string.
Top
See Also

Reference


Copyright © 2016 - 2021 ByteScout