Hello,
The following code works well if all data is double:
Range range = ws.Cells.CreateRange(ltCell,rbCell);
DataTable dataTable = ws.Cells.ExportDataTable(range.FirstRow, range.FirstColumn,
range.RowCount, range.ColumnCount, false);
Now I need to skip error values:
ExportTableOptions exportTableOptions = new ExportTableOptions();
exportTableOptions.ExportColumnName = false;
exportTableOptions.SkipErrorValue = true;
DataTable dataTable = ws.Cells.ExportDataTable(range.FirstRow, range.FirstColumn,
range.RowCount, range.ColumnCount, exportTableOptions);
And code doesn’t work.
If I change ExportColumnName to true than code works well but without first row.
exportTableOptions.ExportColumnName = true;
My test excel is simple:
A B C D
11 | 12 | x | 14 |
21 | - |
23 | 24 |
What should I do?
Paul