Kendo Spreadsheet adding data second sheet

4 posts, 0 answers
  1. Frank
    Frank avatar
    86 posts
    Member since:
    Mar 2012

    Posted 17 Aug Link to this post

    Right now I have and Active Sheet and inactive sheet. Onclick I load data for the the Active sheet.  I understand how to create another sheet tab name. Is there any documentation on  Loading data to the second sheet or syntax.

    Active Sheet >>>>  var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
            var sheet = spreadsheet.activeSheet();

    sheet.range("D6:I6").values(column);

    InActive Sheet >>>>  var spreadsheet 2= $("#spreadsheet").data("kendoSpreadsheet");
            var sheet2 = spreadsheet.InactiveSheet();
    sheet2.range("D6:I6").values(newcolumn);

  2. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 19 Aug Link to this post

    Hello Frank,

    The sheets method returns a list of all sheets. The inactive ones are the ones that are different than the active sheet.

    Regards,
    Alex Gyoshev
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  3. Kendo UI is VS 2017 Ready
  4. Frank
    Frank avatar
    86 posts
    Member since:
    Mar 2012

    Posted 19 Aug Link to this post

    I do not think you understand what I am trying to do. The inactive sheet I need to bind to also.
  5. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 22 Aug Link to this post

    Hello Frank,

    You can loop through the sheets and call the setDataSource method to bind them to a data source. There is no inactiveSheet method, because there may be more than one inactive sheets.

    Regards,
    Alex Gyoshev
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
Back to Top
Kendo UI is VS 2017 Ready