IXlCell.Value Property

Gets or sets a cell value.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

XlVariantValue Value { get; set; }

VB.NET

Property Value As XlVariantValue

Property Value

Type	Description
XlVariantValue	An XlVariantValue object.

Remarks

A value contained in a cell is specified by the XlVariantValue object. The Value property provides the access to this object.

To set a cell value, you can assign the Value property to an object of the System.String, System.DateTime, System.Boolean or any numeric type (System.Int32, System.Double, etc.). To use an object of any type for specifying a cell value, use the XlVariantValue.FromObject method, which converts the passed object to XlVariantValue using the default converter.

If a cell does not contain any data, the Value property returns an empty value object (XlVariantValue.IsEmpty is true).

Use the IXlCell.SetFormula method overloads to assign a formula to a cell to calculate its value dynamically. See the How to: Create a Cell Formula example.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

GeneralActions.cs

// Create a worksheet.
using (IXlSheet sheet = document.CreateSheet()) {
    // Create the column A and set its width. 
    using (IXlColumn column = sheet.CreateColumn()) {
        column.WidthInPixels = 150;
    }

    // Create the first row.
    using (IXlRow row = sheet.CreateRow()) {

        // Create the cell A1 and set its value.
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = "Numeric value:";
        }

        // Create the cell B1 and assign the numeric value to it.
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = 123.45;
        }
    }

    // Create the second row.
    using (IXlRow row = sheet.CreateRow()) {

        // Create the cell A2 and set its value.
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = "Text value:";
        }

        // Create the cell B2 and assign the text value to it.
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = "abc";
        }
    }

    // Create the third row.
    using (IXlRow row = sheet.CreateRow()) {

        // Create the cell A3 and set its value.
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = "Boolean value:";
        }

        // Create the cell B3 and assign the boolean value to it.
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = true;
        }
    }

    // Create the fourth row.
    using (IXlRow row = sheet.CreateRow()) {

        // Create the cell A4 and set its value.
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = "Error value:";
        }

        // Create the cell B4 and assign an error value to it.
        using (IXlCell cell = row.CreateCell()) {
            cell.Value = XlVariantValue.ErrorName;
        }
    }
}

GeneralActions.vb

' Create a worksheet.
Using sheet As IXlSheet = document.CreateSheet()
    ' Create the column A and set its width. 
    Using column As IXlColumn = sheet.CreateColumn()
        column.WidthInPixels = 150
    End Using

    ' Create the first row.
    Using row As IXlRow = sheet.CreateRow()

        ' Create the cell A1 and set its value.
        Using cell As IXlCell = row.CreateCell()
            cell.Value = "Numeric value:"
        End Using

        ' Create the cell B1 and assign the numeric value to it.
        Using cell As IXlCell = row.CreateCell()
            cell.Value = 123.45
        End Using
    End Using

    ' Create the second row.
    Using row As IXlRow = sheet.CreateRow()

        ' Create the cell A2 and set its value.
        Using cell As IXlCell = row.CreateCell()
            cell.Value = "Text value:"
        End Using

        ' Create the cell B2 and assign the text value to it.
        Using cell As IXlCell = row.CreateCell()
            cell.Value = "abc"
        End Using
    End Using

    ' Create the third row.
    Using row As IXlRow = sheet.CreateRow()

        ' Create the cell A3 and set its value.
        Using cell As IXlCell = row.CreateCell()
            cell.Value = "Boolean value:"
        End Using

        ' Create the cell B3 and assign the boolean value to it.
        Using cell As IXlCell = row.CreateCell()
            cell.Value = True
        End Using
    End Using

    ' Create the fourth row.
    Using row As IXlRow = sheet.CreateRow()

        ' Create the cell A4 and set its value.
        Using cell As IXlCell = row.CreateCell()
            cell.Value = "Error value:"
        End Using

        ' Create the cell B4 and assign an error value to it.
        Using cell As IXlCell = row.CreateCell()
            cell.Value = XlVariantValue.ErrorName
        End Using
    End Using
End Using

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.

C#

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L212

using (IXlCell cell = row.CreateCell()) {
    cell.Value = "SALES ANALYSIS 2014";
    cell.Formatting = formatting;

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/CS/XLExportExample/Form1.cs#L206

using (IXlCell cell = row.CreateCell()) {
    cell.Value = "LIST OF EMPLOYEES";
    cell.Formatting = formatting;

excel-export-library-generate-sales-analysis-report/CS/XLExportExample/Form1.cs#L216

using (IXlCell cell = row.CreateCell()) {
    cell.Value = "SALES 2014";
    cell.Formatting = formatting;

excel-export-api-examples/CS/XLExportExamples/SpreadsheetActions/MiscellaneousActions.cs#L103

using(IXlCell cell = row.CreateCell()) {
    cell.Value = "You can view document properties using the File->Info->Properties->Advanced Properties dialog.";
}

excel-export-library-generate-an-invoice/CS/XLExportExample/Form1.cs#L432

using (IXlCell cell = row.CreateCell()) {
    cell.Value = columnName;
    cell.ApplyFormatting(headerRowFormatting);

VB.NET

excel-export-library-generate-sales-report/VB/XLExportExampleSalesReport/Form1.vb#L224

Using cell As IXlCell = row.CreateCell()
    cell.Value = "SALES ANALYSIS 2014"
    cell.Formatting = formatting

how-to-use-the-excel-export-api-to-generate-a-list-of-employees/VB/XLExportExample/Form1.vb#L143

Using cell As IXlCell = row.CreateCell()
    cell.Value = department
End Using

excel-export-library-generate-sales-analysis-report/VB/XLExportExample/Form1.vb#L200

Using cell As IXlCell = row.CreateCell()
    cell.Value = "SALES 2014"
    cell.Formatting = formatting

excel-export-api-examples/VB/XLExportExamples/SpreadsheetActions/MiscellaneousActions.vb#L106

Using cell As IXlCell = row.CreateCell()
    cell.Value = "You can view document properties using the File->Info->Properties->Advanced Properties dialog."
End Using

excel-export-library-generate-an-invoice/VB/XLExportExample/Form1.vb#L445

Using cell As IXlCell = row.CreateCell()
    cell.Value = columnName
    cell.ApplyFormatting(headerRowFormatting)