This is a migrated thread and some comments may be shown as answers.

Populate one spreadsheet worksheet with more than one data source

1 Answer 23 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Tony
Top achievements
Rank 1
Tony asked on 30 Jan 2019, 11:13 AM

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. 

1 Answer, 1 is accepted

Sort by
0
Marin Bratanov
Telerik team
answered on 01 Feb 2019, 07:55 AM
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
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Spreadsheet
Asked by
Tony
Top achievements
Rank 1
Answers by
Marin Bratanov
Telerik team
Share this question
or