Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Export to Excel ALV Grid Problem

Former Member

‎2009 Jan 30 1:19 PM

0 Likes
1,874

Hi

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

Hi

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

Reply
3 REPLIES 3
Read only

Former Member

‎2009 Jan 30 1:37 PM

0 Likes
916

Hi,

Refer this link,

Read only

Former Member

‎2009 Jan 30 1:41 PM

0 Likes
916

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@

Read only

Former Member

‎2009 Jan 30 4:32 PM

0 Likes
916

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