| Exception | Description |
|---|---|
| System.NotSupportedException | The assigned value's type is not supported and can't be exported to Excel. |
| System.InvalidOperationException | The value assigned is a Formula. Instead, Formula.ApplyTo should be called on the Formula, passing in the cell. |
| System.InvalidOperationException | The value assigned is a WorksheetDataTable. Instead, the WorksheetDataTable.CellsInTable should be set to a region containing the cell. |
| System.InvalidOperationException | The value assigned is a FormattedString which is the value another cell or merged cell region. |
| System.InvalidOperationException | The value is assigned and this cell is part of an ArrayFormula or WorksheetDataTable. |
If this cell belongs to a merged cell region and it is the top-left cell of the region, getting and setting the value will get and set the value of the associated merged cell region. Getting the value of other cells in a merged cell region will always return null. Setting the value of other cells in a merged cell region will have no effect.
If a formula has been applied to the cell or a data table is associated with the cell, getting the Value will return the calculated value of the cell.
The types supported for the value are:
Note: it is slightly faster to use the WorksheetRow.GetCellValue or WorksheetRow.SetCellValue methods, which do not create WorksheetCell instances internally. However, if a reference to the WorksheetCell instance already exists, using this property is equivalent to using the WorksheetRow.GetCellComment or WorksheetRow.SetCellComment methods.
Target Platforms: Android 4.4+, iOS 8+
Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+