topic Downloading into spreadsheet in Application Development and Automation Discussions

Downloading into spreadsheet

Former Member — Thu, 12 Oct 2006 19:10:32 GMT

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

Please help

Re: Downloading into spreadsheet

RichHeilman — Thu, 12 Oct 2006 19:16:36 GMT

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

Re: Downloading into spreadsheet

venkata_ramisetti — Thu, 12 Oct 2006 19:18:31 GMT

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

Re: Downloading into spreadsheet

Former Member — Fri, 13 Oct 2006 17:33:34 GMT

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