Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.



Former Member
Former Member replied


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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question