ALV to Excel Format problem

[Former Member]

Hello Freinds,

I am trying to download the o/p of ALV report into an excel sheet.But the o/p in excel sheet is distorted to some extent.Some of the headers appear in the next line even if there is no limit of rows in office 2007 which is there on my machine.This issue is not on all servers.In development and quality servers the format is correct but when the same report is downloaded from Production server,the o/p appears distorted.

Please advice as to what could be the reason !

[Former Member]

Hi Jazz,

You can very well do what our friend Avinash told the easier way .

But if you want it to be done programmaticlly,then plz revert with the following details

1) Whether the file is excel (any specifications)

2) Whether any special characters are present in the int table

3) Whether the ALV has colour and other formats

Thanks and Regards

Srikanth.P

[daniel_kaoro]

Hello I'm not sure about the root cause of it... As you told us that it was successfully done by DEV and QAS system but PRD has issues.

All 3 systems has the same configuration like SPs, Notes and Kernel at the same level? It could be the reason of the issue, is not usual but I have seen DEV and QAS systems that has higher corrections than the PRD.

Also, please try to do a test with the latest SAP GUI.

Best regards,

Daniel.

[Former Member]

HI,

Press the Spreadsheet button on the ALV toolbar or CtrlShiftF7. Now the You can see the Pop up

select the All Avaliable Foramts and Excel (In Office 2003 XML Format) and press OK.

After download rename the file from XML to XLS.

[Former Member]

Hi Jazz,

You can very well do what our friend Avinash told the easier way .

But if you want it to be done programmaticlly,then plz revert with the following details

1) Whether the file is excel (any specifications)

2) Whether any special characters are present in the int table

3) Whether the ALV has colour and other formats

Thanks and Regards

Srikanth.P

[Former Member]

Check the standard report RSDEMO01 to send some ABAP data to an EXCEL sheet using OLE automation