Download data from multiple tabs of ALV to tabs of Excel

[Former Member]

Hi,

I have a requirement where ALV is being displayed in 6 tabs. Can a download functionality be provided in such a way that data from all the tabs gets downloaded into multiple sheets of Excel document.

In the attached file, expected output with ALV in multiple tabs is displayed. Are there any Function modules which can be used to download data from ALV in each tab into Excel document sheets in one go?

Thanks,

Tejaswini.

[Former Member]

hi Tejaswini

You can using OLE to download your tabs to mutiple sheets in excel.

you will find so many detail about OLE in scn or wiki. thanks.

regards,

Archer

[raymond_giuseppi]

This is a FAQ, did you use search tool with keywords like worksheet, activate and OLE to find many threads and (some examples)

• a sample like XLSX Upload - A Unified Approach
• a project like abap2xlsx

Regards,

Raymond

[kranthi_kiran5]

Dear Tejaswini,

Please Check the Code in the attachment, It is working fine for my program..