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

[Callam]

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 :)

[Martin]

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