download excel from spool.

[former_member841898]

hi experts,

i have a classical report which should be executed in background.

the o/p is coming ok but when from spool i m downloading it to spread sheet each column is shifted towards left.

what is the reason behind this?

the o/p is coming well in spread sheet when executed in foreground mode.

regards

pankaj

[Former Member]

I am not an expert at all, but I will give it a try:

what do you mean with downloading the spool? Just going to SP01 and save the list to a local file of the type Spread sheet? If that is the case, then the issue is probably caused by the fact that Excel automatically removes leading spaces! You should download it unconverted to your local file system (txt format), open excel and from within excel you open the file and use the wizard to open it. At the step where you can choose the types of the columns, you should select all columns and let them use type Text. Now the leading spaces should remain!

[former_member841898]

hi sven,

ur idea works.

awarded

regards

pankaj

[Former Member]

You can have one more option,

1. Download file in the txt format.

2. Open txt file in EXCEL

3. select the first column and select the option 'DATA' ->Text to columns.

4. Format your data.

Thanks,

[former_member583013]

You must read table TSP01 and download the table in excel format using GUI_DOWNLOAD...

Greetings,

Blag.

[former_member841898]

hi sir,

i think fm gui_download can't be used in background

otherwise gor foregroung it is ok.

regards

pankaj