How to save the updated spreadsheet data as JSON in database

Question

Hi,How can I save updated cell data from my spreadsheet in my db? Do you have an example of how it can be done? For Angular 5 and above.What I need to achieve is, Fetching the data from database, and then update that retrieve data from spreadsheet and then need to save the updated data in JSON format, directly in database.

Sangeetha Priya Murugan · Accepted Answer

Hi Shadman, 
 
Thank you for contacting Syncfusion support. 
 
We have checked your reported requirement and we would like to let you know that it can be achievable in our spreadsheet by using the openFromJson and saveAsJson method. We have already demonstrated this in our knowledge base section itself. In this we have saved the spreadsheet data as jsonobject in database and open the saved jsonobject in spreadsheet. Please find the link below. 
 
https://www.syncfusion.com/kb/11956/how-to-save-and-retrieve-the-spreadsheet-data-as-json-in-database 
 
Could you please check the above details and get back to us, if you need any further assistance on this. 
 
Regards, 
Sangeetha M