CellValueToColumnTypeConverter.EmptyCellValue Property

Gets or sets a value used when exporting an empty cell.

Namespace: DevExpress.Spreadsheet.Export

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public CellValue EmptyCellValue { get; set; }

VB.NET

Public Property EmptyCellValue As CellValue

Property Value

Type	Description
CellValue	A CellValue object that is the cell value. Default is CellValue.Empty.

Remarks

Use the EmptyCellValue property to specify a cell value used for exporting when an empty cell is processed.

If the DataTableExportOptions.ConvertEmptyCells property is set to false, the EmptyCellValue is not used.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the EmptyCellValue 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#

how-to-export-cell-range-to-a-datatable/CS/ExportToDataTableExample/Form1.cs#L110

exporter.Options.ConvertEmptyCells = true;
exporter.Options.DefaultCellValueToColumnTypeConverter.EmptyCellValue = 0;
exporter.Options.DefaultCellValueToColumnTypeConverter.SkipErrorValues = barCheckItemSkipErrors.Checked;

VB.NET

how-to-export-cell-range-to-a-datatable/VB/ExportToDataTableExample/Form1.vb#L104

exporter.Options.ConvertEmptyCells = True
exporter.Options.DefaultCellValueToColumnTypeConverter.EmptyCellValue = 0
exporter.Options.DefaultCellValueToColumnTypeConverter.SkipErrorValues = barCheckItemSkipErrors.Checked

Implements

EmptyCellValue