How to import excel file to the grid?

Question

How to add a toolbar button to import an excel file to the grid or replace all the grid data?

Rajapandiyan Settu · Answer

Hi dosnivy, 

Greetings from syncfusion support. 

Query : How to add a toolbar button to import an excel file to the grid or replace all the grid data? 

From your query we could see that you need to load excel file data into the Grid. In EJ2 Grid there is no support for loading Excel file data as grid’s dataSource.By default the grid supports only the javascript array of Objects. We can able to bind both local and remote data to the grid. Please refer the below documentation for more information. 
 
Sample : https://ej2.syncfusion.com/react/documentation/grid/data-binding/ 
 
Please get back to us if you need further assistance on this. 
 
Regards, Rajapandiyan S.

Stefan · Answer

Hello, i am trying to do kind of the same thing. My goal is to load in a excel file in order to replace/update the data in the grid.

In my project (electron desktop app) the datasource is a sql database. Because editing all data in the grid itself is a bit time consuming, i would like to export the selected rows to excel, edit them there and import them back into the table.

Then the table should show the modified rows. After that, i click on the "Update" button of the toolbar and the changes should persist in my database.

Is there any solution to this? I appreciate every kind of help.

Thanks in advance!

Stefan

Rajapandiyan Settu · Answer

Hi Stefan 

Thanks for your update. 

Query : i am trying to do kind of the same thing. My goal is to load in a excel file in order to replace/update the data in the grid. 

As already said in the previous response, there is no support to import the Excel data into grid. EJ2 grid only accepts the data of JSON object.  

Please get back to us if you need further assistance on this. 

Regards, 
Rajapandiyan S