Save method

[Claudia]

GoodMornig,

I'm using RadSpreadsheet in Aspx page with SpreadsheetDocumentProvider and an Excel file.

I have create a javascript that call the save method. I write it below

function exportFile() {
var spreadsheet = $find("<%= RadSpreadsheet1.ClientID %>");
spreadsheet.save();
         }

 

Is there a post save event ( client or server side) that I can Intercept?

I would like get the file saved on server and send it to client.

Many thanks

Claudia

 

 

[Marin Bratanov]

Hi Claudia,

You could create a custom content provider where you need to implement the Save method: http://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/data-binding/providers/custom-database-provider.

Alternatively, you can save the file on the client by using the underlying Kendo Spreadsheet widget directly with JavaScript: http://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet#methods-saveAsExcel. Something like:

$telerik.$("#<%=RadSpreadsheet1.ClientID%>").data("kendoSpreadsheet").saveAsExcel();

Regards,

Marin Bratanov
Telerik by Progress

[Aaron]

I have implemented a custom provider, but the code is never called.  I don't understand where the disconnect is, as the call is supposed to be done through the control itself.

[Peter Milchev]

Hello Aaron,

When the built-in Save button in the Spreadsheet toolbar is clicked, a callback is fired which calls the SaveWorkbook method of the CustomProvider assigned to the Spreadsheet. 

If the code is not hitting the provider, probably there is a JavaScript error or a failing request. Please inspect the Console and Network tabs of the browser's DevTools:

• Inspect Network Requests

Another option is to detach the custom provider from the Spreadsheet and serialize and transfer the data manually on postback as demonstrated below:

• https://docs.telerik.com/devtools/aspnet-ajax/knowledge-base/spreadsheet-load-via-json-and-save-with-postback

Regards,
Peter Milchev
Progress Telerik