I want to use the Spreadsheet control to edit some data from SQL. I was intending to use the XlsIO library to convert my SQL data into an Excel file that I could then pass to the Spreadsheet control to allow the user to edit. I don't want to (at any point) save Excel File as a physical file - I just want to pass the data between the Spreadsheet and XlsIO libraries.
Please could you provide some assistance on how this can be achieved - ideally if this demo code could also disable the ability for a user to load/save any other files that would be even better.
SPSangeetha Priya Murugan Syncfusion Team March 14, 2023 11:42 AM UTC
Your requirement can be achievable
by using our server side open/save methods. In the below documentation, we have
opened the excel file from the existing location using XLSIO library instance.
Please find the below link.