Is there an API similar to C # that exports data to Excel format?

Is there an API similar to C # that exports data to Excel format?




5 Replies

SP Sangeetha Priya Murugan Syncfusion Team September 25, 2023 12:35 PM UTC

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 Locationhttps://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.



XZ xu zhi bin replied to Sangeetha Priya Murugan October 11, 2023 10:01 AM UTC

Do I have to rely on the server? That would waste unnecessary bandwidth and performance on the server





VR Vasanth Ravi Syncfusion Team November 14, 2023 06:10 PM UTC

 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 Linkhttps://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.



XZ xu zhi bin replied to Vasanth Ravi November 15, 2023 12:59 AM UTC

 

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.





SP Sangeetha Priya Murugan Syncfusion Team November 20, 2023 07:07 AM UTC

Please get back to us if you need any other assistance.


Loader.
Up arrow icon