Problem with Cells.ExportDataTable - skipErrorValue

Hi

I am trying to load data from Excel into SQL Server.

When there are invalid values in Excel, like a text value in a decimal field, the exportDataTable method thorws out an error. I tried using the skipErrorValue parameter but its only available for overloaded methods where there is a pre-defined data table.

Is there a way to use SkipErrorValue with method that returns a dataTable

I am using the following statement to get the dataTable object but its failing due to some invalid values.

DataTable dataTable = worksheet.Cells.ExportDataTable(0, 0, dataRows, dataCols, true);

Is there any plan to add skipErrorValue param to this overloaded method.

Thanks

Hi,

We have logged your feature request into our issue tracking system with an issue id: CELLSNET-14617. We will support it soon.

Thank you.

Hi,


We have supported this property.Please check the following code with the attached version:

Cells cells = wb.Worksheets[0];

ExportTableOptions options = new ExportTableOptions();

options.SkipErrorValue = true;

Cells.ExportDataTable(0, 0, 10, 10,

options);


Thank you.

The issues you have found earlier (filed as 14617) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.