Kendo Spreadsheet with Complex type

[svkrishna]

Hi,
we have a complex type like below.
Item1
Item2
      SubItem1
      SubItem2
Item3
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.

[Veselin Tsvetanov]

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.

Regards,
Veselin Tsvetanov
Progress Telerik