Export smart tree table data to excel sheet in sap Ui5/FIORI

[anandprakash_rai2]

Hi Experts,

I am using smart table with table type as Tree. I am using Export to Spreadsheet button (out of box functionality) to export my hierachial data to excel.

Issue is- The data gets exported into excel sheet but not in correct hierarchy level.

Can you please let me know how to achieve this so that my exported data comes in correct hierachy level in excelsheet

[former_member747896]

I am facing similar issue. Could you please tell what is the solution?

[former_member333321]

Facing same issue did you find any solution?

It seems when we have multiple childrens at level 0 is a problem. I used alternate approach to have 1 fixed item at level 0 and below it display all items

[raina_goyal]

Hi Sagar,

Could you please share the code , how did you achieved it , I am facing similar issues and I need it urgently.

Please help.

Thanks,

Best Regards,

Raina

[former_member793415]

Hi, I have tried the same. I have used the smart Tree Table with Gantt Chart and the out of the box Excel Button. I have customized my columns like the following:

<t:customData> <co:CustomData key="exportTableColumnConfig" value='{"columnKey": "BezeichnungDe", "leadingProperty":"BezeichnungDe", "dataType": "string", "hierarchyLevel": "Hierarchie", "wrap": true}' /></t:customData>Excel Export works, but I only get all Elements on the first root hierarchie level in my export. In the attribute "Hierarchie" the level of the items is saved. Tree Table looks good but how can I achieve that all levels will be export to excel?Thanks for help!Kind regardsKatrin