Hi William,
Query #1: Loading CSV files in demo site
For
demonstration purposes, we published our web service open/save action
and mentioned it in our demo site.You can use this demo URL on your end
as well, or you can use a local service for open and save actions. And
we have published our API services in the GitHub location; for more
details, please refer to the below links.
Service sample Location: https://github.com/SyncfusionExamples/EJ2-Spreadsheet-WebServices/
https://ej2.syncfusion.com/react/documentation/spreadsheet/open-save/
You can use the above web service for open/save actions to resolve performance issues on your end.
To create the local web service, please refer to the below link.
https://www.syncfusion.com/kb/13200/how-to-remove-trial-version-tab-created-in-spreadsheet
Query #2: To save/retrieve the spreadsheet as JSON in data base
Your requirement can be achieved in our spreadsheet by using the openFromJson and saveAsJson methods. We have already demonstrated this in our KB documentation itself. You can refer to the below link.
Load and save Spreadsheet as Byte array in Data Base:
https://www.syncfusion.com/kb/11971/how-to-save-and-retrieve-the-spreadsheet-data-as-a-byte-array-in-the-database
Load and save spreadsheet as JSON in Data base:
https://www.syncfusion.com/kb/11956/how-to-save-and-retrieve-the-spreadsheet-data-as-json-in-database
Load and save spreadsheet cell data in SQL Table:
https://www.syncfusion.com/kb/12575/how-to-load-and-save-a-sql-table-in-spreadsheet-using-cellsave-event
To save/open the excel file in server, please refer to the below link.
https://www.syncfusion.com/kb/11970/how-to-open-and-save-an-excel-file-to-server-in-the-spreadsheet
API Links:
https://ej2.syncfusion.com/documentation/api/spreadsheet/#saveasjson
https://ej2.syncfusion.com/documentation/api/spreadsheet/#openfromjson
Please get back to us, if you need any further assistance with this.
