DataTableExporterAction Enum

Lists possible actions which can be specified in the DataTableExporter.CellValueConversionError event handler.

Namespace: DevExpress.Spreadsheet.Export

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

Declaration

C#

public enum DataTableExporterAction

VB.NET

Public Enum DataTableExporterAction

Members

Name	Description
Continue	Continue export procedure and proceed to the next cell.
SkipRow	Do not export the current cell and skip the entire row.
Stop	Stop the export procedure and cancel export of the current row.

Related API Members

The following properties accept/return DataTableExporterAction values:

• CellValueConversionErrorEventArgs.Action
• ProcessEmptyRowEventArgs.Action

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DataTableExporterAction enum.

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-e4997/CS/ExportToDataTableExample/Form1.cs#L78

// Handle value conversion errors.
exporter.CellValueConversionError += (sender,args)=> {args.Action = DataTableExporterAction.Continue;};
if (stopOnEmptyRow) {

how-to-export-worksheet-range-to-a-datatable-without-spreadsheetcontrol-t482311/CS/ExportToDataTableWorkbookExample/Form1.cs#L45

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

gridview-how-to-upload-an-excel-file-via-uploadcontrol-and-show-its-data-in-a-grid-t576892/CS/UploadControlApplication/Models/HelperClass.cs#L27

void exporter_CellValueConversionError(object sender, CellValueConversionErrorEventArgs e) {
    e.Action = DataTableExporterAction.Continue;
    e.DataTableValue = null;

VB.NET

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

' Handle value conversion errors.
AddHandler exporter.CellValueConversionError, Sub(sender,args) args.Action = DataTableExporterAction.Continue
If stopOnEmptyRow Then

how-to-export-worksheet-range-to-a-datatable-without-spreadsheetcontrol-t482311/VB/ExportToDataTableWorkbookExample/Form1.vb#L49

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

gridview-how-to-upload-an-excel-file-via-uploadcontrol-and-show-its-data-in-a-grid-t576892/VB/UploadControlApplication/Models/HelperClass.vb#L27

Private Sub exporter_CellValueConversionError(ByVal sender As Object, ByVal e As CellValueConversionErrorEventArgs)
    e.Action = DataTableExporterAction.Continue
    e.DataTableValue = Nothing