topic Re: Export to Excel ALV Grid Problem in Application Development and Automation Discussions

Export to Excel ALV Grid Problem

Former Member — Fri, 30 Jan 2009 13:19:19 GMT

There is a unique problem in my ALV report. Whenever I export to excel (List->Export->Spreadsheet), the data is getting exported all fine, but whenever I try to export to local file in excel (List->Export->Local File-- then choosing spreadsheet radio button) the format is gettig all messed up with no column in line.

I searched in the SDN for a clue but didn't get any relevant threads. The Client needs the local file export to be proper.

Any suggestions why this might be happening?

Regards,

Varsha

Edited by: Varsha Agarwal on Jan 30, 2009 2:19 PM

Re: Export to Excel ALV Grid Problem

Former Member — Fri, 30 Jan 2009 13:37:17 GMT

Hi,

Refer this link,

Re: Export to Excel ALV Grid Problem

Former Member — Fri, 30 Jan 2009 13:41:54 GMT

HI Varsha,

My suggestion on your query will be first check whether your data in downloading properly or not using simple function module GU_-DOWNLOAD and there you give the format as .xls and then you try to download with the ALV report.

And i think there might not be much changes has to be done with your system.

Cheers!!

VEnk@

Re: Export to Excel ALV Grid Problem

Former Member — Fri, 30 Jan 2009 16:32:46 GMT

list->export->local file does not save the file in a native excel format, but rather in a tab separated file.

try this experiment.

list->export->local file, spreadsheet. save it to your desktop, then open it with notepad. you can see that clearly, this is not an excel file.

what is likely screwing up your formatting are any headers you have on the report. For reports we know wil be downloaded, we usually give the option to print only column headings, and not report headings. another option is to have your user remove the headings with notepad before opening it in excel.

just a thought

dave