Populate one spreadsheet worksheet with more than one data source

2 posts, 0 answers
  1. Tony
    Tony avatar
    1 posts
    Member since:
    Jan 2019

    Posted 30 Jan 2019 Link to this post

    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. 

  2. Marin Bratanov
    Marin Bratanov avatar
    5792 posts

    Posted 01 Feb 2019 Link to this post

    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.

    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.
Back to Top