Hello guys,
i have a problem with excel generated by kendo grid.
In my scenario, the exported file is uploaded, and processed using a OleDbConnection, with the driver Provider=Microsoft.ACE.OLEDB.12.0;Data Source=file.xlsx;Extended Properties=Excel 12.0.
With this file, and only with files generated by kendo, I always get this error:
"External table is not in expected format".
With excel files created manually, i have no problems.
I tried to change the type of driver, but it was useless.
Any ideas?
Thank you