The DataTable.ImportSheet Error
I need to verify content of Excel file exported from application.
When I'm trying to import it to Datatable it gives an error:"The DataTable.ImportSheet operation failed. String too long"
Excel file has 2 rows and 20 columns.
Any solutions how to ferify excel file content or get it imported in Datatable?
Re: The DataTable.ImportSheet Error
Just create an excel object and work directly with the excel sheet rather than importing.