Skip to Content
avatar image
Former Member

Internal table to Excel

Hi Experts,

I am using a custom button to download data from internal table into excel file.

There is a new requirement to append the "header and footer" into the excel file, do you know if this is possible?

If it's possible, could you please share some thoughts on how to proceed?

Thanks.

Tee

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 05, 2009 at 10:33 AM
    10

    Hi,

    You have to use the XML coding to achieve the same.

    Ex: if you have a excel file with all necessary colors and heading once done save this file.

    Try to open this file as XML spreadsheet. Then open this file with notepad/wordpad to see the XML code.

    Check thiswiki

    http://wiki.sdn.sap.com/wiki/display/WDABAP/ModifyingexistingexcelsheetusingWDABAP?focusedCommentId=135987215#comment-135987215

    Regards,

    Lekha.

    Edited by: Lekha on Nov 5, 2009 4:17 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      You can use the above code.....in SE38 as i have used the normal GUI_download FM for testing prurpose....You can use the same logic in underlying class...

      The above code will generate the excel sheet with 3 columns and a header row...

      You can explore more based on the above code....

      All the best.

      Regards,

      Lekha.