ALV Tree download to Excel (CL_GUI_LIST_TREE )

[Former Member]

Hi All,

I have created a report for displaying the ALV tree. The flow of the code is sth like this:

Report -> Calls Screen 9000 -> Initialize container type CL_GUI_CUSTOM_CONTAINER -> Tree Class CL_GUI_LIST_TREE displays the ALV tree.

Now what I want is a way to download the ALV Tree to Excel format. Can you please help me on this.

Thanks,

Anuj

[Former Member]

Anuj,

check these threads

http://www.sapfans.com/forums/viewtopic.php?f=12&t=138177

Thanks

Bala Duvvuri

[Former Member]

Hi Bala,

I did try all of these before posting the thread. So far googling this has resulted in nothing. I checked out the code for QM19 also but what its using is very specific to their output and that makes me wonder if this is not a standard feature with ALV Tree as it is with ALV Grids/Lists.

Any other inputs are welcome.

Thanks

Anuj

[_IvanFemia_]

Hi,

try to read these blogs

[abap2xlsx - Generate your professional Excel spreadsheet from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20046] [original link is broken] [original link is broken] [original link is broken];

[xlsx2abap - Read and edit your Excel files from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20791] [original link is broken] [original link is broken] [original link is broken];

Code of this SCN Community project is shared on [Code Exchange|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

Regards

Ivan