topic Re: spreadsheet containing all 4 alvs using oops in Application Development and Automation Discussions

spreadsheet containing all 4 alvs using oops

Former Member — Thu, 05 Jun 2014 06:10:39 GMT

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.

Re: spreadsheet containing all 4 alvs using oops

former_member196651 — Thu, 05 Jun 2014 06:35:17 GMT

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

Re: spreadsheet containing all 4 alvs using oops

Former Member — Thu, 05 Jun 2014 06:42:43 GMT

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

Re: spreadsheet containing all 4 alvs using oops

Former Member — Thu, 05 Jun 2014 07:33:03 GMT

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