Populate one spreadsheet worksheet with more than one data source

[Tony]

Hi there. I'm new to the spreadsheet component and was wondering the following. Am I able to take two javascript arrays (converted to json) and populate one starting in cell B2 and populate the other starting in cell J5, for example?  I couldn't find a way to dictate the starting cell using 'datasource' and couldn't find a way to add multiple data sets into one worksheet. Thanks. 

[Marin Bratanov]

Hi Tony,

You can use the values() method of the range to set data in a spreadsheet. It can be invoked from the callback/done() of a promise that fetches the data from the service/data source that you have. There are a couple of different ways to get a reference to the sheet so you can create a range on it, for example, the .activeSheet() method of the widget is the most straightforward and commonly used.

Here is an example that can help get you started: https://dojo.telerik.com/@bratanov/AvoQUxiM.

Regards,
Marin Bratanov
Progress Telerik