Skip to Content
avatar image
Former Member

Internal table to excel

Hi All,

Could any one help me on how to convert internal table data to excel in

webdynpro abap .

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Apr 30, 2016 at 07:59 AM

    Hi,

    Use Function module SAP_CONVERT_TO_XLS_FORMAT.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2016 at 08:11 AM

    please refer this thread.

    Convert internal table to excel format | SCN

    Regards,

    Sagar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2016 at 09:11 AM

    For time being,

    use this link to make your application work.

    http://scn.sap.com/docs/DOC-25024

    Exporting Internal Table Contents to Excel File – Web Dynpro - Web Dynpro ABAP - SCN Wiki

    There's another way where you can generate any formatted XML document and that can take any table data as input and generate an excel sheet. Couldn't write it up on thread, would post a separate blog/post (in case if none exists) and would update back the thread.

    Thanks,

    Santosh

    Add comment
    10|10000 characters needed characters exceeded

  • May 04, 2016 at 11:09 AM

    Hi Vivek,

    Have a Look at this helpful thread Convert internal table to excel format | SCN.

    Surrely it will help.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • May 05, 2016 at 06:10 AM

    Hi Vivek,

    Please use below code for download to excel from webdynpro screen (Write it in some button action).

         wdr_task=>client_window->client->attach_file_to_response(

         i_filename = 'fs.xls'

         i_content  = lv_xstring

         i_mime_type = 'EXCEL').

    Thanks,

    Chella

    Add comment
    10|10000 characters needed characters exceeded