We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Loading from XLSIO into Spreadsheet control without saving the physical file

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.

1 Reply

SP Sangeetha Priya Murugan Syncfusion Team March 14, 2023 11:42 AM UTC

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.




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.

Live Chat Icon For mobile
Up arrow icon