For saving the data along with formulas do we need the services ? what's the scenario for sensitive data ?

We have the services URL : 

 https://services.syncfusion.com/react/production/api/spreadsheet/save

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

In case of sensitive data , we cant use the external services API/URL


DO we really need this ?

Can we save the spread sheet with out using the services API ? 


1 Reply

VR Vasanth Ravi Syncfusion Team November 13, 2023 04:49 PM UTC

Hi Dhana,


Thanks for contacting Syncfusion support...!


You can’t be able to export the spreadsheet without using the service API.


And to answer your query – 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.


https://services.syncfusion.com/react/production/api/spreadsheet/save


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.


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 


Regarding create local service:


We have created import and export server actions alone in the .Net framework with C# programming. Other functionalities are coded with JavaScript. You can also create those in local service. To create local service with step-by-step process, check with the below attached KB for more details.


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


GitHub Link: https://github.com/SyncfusionExamples/EJ2-Spreadsheet-WebServices/tree/main/WebAPI


For your reference we have also created a local service and added the local service URLs for import and export actions on the client end. Refer to the below attached links.


Stackblitz Sample: https://stackblitz.com/edit/react-cninlc-rjb7tg?file=index.js


Local service link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/WebAPI-180057562


Get back to us if you need any other further clarifications.


Loader.
Up arrow icon