Kendo Spreadsheet with Complex type

2 posts, 0 answers
  1. svkrishna
    svkrishna avatar
    1 posts
    Member since:
    Nov 2017

    Posted 11 Dec 2017 Link to this post

    we have a complex type like below.
    I need to to bind this complex to Kendo spreadsheet for jquery and need the columns like this.
    Item1 subItem1 SubItem2 Items
    Below is my code

     sheet.setDataSource(dataSource, [
                                                       { field: "Item1", title: "Item1" },
                                                       { field: "Item2.SubItem1", title: "SubItem1" },
                                                       { field: "Item2.SubItem3", title: "SubItem3" },
                                                      { field: "Item3", title: "Item3" }

    The above code is not working ..
    Please help me.
  2. Veselin Tsvetanov
    Veselin Tsvetanov avatar
    689 posts

    Posted 13 Dec 2017 Link to this post

    Hello Svkrishna,

    I am afraid, that the Kendo Spreadsheet Sheet could not be bound to a hierarchical data. What I could suggest you instead is to review the capabilities of the TreeList Kendo widget.

    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top