spool print in Excel

[Former Member]

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.

Like

<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'

5000001 M ea 'Bottel'

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

[Former Member]

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.

Like

<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'

5000001 M ea 'Bottel'

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

[Former Member]

Hi Jim,

Goto SP01 trx.

Enter the spool no. & execute.

Tick the check box

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

Best regards,

Prashant

[Former Member]

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.

[Former Member]

thanks, point has been given