This is a migrated thread and some comments may be shown as answers.

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

1 Answer 231 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Callam
Top achievements
Rank 1
Veteran
Callam asked on 10 Aug 2020, 02:40 PM

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

1 Answer, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 12 Aug 2020, 02:36 PM

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

Tags
Spreadsheet
Asked by
Callam
Top achievements
Rank 1
Veteran
Answers by
Martin
Telerik team
Share this question
or