Loading from XLSIO into Spreadsheet control without saving the physical file

Question

Hi there,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.Many thanks.

Sangeetha Priya Murugan · Answer

Hi Louis,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.https://www.syncfusion.com/kb/11970/how-to-open-and-save-an-excel-file-to-server-in-the-spreadsheet
https://help.syncfusion.com/file-formats/xlsio/loading-and-saving-workbook#opening-an-existing-workbook
https://ej2.syncfusion.com/aspnetcore/documentation/spreadsheet/open-save
Please check the above links and
create the excel file using XLSIO instance and open the created stream in
spreadsheet using server side open method.