officefileapi-devexpress-dot-spreadsheet-dot-cellvalue-3ec381b0.md
Returns a number contained in a cell.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public double NumericValue { get; }
Public ReadOnly Property NumericValue As Double
| Type | Description |
|---|---|
| Double |
A Double value specifying a cell value of the numeric type.
|
Use the NumericValue property to obtain the number contained in a cell. To check whether the cell value is of the numeric type, use the CellValue.IsNumeric or CellValue.Type property. To get a string that specifies a numeric value as it is displayed in the cell according to the applied number format, use the Cell.DisplayText property.
Note
Note, that dates and times are stored in cells as numbers that are displayed according to the applied date and time formats. So, if a cell contains a number, the CellValue.DateTimeValue property returns the DateTime object, which specifies a date and time value corresponding to that number.
For more information on cell values, refer to the Cell Data Types document.
The following code snippets (auto-collected from DevExpress Examples) contain references to the NumericValue 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.
{
get { return Sheet["E4"].Value.NumericValue; }
set { Sheet["E4"].Value = value; }
// Create a function specifying the condition to remove worksheet rows.
Func<int, bool> rowRemovalCondition = x => worksheet.Cells[x, 0].Value.NumericValue > 3.0 && worksheet.Cells[x, 0].Value.NumericValue < 14.0;
// Create a function specifying the condition to remove worksheet rows.
Func<int, bool> rowRemovalCondition = x => worksheet.Cells[x, 0].Value.NumericValue > 3.0 && worksheet.Cells[x, 0].Value.NumericValue < 14.0;
// and less than 14, remove the corresponding row.
Func<int, bool> rowRemovalCondition = x => worksheet.Cells[x, 0].Value.NumericValue > 3.0 && worksheet.Cells[x, 0].Value.NumericValue < 14.0;
IWorkbook myWorkBook = SpreadsheetExtension.GetCurrentDocument("Spreadsheet");
int test = Convert.ToInt32(myWorkBook.Worksheets[0].Cells["B3"].Value.NumericValue);
return Json(test);
' Create a function specifying the condition to remove worksheet rows.
Dim rowRemovalCondition As System.Func(Of Integer, Boolean) = Function(x) worksheet.Cells(CInt((x)), CInt((0))).Value.NumericValue > 3.0 AndAlso worksheet.Cells(CInt((x)), CInt((0))).Value.NumericValue < 14.0
' Fill cells with data.
' and less than 14, remove the corresponding row.
Dim rowRemovalCondition As Func(Of Integer, Boolean) = Function(x) worksheet.Cells(x, 0).Value.NumericValue > 3.0 AndAlso worksheet.Cells(x, 0).Value.NumericValue < 14.0
Dim myWorkBook As IWorkbook = SpreadsheetExtension.GetCurrentDocument("Spreadsheet")
Dim test As Integer = Convert.ToInt32(myWorkBook.Worksheets(0).Cells("B3").Value.NumericValue)
Return Json(test)
See Also