topic ALV to Excel Format problem in Application Development and Automation Discussions

ALV to Excel Format problem

Former Member — Wed, 03 Jun 2009 13:02:05 GMT

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 !

Re: ALV to Excel Format problem

daniel_kaoro — Wed, 03 Jun 2009 13:45:10 GMT

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.

Re: ALV to Excel Format problem

Former Member — Wed, 03 Jun 2009 14:15:20 GMT

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.

Re: ALV to Excel Format problem

Former Member — Wed, 03 Jun 2009 15:20:18 GMT

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

Re: ALV to Excel Format problem

Former Member — Thu, 04 Jun 2009 07:35:23 GMT

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