Functional Component for Spreadsheet

I want to load/save data from Calendar using Functional component to database. Any Axios/Fetch API example will be very helpful as I am using React.js


1 Reply 1 reply marked as answer

SP Sangeetha Priya Murugan Syncfusion Team September 21, 2022 06:58 AM UTC

Hi Salokya,


We suspect that you need to load/save the excel file from the database by using the spreadsheet component. And it can be achievable in our spreadsheet by using the import/export functionality. For more details regarding this support. Please refer the below links.


Demo Link: https://ej2.syncfusion.com/react/demos/#/bootstrap5/spreadsheet/default


If you need to perform open/save action in spreadsheet, you need to provide the open server action link in openUrl property. For more details regarding open/save feature please refer the below link.


https://ej2.syncfusion.com/react/documentation/spreadsheet/open-save/


And for demo purpose we have published our web service open/save action and mentioned in our demo site. You can also use this demo url in your end or else you can use local service for open/save action.
And we have published our API services in the GitHub location, for more details please refer the below links.


Service sample Location: https://github.com/SyncfusionExamples/EJ2-Spreadsheet-WebServices/


For local service creation, please refer the below link.


https://www.syncfusion.com/kb/13200/how-to-remove-trial-version-tab-created-in-spreadsheet


We can be able to store the spreadsheet data in database in different ways. Please refer the below links for more details.


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 excel file 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


Related Forum Link: https://www.syncfusion.com/forums/177067/spreadsheet-open-an-external-url-file-example-as-a-functional-component


Could you please check the above links and get back to us, if you need any further assistance on this.


Regards,

Sangeetha M


Marked as answer
Loader.
Up arrow icon