how to export alv into excel sheet without using toolbar button

[Former Member]

hi,

i have developed ALV using FM methord on that i have created one button when user will click on that button

hole ALV should export in to excel as it is and that ALV is Heaving top of page contain also i want that shuld

also copy please help me for that please send me the sample code for that

Edited by: ankita khare on Nov 3, 2008 9:42 AM

[Former Member]

hi,

i have developed ALV using FM methord on that i have created one button when user will click on that button

hole ALV should export in to excel as it is and that ALV is Heaving top of page contain also i want that shuld

also copy please help me for that please send me the sample code for that

Edited by: ankita khare on Nov 3, 2008 9:42 AM

[Former Member]

Data of TOP OF PAGE will be in a internal table,

move that data to the internal table which you are passing in the FM for downloading to the excel.

Hope this is helpful,

Amresh.

[Former Member]

Hi,

use 'gui_download' to download to down load the data when the pushbutton is clicked.

Thanks & Regards,

Sudheer

[Former Member]

hi ,

Thanks for Rply,

can you please sand me sample code because i m facing runtime error

[Former Member]

Check this:

  CALL FUNCTION 'GUI_DOWNLOAD'
    EXPORTING
      filename                = 'C:/test.xls'
      filetype                = 'ASC'
      write_field_separator   = 'X'
    TABLES
      data_tab                = t_output

Regards.

[Former Member]

same question you asked today morning, and you got the reply also, you closed the thread. and why again...? any specific reason for asking the same question again and again.

[Former Member]

no i didnt got the right output

[Former Member]

Use download function ''gui_download' '

rgds

rajesh