Saving spool to excel

[marcin_cholewczuk]

Hello all,

Does anybody know how can I write spool to excel file? I know that FM 'LIST_DOWNLOAD' can save what's currently on screen but first I would have to display spool as transaction SP01 does and it's not that ease as I thought. Any ideas ?

[marcin_cholewczuk]

Hello all,

Does anybody know how can I write spool to excel file? I know that FM 'LIST_DOWNLOAD' can save what's currently on screen but first I would have to display spool as transaction SP01 does and it's not that ease as I thought. Any ideas ?

[Former Member]

Hi,

Check this link it will help you.

https://forums.sdn.sap.com/click.jspa?searchID=5891689&messageID=3856705

Thanks,

Reward If Helpful.

[Former Member]

Hi,

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.

Or here you can send the spool to Excel.

Try this link

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

OR

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.

Reward points if useful

[amit_khare]

Check the related links -

Regards,

Amit

Reward all helpful replies.

[former_member404244]

Hi,

chek the below link

http://www.sap-img.com/abap/download-in-background-in-excel-format.htm

Regards,

Nagaraj

[Former Member]

hi

good

There is a possibility of download the spool file as txt-file. .

Use Tranx SP01 - select the spool entry -->"spool request --> forward as text . You will find the file in your SAP work directory as <sid><spool#>.

http://www.sap-img.com/abap/download-in-background-in-excel-format.htm

or use fm RSPO_DOWNLOAD_SPOOLJOB.

reward point if helpful.

thanks

mrutyun^