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.