officefileapi-devexpress-dot-spreadsheet-dot-cellrange-f4609e42.md
Gets or sets a cell value.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
CellValue Value { get; set; }
Property Value As CellValue
| Type | Description |
|---|---|
| CellValue |
A cell value.
|
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 ).
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;
' Add data of different types to cells.
worksheet.Cells("B1").Value = Date.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 = Single.MaxValue
worksheet.Cells("B7").Value = "a"c
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.
{
workbook.Worksheets[0].Cells["D8"].Value = "This document is exported to the PDF format.";
static void ExportToPdf(IWorkbook workbook) {
workbook.Worksheets[0].Cells["D8"].Value = "This document is exported to the PDF format.";
static void ExportToPdf(IWorkbook workbook) {
workbook.Worksheets[0].Cells["D8"].Value = "This document is exported to the PDF format.";
#region #StoreCustomXmlPart
workbook.Worksheets[0].Cells["A1"].Value = "Custom Xml Test";
CellRange header = worksheet.Range["B2:C2"];
header[0].Value = "Property Name";
header[1].Value = "Value";
Private Sub ExportToPdf(ByVal workbook As Workbook)
workbook.Worksheets(0).Cells("D8").Value = "This document is exported to the PDF format."
#Region "#ExportToPdf"
Private Shared Sub ExportToPdf(ByVal workbook As IWorkbook)
workbook.Worksheets(0).Cells("D8").Value = "This document is exported to the PDF format."
Private Shared Sub ExportToPdf(ByVal workbook As IWorkbook)
workbook.Worksheets(0).Cells("D8").Value = "This document is exported to the PDF format."
Dim header As CellRange = worksheet.Range("B2:C2")
header(0).Value = "Property Name"
header(1).Value = "Value"
Dim header As CellRange = worksheet.Range("B2:C2")
header(0).Value = "Property Name"
header(1).Value = "Value"
See Also
How to: Convert Objects to Cell Values and Cell Values to Objects