Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

CellRange.Value Property

Gets or sets a cell value.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

CellValue Value { get; set; }

#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.

View Example

// 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;

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.

See Also