ALV - Spreadsheet

[Former Member]

Hi Experts,

One simple doubt, pls. clarify.

My requirement is that, <b>Downloading the ALV displayed data into Excel.</b>

So, I gone <i><b>Menu>List>Export-->Spreadsheet</b></i>

But, I observed that, the Currency, Date, Unit columns r coming in the last of spread sheet and with out any color(where as other columns does hv some color!)

1 - So, its the SAP default property? OR Do I need do/code some thing, to resemble the ALV displayed data(to meet my requiremenet)?

2- Generally, Wht is the procedure to get thru my requirement? I mean, am I doing correct?

thanq.

Message was edited by:

Srikhar

[Former Member]

Why don't click on XL Button in ALV Output and save into your desktop.

if you try this then you would get color's.

Thanks

Seshu

[former_member194669]

Hi,

Try this

1. Go to Tools -> Macro -> Security in Excel

2. Select the ‘Trusted Sources’ tab and ensure that the checkbox titled ‘Trust access to Visual Basic Project’ is ticked.

3. With the feature switched on, the data is passed to Excel.

if this not worked , then try to download to excel from ALV using Excel Inplace.option

a®

[Former Member]

thanq,

Can u pls. tell me Wht is the <b><i>Excel Inplace.option</i></b>? Is it FM?

thanq.

[former_member194669]

Hi,

Its button on the toolbar in the ALV.

aRs

[Former Member]

It is not issue with SAP,It is issue with Excel file .

Please click on xl button in alv tool bar,it will open as per your requirement.

if not then open any excel file->tools ->macro->security ->click the tab called trusted source,check the all check box.

Now see the results in alv wise

you can see oss note regarding this

Thanks

Seshu

[Former Member]

thanq,

yes, I tried, but am getting like, open blank(no data) excel sheet just in place/location of ALV grid! am using FM ALV prog.

thanq.

[Former Member]

First Step :

Please click on xl button in alv tool bar,it will open as per your requirement.

if not then open any excel file->tools ->macro->security ->click the tab called trusted source,check the all check box.

Now run report program and download it to xl file or click on XL Button.

Thanks

Seshu

[Former Member]

Why don't click on XL Button in ALV Output and save into your desktop.

if you try this then you would get color's.

Thanks

Seshu

[Former Member]

thanq,

yes, I tried, but am getting like, open blank(no data) excel sheet just in place/location of ALV grid! am using FM ALV prog.

thanq.

[Former Member]

Hi Srikar,

Better use FM, Gui_download, once you click on download buttong, total data will be download into excel.

...Regards

Rams

[Former Member]

Hi Srikar,

Normally in your requirment, we have to write code to download, because user point of view, he can not do any think like this, my sincere advise to better use logic in your code (Gui_download Function module).

Regards

Rams

[Former Member]

Hi Srikhar

If you see, all the char type columns comes first and later the other data types come.

If you want it to be in same format as ur ALV, u can make all fields Char type while displaying.

Cheers

~Arun

Reward if useful