CL_GUI_ALV_TREE - is there a way to export to Excel?

[Former Member]

is there a method to export the OO tree data to Excel? specifically, I have modified report RHSTRU00. The users want to be able to download to excel.

I know it's not practical to display tree data in Excel, but we have a requirement for a headcount report and the CIO wants this output in Excel.

This report show who reports to whom and rolls up Active EEs, Vacancies, EEs on Leave, Terminated EEs, etc... by org unit all the way to the top.

thanks,

robert.

[Former Member · Accepted solution]

hello,

i have done it this way:

print preview of view (or entire hierarchy), then you get classic list which you can save as local file in spreadsheet format.

it's not particulary nice, but might help.

[Former Member · Accepted solution]

yeah, i know it doesn't make much sense to xport this to Excel, but users get stuck in a routine and don't want to change.

Branko, thanks, I think this will work for us.

robert.

[former_member416164 · Accepted solution]

Hello

I'm currently looking for somethig like that. Has someone already exported data from an ALV TREE to Excel ?

Thanks in advance

Jean-Michel