Real-time chart update with datasource from spreadsheet

1 Answer 27 Views
Charts Spreadsheet
Claudio
Top achievements
Rank 1
Iron
Iron
Claudio asked on 24 Feb 2022, 01:42 PM

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,

1 Answer, 1 is accepted

Sort by
0
Nikolay
Telerik team
answered on 01 Mar 2022, 08:37 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
Charts Spreadsheet
Asked by
Claudio
Top achievements
Rank 1
Iron
Iron
Answers by
Nikolay
Telerik team
Share this question
or