Hi xu zhi bin,
We have done the Open/ Save (server side) functionality in ASP.NET. By using the Syncfusion XLSIO library we have converted the excel file to our supported JSON format in server side. And currently, we don’t have client side save action in our EJ2 Spreadsheet. However, you can use our client side save method to export the spreadsheet as excel file, by specifying the server-side saveUrl for save action.
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/
Save API link: https://ej2.syncfusion.com/vue/documentation/api/spreadsheet/#save
For more details, please refer to the below links.
https://ej2.syncfusion.com/vue/documentation/spreadsheet/open-save
Meanwhile we have also provided option to open/save the spreadsheet data in JSON format using openFromJson and saveAsJson method. Please refer the below API links.
API Links:
https://ej2.syncfusion.com/vue/documentation/api/spreadsheet/#openfromjson
https://ej2.syncfusion.com/vue/documentation/api/spreadsheet/#saveasjson
Please check the above links and get back to us, if you need any further assistance on this.
Do I have to rely on the server? That would waste unnecessary bandwidth and performance on the server
Hi Xu Zhi Bin,
We have written the server in C# with ASP .Net MVC and ASP .Net Core framework and we will not keep the track or trace of the files that are being managed from this service.
We convert the whole workbook model to JSON data when the export action is triggered. And send that whole JSON from the client side to the server side. On the server side, we have used our Syncfusion XLSIO library to convert the workbook model to an XLSIO-supported format to export it as an Excel file. On execution of this process, the server will not keep any trace of the data within it thus by restricting the data leak.
Therefore, you can deploy the service provided by us for importing and exporting functionalities with at most reliable.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Currently, we don’t have support for client side excel import & export in spreadsheet (Node JS). However, we have confirmed this as an improvement and logged it as a feature. It will be available in any of our upcoming releases. You can communicate and track the status of the feature using the below link from our feedback portal.
Feedback Portal Link: https://www.syncfusion.com/feedback/18431/need-to-provide-support-for-client-side-importing-in-spreadsheet
Currently, we have provided support to load the JSON in spreadsheet in client side. Please refer the below API links for more details.
https://ej2.syncfusion.com/vue/documentation/api/spreadsheet/#openfromjson
https://ej2.syncfusion.com/vue/documentation/api/spreadsheet/#saveasjson
Get back to us if you need any other further clarifications.
This idea is great, but your server may not be suitable for China and the internet speed may be slow. Thank you, I already understand.
Please get back to us if you need any other assistance.