CellValueConversionErrorEventArgs.Action Property

Specifies the action performed after the DataTableExporter.CellValueConversionError event is handled.

Namespace: DevExpress.Spreadsheet.Export

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public DataTableExporterAction Action { get; set; }

VB.NET

Public Property Action As DataTableExporterAction

Property Value

Type	Description
DataTableExporterAction	A DataTableExporterAction enumeration member.

Available values:

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 GitHub Examples

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

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

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

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

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

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

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

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

VB.NET

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

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

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

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

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

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

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

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