Import data from excel to kendo grid

1 Answer 1503 Views
File Saver Upload
Arun
Top achievements
Rank 1
Iron
Arun asked on 15 Feb 2022, 10:53 AM

Hi Team,

I have a upload scenario, where I need to import a data from file type like .xlsx,.xlsm.. and do a validation and bind a data to kendo react  grid directly, Do we have a inbuilt import  function in kendo react grid ? can you please help on that would be helpful.

 

Note: No need to save a data in any server, after the validation, data will be saved from grid.

 

 

 

 

Regards,

Arun

1 Answer, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 15 Feb 2022, 11:03 AM

Hello, Arun,

Currently, this has to be done on the application level. The Grid only displays the data with importing or validating it.

We have an example that shows a possible approach to use our Upload component to get the data and pass it to the Grid:

https://stackblitz.com/edit/react-rogirv-luwxj3?file=app/main.jsx

After getting the data, you can do the validation before passing the data to the Grid.

Regards,
Stefan
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Digu
Top achievements
Rank 1
commented on 26 Jul 2022, 09:24 AM

Hi,Stefan,

Is this functionality is possible in angular ?

Konstantin Dikov
Telerik team
commented on 27 Jul 2022, 08:36 PM

Hi Digu,

The KendoUI for Angular Upload has "rawFile" information too (within the "select" event https://www.telerik.com/kendo-angular-ui/components/uploads/upload/events/), so you should be able to use the approach demonstrated in the example for reading the file and retrieving the data. Note that the example is using a third party package (xlsx).

I have checked if the package has other examples in stackblitz and I came across the following, which reads xlsx files using the third party package with angular:

Hope this helps.

Tags
File Saver Upload
Asked by
Arun
Top achievements
Rank 1
Iron
Answers by
Stefan
Telerik team
Share this question
or