Skip to Content
author's profile photo Former Member
Former Member

Headers for excel file through GUI_DOWNLOAD

Hi all,

How to maitain headers to excel file which is downloaded from SAP through

GUI_DOWNOAD,

Its urgent anybody let me know

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2008 at 10:44 AM

    Hi,

    The function module does not have a facility of directly downloading the two together, however there is a work around.

    First you create an internal table which has only one record that contains all the headers for the columns.

    Download this file into your required destination file on presentation server.

    Then, you download the actual internal table into the same file using GUI_DOWNLOAD, but mark APPEND = 'X' in the function module.

    What this will do is, first download the headers into a file on PS and then append the records in the second download to the same file.

    Why we cant do it in the same run is because, if an internal table has a column contianing quantity vlaue e.g. weight, we cannot populate the header in this column, because its character.

    Try this.

    Cheers,

    Aditya

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I wouldnt suggest GUI_DOWNLOAD if you want a proper EXCEL Sheet. GUI_DOWNLOAD cannot create a proper excel sheet, it actually creates a tab delimited file hence you can open it using notepad also, I suggest to go for the function module XXL_ALV_CALL..which gives you a proper EXCEL sheet to save

      santhosh kaluvala

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.