Skip to Content
avatar image
Former Member

How to convert alv list into excel file?

Hi Experts,

i have created one report for Due Date Analysis.

Now My output is displaying in ALV list. But I need to convert the data which in alv list into Excel File. then only i have to send the Excel File to the Customer Thro Email.

So i need the Function Module to Convert the Data into Excel File.

Thanks,

Neptune.M

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 20, 2006 at 05:16 AM

    Hi Neptune,

    you have an option in the excel to export it to EXcel format..

    just click on the icon on the top to export it ..

    it will prompt you to select an option

    one of them wud be excel..

    regards

    satesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Lokesh,

      As per your statement i have included the header to the first line of the internal table itab_result. and i have used gui_download function to download the datas into excel file.

      CALL FUNCTION 'GUI_DOWNLOAD'

      EXPORTING

      FILENAME = 'C:\YNEW1.XLS'

      FILETYPE = 'DAT'

      HEADER = '00'

      TABLES

      DATA_TAB = ITAB_RESULT.

      Now i am using user FM to send a mail to the Customer while i am running the Report.

      My Problem is,

      My Excel file have no header when it reached the user side. But In MY BUSINESS WORKPLACE(SBWP) the attachment excel file has Header.

      what is the reason? Plz help me

      Thanks,

      Neptune.M

  • avatar image
    Former Member
    Apr 20, 2006 at 05:25 AM

    HI

    GOOD

    TO THROUGH THE FOLLOWING LONKS

    http://www.leeds.ac.uk/iss/projects/sap_upgrade/ALV_Superuser_message.doc

    THANKS

    MRUTYUN

    Add comment
    10|10000 characters needed characters exceeded