Download the output of Function Module 'TREEV_CREATE_COLUMN_TREE' to Excel file.

[former_member828182]

I am using a call function 'TREEV_CREATE_COLUMN_TREE' for a tree output.
I would like to download the output exactly like how it is displayed into an excel file.
Unfortunately an '&XXL' or '&VEXCEL' is not recognized by this FM.
Is there any other way to make this happen?

[Sandra_Rossi]

I see 2 possibilities

1. Insert custom code as modification of standard
2. SAP GUI Scripting if allowed on your system

[former_member828182]

Hello Sandra,

I have all my information in the ''SNODETEXT' structure with all the hierarchy (nodes), colours etc.
I would like to display it the same way it is in EXCEL file.
How to make it display like that? Any inputs?
Thanks a lot.

[Sandra_Rossi]

1. You have lots of questions and answers about how to generate an Excel file.
2. I don't know TREEV_CREATE_COLUMN_TREE, but adding a button and then reading the column tree to generate the Excel file requires a modification of standard

It's a lot of work for newbies, so you're alone in that.

Is there a reason why you use TREEV_CREATE_COLUMN_TREE (not released), why not using CL_GUI_COLUMN_TREE or CL_COLUMN_TREE_MODEL (released) instead?

I'm not aware of a standard example which exports a tree in Excel. Do you know one?

[former_member828182]

Its a requirement to download the output in Excel as an enhancement to already working program. Hence, I cannot change the FM 'TREEV_CREATE_COLUMN_TREE'. No, I am not aware of any such example.