Converting ALV spool output to Excel

[Former Member]

Hello!

We have a program that converts the output of a background job spool to PDF format -- no problem. Is there a similar, or not, method to convert the output of a spool to Excel?

P-O-I-N-T-S for any helpful answers!

Thanks!

John

[Former Member]

HI John,

Please check the similar thread which will help you to proceed.

Cheers

Sunny

Rewrd points, if found helpful

[Former Member]

Hi Sunny;

I saw that thread previously, but it looks like it works on-line and I need this solution to work in the background, pulling the date from the spool.

Thanks!

John

[Former Member]

HI john ,

As i am away from the system ,on vacation .

so just give a try on

• If the program is run in the background the

SUBMIT rm07idif WITH SELECTION-TABLE li_selection

EXPORTING LIST TO MEMORY AND RETURN.

CALL FUNCTION 'LIST_FROM_MEMORY'

TABLES

listobject = li_listobject

EXCEPTIONS

not_found = 1

OTHERS = 2.

CHECK sy-subrc = 0.

CALL FUNCTION 'WRITE_LIST'

TABLES

listobject = li_listobject

EXCEPTIONS

empty_list = 1

OTHERS = 2.

IF sy-subrc <> 0.

ENDIF.

<b>Or here you can send the spool to Excel.</b>

Try this link

http://www.geocities.com/victorav15/sapr3/abapfun.html#ole

Not very sure that they will surely answer ur thread but let's see if they help u somewhat.

Cheers

Sunny

Rewrd points , if helpful

[Former Member]

Hi john,

1. the data in spool

is always stored in printable format.

2. ie. if we have something to print,

eg. AMIT MITTAL,

then the format in which it is stored

is some raw format, ie (printable format)

3. that printable format can be converted to .pdf

online, but no such converter for EXCEL.

regards,

amit m.

[Former Member]

1. SP01 and see your entry

2. Click on Type or Display Button or F6

3. It may show 1st 10 pages

4. Click on settings in the display

Change last page

5. Ignore memory warning - whisper 'Joy Ma Kaali'

6. Right click & Save to Local File as Excel!

Manual Method but deserves Points???

Regards

-jnc@Kolkata

[Former Member]

Use Function RSPO_DISPLAY_SPOOLJOB

to automate the process of display.

Try SeE37 RSPO_DISPLAY_SPOOLJOB single test

nothing could be easier.

RSPO_DOWNLOAD_SPOOLJOB downloads to a flat file

That could be processed to CSV & captured into Excel.

Regards

-jnc@Kolkata