officefileapi-devexpress-dot-spreadsheet-dot-export-dot-cellvaluetocolumntypeconverter.md
Gets or sets a value used when exporting an empty cell.
Namespace : DevExpress.Spreadsheet.Export
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public CellValue EmptyCellValue { get; set; }
Public Property EmptyCellValue As CellValue
| Type | Description |
|---|---|
| CellValue |
A CellValue object that is the cell value. Default is CellValue.Empty.
|
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.
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.
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;
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
See Also
CellValueToColumnTypeConverter Class