I am afraid, that the required scenario would not be supported by the Spreadsheet widget. As far as I can understand, you initially load data in a Spreadsheet Sheet from a database using Kendo DataSource
. Then you export that data to an xlsx file and edit that file in Excel. At the moment, when the file is imported back in the Spreadsheet, the DataSource configuration will be overridden by the data coming directly from the xlsx file. Therefore, the DataSource will no longer be available for sending and saving data back on the server.
What I could suggest you in this case would be to send the Spreadsheet data back to the server as shown on our Server import/export demo
. Then you could parse that data to a Telerik.Web.Workbook, read its contents and save it back manually in the database.