How to reload data into spreadsheet?

[Philip]

Please see this sample code I have, I am trying to reload data from a remote server into the spreadsheet with every click of the button.

The issue is after clicking the search button a second  time to fetch new data, the spreadsheet is appended with a new one.

What is the proper way to reload data into the spreadsheet?

Link to sample code
https://dojo.telerik.com/ewigOKam

[Neli]

Hi Philip,

I have just replied in the other thread on the same topic. For convenience, I will paste my reply here below as well. I would recommend keeping the conversation in a single thread. 

 

The observed issue is caused by the fact, that when the "Search" button is clicked, another Spreadsheet will be initialized. 

To avoid this you could perform an additional check if the widget has been initialized. This way you could initialize it only if it is needed. Then you could load the dataSource as per the requirements. 

       var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
        
        if(!spreadsheet){
        	 $("#spreadsheet").kendoSpreadsheet();
          	spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
        }         
        
        var sheet = spreadsheet.activeSheet();
        sheet.setDataSource(dataSource);

 Here is the modified Dojo example.

I hope, that the above helps you. In case you have any other questions, please do not hesitate to contact us.

 

Regards,
Neli
Progress Telerik

[Pistle]

Refresh an external data connection-
Update only the selected data Press ALT+F5, or on the Data tab, in the Queries & Connections group, click the arrow under Refresh All, and then click Refresh.
Update all data in the workbook Press CTRL+ALT+F5, or on the Data tab, in the Queries & Connections group, click Refresh All.

I hope this will be helpful.

Best Regards