kendoGrid saveAsExcel file is not accessible with oleDb

2 posts, 0 answers
  1. Roberto
    Roberto avatar
    8 posts
    Member since:
    Mar 2015

    Posted 20 Dec 2016 Link to this post

    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

  2. Konstantin Dikov
    Konstantin Dikov avatar
    2466 posts

    Posted 21 Dec 2016 Link to this post

    Hi Roberto,

    Please refer to the following forum thread, where the same error is discussed:

    Best Regards,
    Konstantin Dikov
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top