CellRange.Value Property
Gets or sets a cell value.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| CellValue | A cell value. |
Remarks
A CellValue object specifies a value contained in a cell. Use the Value property to specify or obtain a cell value.
You can set the Value property to an object of the String, DateTime, Boolean or numeric type (Int32, Double, etc.). See the Cell Data Types topic for details on cell values and their types.
Note
You cannot assign a Decimal value to a cell via the CellRange.Value property. Use the CellRange.SetValue or CellValue.FromObject method instead.
The CellRange.SetValue method allows you to assign an object of any type to a cell value. It uses the default converter to convert the specified object to a CellValue and assigns it to a cell. To use a custom converter, use the CellValue.FromObject method. See the How to: Convert Objects to Cell Values and Cell Values to Objects example.
You can also use a formula to calculate a cell value dynamically.
If a cell has no data, the Value property returns an empty value object (CellValue.IsEmpty is true).
Example
This example demonstrates how to use the CellRange.Value property to add data of different types to worksheet cells.
Enclose your code in the Workbook.BeginUpdate - Workbook.EndUpdate method calls to improve performance when you edit multiple cells in a document.
// Add data of different types to cells.
worksheet.Cells["B1"].Value = DateTime.Now;
worksheet.Cells["B2"].Value = Math.PI;
worksheet.Cells["B3"].Value = "Have a nice day!";
worksheet.Cells["B4"].Value = CellValue.ErrorReference;
worksheet.Cells["B5"].Value = true;
worksheet.Cells["B6"].Value = float.MaxValue;
worksheet.Cells["B7"].Value = 'a';
worksheet.Cells["B8"].Value = Int32.MaxValue;
// Fill all cells in the range with 10.
worksheet.Range["B10:E10"].Value = 10;
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the Value property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.