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

Downloading Smartform to Excel sheet

Respected Experts,

I have a smartform of packing list.

The client wants to download the smartform as it is to the excel sheet.

i.e with the header which consists of shipping address and billing address and a lot many things and also the main table.

The client says that it wants to download the smartform as it sees on the screen in the excel sheet.

Is this possible?

Regards,

Roshan Lilaram Wadhwani.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Mar 06, 2008 at 08:54 AM

    You can download a smartform and it gets stored in .xml format..I doubt you can download in excel format..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 04:11 PM

    Hi ,

    U can convert the Smartform Output in to Excel file. u dont

    have any Function Module to do this...

    But u may have the Smartform output information in any

    internal table rit that can be downloaded into Excel file.

    Thanks,

    Manian.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2009 at 03:11 PM

    Hi ,

    i too have same problem in smart form.i got one fm 'RSPO_DOWNLOAD_SPOOLJOB' .that may be used for converting OTF into Excel.

    try it and update ur response to me.

    Thanks,

    Raju.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2009 at 10:06 AM

    Hi,

    1. Get the spool no. and convert the OTF spool to ABAP list.

    2. Store the list to memory and convert to HTML using FM WWW_HTML_FROM_LISTOBJECT

    3. Download or send the HTML tagged list as Excel using FM SO_NEW_DOCUMENT_ATT_SEND_API1

    This has a lot of disadvantage (like all data is placed in one column and hard to be editted by user, and this was a no-go for them). But this is one easy to implement.

    Regards,

    Madhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2009 at 05:50 AM

    You can download the form as excel format using the function module 'RSPO_DOWNLOAD_SPOOLJOB' .

    Regards,

    Joan

    Add a comment
    10|10000 characters needed characters exceeded

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.