Real-time chart update with datasource from spreadsheet

[Claudio]

Good morning,

we would need to create a Telerik chart that takes data from a spreadsheet placed on the same page, to expect a real-time update of the chart when editing the spreadsheet.

Is it possible to implement this kind of solution or a variant of it that allows to update the chart as the data in the spreadsheet changes (without reloading the page)?

 

Kind regards,

[Nikolay]

Hello Claudio,

I recommend using a shared data source for both the Spreadsheet and the Chart. Once a change is performed in the Spreadsheet this will reflect the Chart and it will rebound itself with the new data.

https://docs.telerik.com/kendo-ui/framework/datasource/overview#shared-datasource

Alternatively, you could subscribe to the change event of the Spreadsheet, obtain its data source and apply it to the Chart with the setDataSource method.

Regards,

Nikolay
Progress Telerik