Loading from XLSIO into Spreadsheet control without saving the physical file

[Louis Miles]

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]

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.