CellValueConversionErrorEventArgs.DataTableValue Property

Gets or sets a value contained in the target DataTable.

Namespace: DevExpress.Spreadsheet.Export

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public object DataTableValue { get; set; }

VB.NET

Public Property DataTableValue As Object

Property Value

Type	Description
Object	An object to be placed in the target DataTable.

Remarks

Use the DataTableValue property to populate the target DataTable if an attempt to convert a source cell value is unsuccessful.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataTableValue 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#

spreadsheet-document-api-export-worksheet-range-to-datatable/CS/ExportToDataTableWorkbookExample/Form1.cs#L46

MessageBox.Show("Error in cell " + e.Cell.GetReferenceA1());
e.DataTableValue = null;
e.Action = DataTableExporterAction.Continue;

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

MessageBox.Show("Error in cell " + e.Cell.GetReferenceA1());
e.DataTableValue = null;
e.Action = DataTableExporterAction.Continue;

asp-net-mvc-grid-upload-and-display-excel-file/CS/UploadControlApplication/Models/HelperClass.cs#L26

    e.Action = DataTableExporterAction.Continue;
    e.DataTableValue = null;
}

asp-net-web-forms-grid-upload-and-display-excel-file/CS/Solution/Default.aspx.cs#L36

    e.Action = DataTableExporterAction.Continue;
    e.DataTableValue = null;
}

VB.NET

spreadsheet-document-api-export-worksheet-range-to-datatable/VB/ExportToDataTableWorkbookExample/Form1.vb#L51

MessageBox.Show("Error in cell " & e.Cell.GetReferenceA1())
e.DataTableValue = Nothing
e.Action = DataTableExporterAction.Continue

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

Call MessageBox.Show("Error in cell " & e.Cell.GetReferenceA1())
e.DataTableValue = Nothing
e.Action = DataTableExporterAction.Continue

asp-net-mvc-grid-upload-and-display-excel-file/VB/UploadControlApplication/Models/HelperClass.vb#L20

    e.Action = DataTableExporterAction.Continue
    e.DataTableValue = Nothing
End Sub

asp-net-web-forms-grid-upload-and-display-excel-file/VB/Solution/Default.aspx.vb#L42

    e.Action = DataTableExporterAction.Continue
    e.DataTableValue = Nothing
End Sub