ALV: Export to excel

[vallamuthu_madheswaran2]

HI Friends,

I've developed ALV report using the FM 'REUSE_ALV_GRID_DISPLAY'.

it's around 1000 char length(50 fields).

Now my problem is that if i export the o/p to excel then it not export in correct format.

Heading is split it 2 columns.

Thanks & Reagrds,

Vallamuthu.M

[vallamuthu_madheswaran2]

HI Friends,

I've developed ALV report using the FM 'REUSE_ALV_GRID_DISPLAY'.

it's around 1000 char length(50 fields).

Now my problem is that if i export the o/p to excel then it not export in correct format.

Heading is split it 2 columns.

Thanks & Reagrds,

Vallamuthu.M

[Former Member]

Hi,

Can you please tell me the size of the rows and columns of your output.??

or else just execute your report and in top left just follow this.

LIST ->EXPORT> LOCALFILE>SPREADSHEET and give the file name and format like .XLS .

I hope it will work ..

Thanks,

Pradeep.

[vallamuthu_madheswaran2]

Hi Pradeep,

The list spread sheet is disabled.

Thanks and Regards,

Vallamuthu.M

[Former Member]

*Just right click on the report output--> spreadsheet-> check Excel and ok *

select the path . Hope will work.

Thanks,

Pradeep.

[vallamuthu_madheswaran2]

Thanks Pradeep. Problem Solved.

[madhu_vadlamani]

Hi,

Can you try this.

Save the file in unconverted format and give extension .txt Open xls file and open that .txt file you will get data

Regards,

Madhu..

[vallamuthu_madheswaran2]

Hi Madhu,

Thanks for your solution. But the unconverted - txt file also giving the same problem.

Thanks & Regards,

Vallamuthu.M