Click or drag to resize

ExcelCellValue Property

Gets or sets value of this cell or of merged range if this cell is merged.

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version:
public override Object Value { get; set; }

Property Value

Type: Object
NotSupportedExceptionValue is not supported.

Exception is thrown if value for the set is not of supported type (See ExcelFile.SupportsType for details).

Note that the fact some type is supported doesn't mean it is written to Excel file in the native format. As Microsoft Excel has just few basic types, the object of supported type will be converted to a similar excel type. If similar excel type doesn't exist, value is written as a string value.

If the value of this property is of DateTime type and Style number format is not set, ISO date/time format will be used as CellStyle.NumberFormat value.

See Also