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

About Excel download format.

Hi ,

I need to download to excel in this format .

Customer ,Customer name , Model in between row1 and row2 . Invoice Details Vehicle detail are dispalyed in row1 and Invoice Date , Net Price ,Discount , Taxes Chassis are dispalyed in row2.

where @ represents blankspace.

-


Customer | Customer name | Model | Invoice Details | Vehicle details

@@@@@@@@@@@@@@@ | Invoice Date | Net Price| Discount | Taxes Chassis

-


please Guide me regarding this.

Regards,

Kiranmai.

Edited by: kiranmai B on Dec 1, 2008 8:23 AM

Edited by: kiranmai B on Dec 1, 2008 8:24 AM

Edited by: kiranmai B on Dec 1, 2008 8:27 AM

Edited by: kiranmai B on Dec 1, 2008 8:30 AM

Edited by: kiranmai B on Dec 1, 2008 8:30 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Dec 01, 2008 at 08:59 AM

    Hi Kirmani,

    The threads mentioned below might help you a bit:

    [Download data to excel1|download-to-excel]

    [Download data to excel2|download-list-as-excel]

    Regards,

    Anubhav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2008 at 08:58 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2008 at 11:04 AM

    Dear Kiran,

    You can use the below piece of code.

    data:lv_var1 type string,
    
         . . . . . .
        . . . . . . .
    lv_var1 = 'Customer'.
    lv_var2 = 'Customer name'.
      . . . . . .
     . . . . . . .
    
    CONCATENATE   lv_var1  lv_var2 ........ CL_ABAP_CHAR_UTILITIES=>CR_LF
            INTO <Variable>    SEPARATED by   CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

    Now the header will be placed in your excel document. You can proceed with the other functionalists as the same.

    Provide points if helpful

    Regards,

    Gokul.N

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2008 at 12:44 PM

    Hi Gokul,

    Can u please explain the bold letters.

    CONCATENATE lv_var1 lv_var2 ........ CL_ABAP_CHAR_UTILITIES=>CR_LF

    INTO <Variable> SEPARATED by CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.

    Regards,

    Neelima.

    Edited by: Sammeta Neelima on Dec 16, 2008 1:44 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Neelima,

      I think those 2 standard methods has been used to have utilities in excel. but im not confirmed with that. But without using those standard class, we cant attain the headers in Excel. Previously ive referred some document on the same and implemented and working fine.

      Regards,

      Gokul.N

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.