CL_GUI_ALV_TREE - is there a way to export to Excel?
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.
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.