How can i download data in excel sheet .

[Former Member]

Hi all

My Requirement : In a selection screen after giving a VBELN,It will show all the related data from VBRP table through alv  . There are a customize icon ,after clicking the icon it will download all fetched data .

Can any one help me .how can i download the fetched data through excel ?

Regards

Rajesh .

[jogeswararao_kavala]

Hi Rajesh,

I understood your requirement as from ALV you want to download the data to an Excel sheet.

In standard ALVs, you need to do this

In other cases like Z programs etc, often Icon is provided  (as you said) like this

You need to select Local File option here as shown below

In both case you will get this pop-up

Now when you continue you will get SAVE dialog-box, where you can give a name to your excel file and Save.

Hope this is your query.

Jogeswara Rao K

[Florian]

Hi Rajesh,

perhaps you take a moment to have a look at this project:

abap2xlsx - ABAP Development - SCN Wiki

abap2xlsx by ivanfemia

If you want to do more, than just have the Data in excel, this will be a great opportunity.

Otherwise Matthias gave you a clue. But you could find a lot content, by using the search located in the right upper corner.

To learn more, check this blog:

Regards

Florian

[Former Member]

Hello Rajesh,

you can use Function Module GUI_DOWNLOAD.

Check the FM documentation for details of usage, e.g. dialog for file name via method cl_gui_frontend_services=>file_save_dialog.

Kind regards

Matthias