Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to convert ALV report to Excel ??


My requirement is to show ALV report in the excel .

I have 2 radio buttons in Selection screen :

1) ALV format 2) Excel.

If excel is selected then user will give a path : C :\newexcelreport.xls

I knew that there is a way to download report through ALV report using download into local file. But the requirement is to create a report in Excel same like ALV report .

I tried using GUI_Download . But it is displaying some fields wrongly, ex : Date , Time, without header .

Date is showing year month date format in the excel .

time is showing in a numeric format.

But the ALV report is showing correct report . When I download into local then the report is showing correct results .

Is there any function module to download exact ALV report into excel .??

Thanks & Regards,


Not what you were looking for? View more on this topic or Ask a question