Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

excel sheet function modules

venkatasap
Participant
0 Kudos

Hi SapAll.

here i have got to add some fields to the selection screen of the report.in the technical spec it is described as :

It should be possible to download the report onto an excel spreadsheet for manipulation purposes.

but i cont see on which is the function module that generated excel spread cheet.

but i can see some of the function modules here :

'G_SET_TREE_ADD_POINTERS,G_SET_GET_ID_FROM_NAME,'G_SET_TREE_IMPORT'.

so can any body help me what these function modules do.

regards.

Varma.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Verma,

If you are showing report in ALV then you will get one button as exprot. Once you click on that button you will get Spread sheet option. Select that option and download in excel format.

If you want function module then you can use GUI_DOWNLOAD.

Thanks,

Padmakar

2 REPLIES 2

vinod_vemuru2
Active Contributor
0 Kudos

Hi,

You could have searched the forums for this!!!

Use FM GUI_DOWNLOAD for downloading the data. If your report is in ALV format, it already has inbuilt functionality for downloading the data. Even the standard list (O/P created using WRITE statements) has this option through menu=>System=>List=>save=>Local file.

Thanks,

Vinod.

Former Member
0 Kudos

Hi Verma,

If you are showing report in ALV then you will get one button as exprot. Once you click on that button you will get Spread sheet option. Select that option and download in excel format.

If you want function module then you can use GUI_DOWNLOAD.

Thanks,

Padmakar