topic Down loading ALV to excel sheet in Application Development and Automation Discussions

Down loading ALV to excel sheet

Former Member — Thu, 25 Sep 2008 13:12:38 GMT

Hello guys,

Im facing problem with ALV. The data which displayed in ALV report is not displaying in excel sheet. Normally the data is displaying but i have given one cond. in selection screen, if check box is not initial 4 more fields are adding to final structure. So after adding these fields data is not displaying in excel sheet.

I hope u understood the problem can any one suggest me..

regards

vijay

Re: Down loading ALV to excel sheet

Former Member — Thu, 25 Sep 2008 13:14:25 GMT

what you do add a button in pf-status of ALV and when you click this button use GUI_DOWNLOAD and ur internal table to download the data..

Re: Down loading ALV to excel sheet

Former Member — Thu, 25 Sep 2008 13:17:07 GMT

Just for clarification.

When the check box is not initial are you missing all the data or only the four additional fields?

Re: Down loading ALV to excel sheet

Former Member — Thu, 25 Sep 2008 13:20:29 GMT

Hi,

Include 4 more fields with final internal table and that final internal table pass it to the function module

WS_EXCEL

likt the below.

call function 'WS_EXCEL'
        exporting
             filename = p_file
        tables
             data     = i_excel.

after reuse function module write this logic

Regards,

Nandha

Re: Down loading ALV to excel sheet

former_member203501 — Thu, 25 Sep 2008 13:23:16 GMT

hi do like this.....

send the data into some final internal tables ...populate after the condition . this is a problem with the condition ...i think the condition is involved in the data population . so it is taking wrongly..