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

Downloading into spreadsheet

I have a transaction which I ran in background and its in the spool. How do I download that into excel.

Please help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Oct 12, 2006 at 07:16 PM

    You can simply display the spool, then save it as a local file, save it as a regular text file. Now open Excel, click open, and open the text file from there, know go thru the steps to separate the columns of your data.

    Regards

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 12, 2006 at 07:18 PM

    Hi,

    If you just want to download manually to excel sheet...

    Goto transaction SP01.

    Select the Spool Request and click Display.

    Menu path SYSTEM->LIST->SAVE->LOCAL FILE and choose Spreadsheet.

    If you want to do this programmatically...

    Use FM BAPI_XBP_JOB_SPOOLLIST_READ to read the spool request data.

    Use FM GUI_DOWNLOAD to download data to Exccel.

    Thanks,

    Ramakrishna

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 05:33 PM

    Still not able to do what I need. I have a transaction which runs for 30 minutes in foreground with results of 20 to 30 pages.

    I would liek to run this in Background and then display the CONTENT of the file into a spreadheet.

    When I go to SM37 and say save as local file, Its giving me the spool details..

    Please help

    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.