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

ALV data to excel

Former Member

‎2011 Jan 20 10:25 PM

0 Likes
988

Hello Gurus please help,

We have a custom program to extract vendor performance data and show in ALV. Users want to download the data to excel and using menu option LIST/EXPORT/spread sheet. All data is exported to excel but all character data type columns are coming first and then all numeric data. We also used menu option LIST/EXPORT/LOCAL FILE/SPREAD SHEET this way the column sequence in ALV and excel are same but leading zeros in the numeric data is truncated. This data should not be trncated. Please note that in the former method leading zeroes are not truncated. So our users want to use first method and asking us maintain the column sequence as it appears in ALV.

How can we make sure that column sequence won't change during the export to excel?

We are using SAP 4.7.

Best regards,

Pavan

Hello Gurus please help,

We have a custom program to extract vendor performance data and show in ALV. Users want to download the data to excel and using menu option LIST/EXPORT/spread sheet. All data is exported to excel but all character data type columns are coming first and then all numeric data. We also used menu option LIST/EXPORT/LOCAL FILE/SPREAD SHEET this way the column sequence in ALV and excel are same but leading zeros in the numeric data is truncated. This data should not be trncated. Please note that in the former method leading zeroes are not truncated. So our users want to use first method and asking us maintain the column sequence as it appears in ALV.

How can we make sure that column sequence won't change during the export to excel?

We are using SAP 4.7.

Best regards,

Pavan

Reply
4 REPLIES 4
Read only

Former Member

‎2011 Jan 21 2:30 AM

0 Likes
775

Hi Pavan,

I was also faced same problem in 4.7... that time i was suggested to client use "excel view" option for downloading data from sap to excel..... because its giving exact data...

Excel and using menu option LIST/EXPORT/spread sheet is not useful in all causes. You can download data by choosing "excel view" in AlV Grid application tool bar... it will give accurate data.

(OR) Try with below options.... (Involved manual process)....

a. Menu --> List -->export --> local file --> choose radio button spread sheet --> Press F4 key on "file name" input field and download data into excel --> select save as type '.TXT'. --> save

b. open text file and copy data into excel sheet....

Thanks & Regards

Sudheer

Read only

Former Member

‎2011 Jan 21 9:01 PM

0 Likes
775

change the gui status to a custom one, add a download button and download using gui_download

Read only

Former Member

‎2011 Jan 22 5:56 AM

0 Likes
775

In ALV GRID where your result display you just press mouse's right click butt then select spreadsheet options

Read only

Former Member

‎2011 Jan 22 6:26 PM

0 Likes
775

some times due a sign position you can miss some columns in excel when download the beast approach form me is download in with out format open in excel and using menu data -> column text -> delimit using '|' give you the correct alienation