Cell Properties

The Cell type exposes the following members.

Properties
  NameDescription
Public propertyBoolValue
Gets the boolean value contained in the cell.
Public propertyColumn
Gets column number (zero based) of the cell.
Public propertyContainsExternalLink
Indicates whether this cell contains an external link. Only applies when the cell is a formula cell.
Public propertyDateTimeValue
Gets the DateTime value contained in the cell.
Public propertyDisplayStringValue
Gets the formatted string value of this cell.
Public propertyDoubleValue
Gets the double value contained in the cell.
Public propertyFloatValue
Gets the float value contained in the cell.
Public propertyCode exampleFormula
Gets or sets a formula of the Cell.
Public propertyFormulaLocal
Get the locale formatted formula of the cell.
Public propertyHtmlString
Gets and sets the html string which contains data and some formats in this cell.
Public propertyIntValue
Gets the integer value contained in the cell.
Public propertyIsArrayFormula
Indicates whether the cell formula is an array formula.
Public propertyIsArrayHeader
Inidicates the cell's formula is and array formula and it is the first cell of the array.
Public propertyIsErrorValue
Checks if a formula can properly evaluate a result.
Public propertyIsFormula
Represents if the specified cell contains formula.
Public propertyIsInArray Obsolete.
Indicates whether the cell formula is an array formula.
Public propertyIsInTable Obsolete.
Indicates whether this cell is part of table formula.
Public propertyIsMerged
Checks if a cell is part of a merged range or not.
Public propertyIsSharedFormula
Indicates whether the cell formula is part of shared formula.
Public propertyIsStyleSet
Indicates if the cell's style is set. If return false, it means this cell has a default cell format.
Public propertyIsTableFormula
Indicates whether this cell is part of table formula.
Public propertyName
Gets the name of the cell.
Public propertyNumberCategoryType
Represents the category type of this cell's number formatting.
Public propertyR1C1Formula
Gets or sets a R1C1 formula of the Cell.
Public propertyRow
Gets row number (zero based) of the cell.
Public propertySharedStyleIndex
Gets cell's shared style index in the style pool.
Public propertyStringValue
Gets the string value contained in the cell. If the type of this cell is string, then return the string value itself. For other cell types, the formatted string value (formatted with the specified style of this cell) will be returned. The formatted cell value is same with what you can get from excel when copying a cell as text(such as copying cell to text editor or exporting to csv).
Public propertyStringValueWithoutFormat
Gets cell's value as string without any format.
Public propertyType
Represents cell value type.
Public propertyValue
Gets the value contained in this cell.
Public propertyWorksheet
Gets the parent worksheet.
See Also