Download a report to excel with format (border, color cell, etc) Try this program.it may help you to change the font.etc. Code: REPORT ZSIRI NO STANDARD PAGE HEADING. * this report demonstrates how to send some ABAP data to an * EXCEL sheet using OLE automation.
'hi, i was trying to transfer an ALV report to an excel data file, the order and the data laiyng in the ALV does not contains in the dumped excel file. It has blank colums in between,what would be the reson for this, looking for a solution. Cheers, Dilum //*-------- INTERESTED IN THIS MESSAGE? RELATED CONTENT -------- Intelligent Document Delivery: The Ins and Outs of Business Process ROI With Oracle ERP (White Papers) So I'm a PHP developer and my company runs SAP now what? (Blogs) What are BIW and BW? Why do they have a significant role in Enterprise Resource Planning? (Wiki) Incompletion Procedure which contains Risk Category (Groups) -------------------------------------------------------------*// '.
When u display the report in ALV and take is directly to spreadsheet, it does not take the ALV format into consideration. What you can do is: 1. Run the report, it will display the data in ALV. From the menu select LIST >> EXPORT >> LOCAL FILE. Save it as spreadsheet.
It will save the ALV format and any calculation with ALV as well. Hope it helps. Regards, Sandhya SAP Consultant - Technology Gravity Microsystem URL: www.gravitymicrosystem.com -----Original Message----- From: dilum_alawatte via sap-r3-dev [mailto:[email protected]] Sent: Friday, July 14, 2006 11:51 AM To: sandhya Subject: [sap-r3-dev] ALV report to Excel,blank colums inserted.! Hi, i was trying to transfer an ALV report to an excel data file, the order and the data laiyng in the ALV does not contains in the dumped excel file. It has blank colums in between,what would be the reson for this, looking for a solution. Cheers, Dilum //*-------- INTERESTED IN THIS MESSAGE?
RELATED CONTENT -------- Top Five Reasons to Automate SAP Document Delivery (White Papers) Bad Japanese Business Practices or Things I Will Never Understand (Blogs) What are BIW and BW? Why do they have a significant role in Enterprise Resource Planning? Pokemon ash gray 4.2 gba rom. (Wiki) Re: Adding fields to sales overview screen (Groups) -------------------------------------------------------------*//. Sandhya, Thank for your collaboration, but unfortunately it didn't work at all, problem remains as it is. Further I have investigated that after 24th Column it has inserted a blank column and shifted only the data area to the rite. Please give me a solution (Note that In the ALV report it self data is appearing perfectly) Thx. Dilum Alawatte, Information Systems Division,(ISD/SAP) Loadstar HeadQuarters (LHQ), Loadstar Private Limited, 218,Minuwangoda Road,Ekala, Ja-ela, Sri Lanka.
Voice: +14 ext 214 Mobile:+94-714-147000 -----Original Message----- From: sandhya via sap-r3-dev [mailto:[email protected]] Sent: 14 July 2006 12:00PM To: dilum_alawatte Subject: RE: [sap-r3-dev] ALV report to Excel,blank colums inserted.! When u display the report in ALV and take is directly to spreadsheet, it does not take the ALV format into consideration.
What you can do is: 1. Run the report, it will display the data in ALV. From the menu select LIST >> EXPORT >> LOCAL FILE. Save it as spreadsheet. It will save the ALV format and any calculation with ALV as well. Hope it helps.
Regards, Sandhya SAP Consultant - Technology Gravity Microsystem URL: www.gravitymicrosystem.com -----Original Message----- From: dilum_alawatte via sap-r3-dev [mailto:[email protected]] Sent: Friday, July 14, 2006 11:51 AM To: sandhya Subject: [sap-r3-dev] ALV report to Excel,blank colums inserted.! Hi, i was trying to transfer an ALV report to an excel data file, the order and the data laiyng in the ALV does not contains in the dumped excel file.
![Alv Alv](http://4.bp.blogspot.com/-HSXuOEB5blA/TnnzfW_6SBI/AAAAAAAAAkQ/KQ0b8sSo2MA/s640/right+click+method.jpg)
It has blank colums in between,what would be the reson for this, looking for a solution. Cheers, Dilum //*-------- INTERESTED IN THIS MESSAGE?
RELATED CONTENT -------- Intelligent Document Delivery: The Ins and Outs of Business Process ROI With Oracle ERP (White Papers) Integrated Database and Business Management Offering for Midsize Enterprises (Blogs) What are BIW and BW? Why do they have a significant role in Enterprise Resource Planning? (Wiki) Re: BP in R3 (Groups) -------------------------------------------------------------*//. Hi, In the text file I have seen there are two tab separator in that 24th column. That may be the reason.