Import data from multiple excel files into different tabs in one kendo spreadsheet workbook

2 posts, 0 answers
  1. Callam
    Callam avatar
    7 posts
    Member since:
    Oct 2019

    Posted 10 Aug 2020 Link to this post

    Hi, is it possible to do this? It is easy to import the data from one excel workbook (using the fromFile method), but then I would like to allow the user to load in data from additional excel workbooks and have the data display on new tabs of the kendo workbook. At the moment, each additional import overwrites the previous one.

     

    Thanks for any help :)

  2. Martin
    Admin
    Martin avatar
    317 posts

    Posted 12 Aug 2020 Link to this post

    Hello Callam,

    A possible approach would be to bind to the excelImport event and convert the file to a JSON object, so that it can be assigned to a dataSource. You can dynamically add a new sheet to the component and use the setDataSource to bind the data. Here is a small example to demonstrate the suggestion. I would recommend a careful testing if using that or similar approach, as that is not a built-in feature.

    Let me know how that works for you.

    Regards,
    Martin
    Progress Telerik

Back to Top