spreadsheet containing all 4 alvs using oops

[Former Member]

Hi All,

i need help .

i need to download all 4 alvs in one spreadsheet .

i have created 4 alvs using oops using one container splitted into 4 using splitter.

Each splitter has its own spreadsheet option but user wants one spreadsheet option at the toolbar

through which one can download all the 4 alvs.

please suggest.

[former_member196651]

Hi Pallavi,

What I believe is, you will be able to download the contants of all the 4 ALVs to a single spreadsheet using the OLE method. Using this, you will be able to download the values of each ALV to separate sheet of a single spreadsheet. Please have a look into these threads:

Downloading internal tables to Excel - ABAP Development - SCN Wiki

abap2xlsx - ABAP Development - SCN Wiki

Regards,

Abijith

[Former Member]

Hi Pallavi,

I'm just sharing a thought.

In this you cannt use standard excel download option so write logic to download the all ALVs data.

1.  Create one button in PF status

2.  Write excel download  logic in PAI. Use CL_GUI_FRONTEND_SERVICE=>GUI_DOWNLOAD to      download ALVs data (final internal table of each) to different excel.

3. It also possible to download 4 ALVs data into different worksheet of same excel using    OLE automation

Please search in SCN regarding OLE automation for more details

One of the thread i found in SCN

Thanks & Regards,

Arun

[Former Member]

Hi Pallavi,

Your requirement can be fulfilled by moving data to 4 sheets in the Excel workbook.

This can be done using the OLE method or the XML method.

My view is you can go for the XML method as this is faster than the OLE method when bulk data is downloaded and also you have additional options of using it in the background if required along with the formatting options while downloading to Excel which attracts the users .

Regards,

AyyamPerumal