Spool request download to Excel-Automatically

[Former Member]

Hi,

I want to know whether it is possible to download (i.e either thru' some customisation) the output from the spool request to a excel sheet without any manual intervention ie.automatically.

Thanks

Suresh

[Former Member]

Hi,

It is possible. You can use the folowing FM for converting the Spool to PDF

CONVERT_ABAPSPOOLJOB_2_PDF

CONVERT_OTFSPOOLJOB_2_PDF

If not you can get the Tempse id of the spool and use the FM

RSTS_OPEN_RB

RSTS_READ

This will give you the contents of the spool. Tempse object for the Spool can be found in the Spool Request Header

[Former Member]

Hi Siva,

Thanks for your reply,

I tried to use FM: CONVERT_ABAPSPOOLJOB_2_PDF but the value in SRC_SPOOLID field is getting displayed as 30,611 instead of 30611 and because of this, the file is not downloaded.

Thanks

Suresh

[Former Member]

Hi,

Try passing the Spool ID programatically? That will not have separators and should work.

or else hard code the spool number.

Edited by: Siva Prakash on Jul 7, 2008 1:47 AM

[Former Member]

close