topic spool print in Excel in Application Development and Automation Discussions

spool print in Excel

Former Member — Mon, 03 Dec 2007 11:54:01 GMT

hi experts,

in my sm37 spool request i want to download in execl sheet. by means of ALV so that i can download completly in Horizental diraction , no line going to split..

but its layout in in classical list format i am not able to tacke correct format.

<b>Matnr mbrsh meins

makts</b>5000001 M ea

'Bottel'

5000001 M ea

'Bottel'

5000001 M ea

'Bottel'

its show output in excel like above way... i dont want ...

i want in this format.

<b>Matnr mbrsh meins makts</b>

5000001 M ea 'Bottel'

5000001 M ea ' Bottel'

5000001 M ea 'Bottel'

how to take in this format...in Excel sheet or txt file.

Re: spool print in Excel

Former Member — Tue, 04 Dec 2007 03:48:43 GMT

Hi Jim,

Goto SP01 trx.

Enter the spool no. & execute.

Tick the check box

Select SYSTEM=> LIST=> SAVE=> LOCAL File => Spreadsheet

Best regards,

Prashant

Re: spool print in Excel

Former Member — Tue, 04 Dec 2007 06:12:05 GMT

prashant,

i am getting output but it should be in ALV format.. so that i can add or remove any layout and take print out.

Re: spool print in Excel

Former Member — Tue, 04 Dec 2007 10:57:41 GMT

thanks, point has been given