Output of SAP Report to Local file as . xls format is not aligned properly

[Former Member]

Hi

I am trying to save the output of report in SAP system to Local file as . xls format.

Once I got the local file as .xls format. Table contain the data of more than 10k rows. So  Data are not aligned in proper cell as it is in SAP system, even after trying Tabular and Space format to split the date.

When I try HTML format, file size is in the range of 80Mb. So I am not able to send the HTML format file through a mail..

Can any suggest me which format is better and gives perfect data alignment of cell.

[Juwin]

Is this a ALV report? If so, create a wrapper for the standard program and use backdoor entry to ALV to get data and download the file correctly.

Thanks,

Juwin

[Former Member]

Yes it is ALV report. But I want to take a copy of output data table from Q21 system without make any change in program.

[ziolkowskib]

I would go for Excel (in Office 2003 XML format) but before saving change the file extension to .xls instead of default .xml

[Juwin]

With the method I gave you, you don't have to change the existing program.

Thanks

[Former Member]

Can you guide me where can I find this format options ?

[ziolkowskib]

Based on the ALV available in SE16N:

If you choose Spreadsheet you should see new window as presented in my previous screenshot.