We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Slow load csv files

Your demo is very slow at loading csv files.  I know its a big accomplishment just to load them but working with files in my opinion needs to be faster to be useful to the end user because they would leave the page when bored.  With that said how should I save the data for it to load faster?  Your control is awesome.  Even when I upload files and read them using the XLSX.js component for the datagrid it's slow but if I read data from a database it's blazing fast.  So do you recommend that I save my csv file's in a db and create a JSON object to load?  Anything special about how to structure?  Will it create the columns automatically if I don't identify them?


Thanks



3 Replies 1 reply marked as answer

SP Sangeetha Priya Murugan Syncfusion Team November 22, 2022 06:34 AM

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.


Marked as answer

WM William Morgenweck November 22, 2022 07:08 AM

This is fantastic-  Thank you




SP Sangeetha Priya Murugan Syncfusion Team November 23, 2022 08:12 AM

You're welcome, William. Please feel free to contact us if you need any other assistance.

NOTE: If that post is helpful, please consider accepting it as the solution so that other members can locate it more quickly.


Loader.
Live Chat Icon For mobile
Up arrow icon