topic Re: ALV - Spreadsheet in Application Development and Automation Discussions

ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:02:53 GMT

Hi Experts,

One simple doubt, pls. clarify.

My requirement is that, Downloading the ALV displayed data into Excel.

So, I gone Menu~~>List~~>Export-->Spreadsheet

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

Re: ALV - Spreadsheet

former_member194669 — Wed, 29 Aug 2007 03:15:25 GMT

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®

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:15:52 GMT

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

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:32:49 GMT

thanq,

Can u pls. tell me Wht is the Excel Inplace.option? Is it FM?

thanq.

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:35:59 GMT

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.

Re: ALV - Spreadsheet

former_member194669 — Wed, 29 Aug 2007 03:36:36 GMT

Hi,

Its button on the toolbar in the ALV.

aRs

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:38:00 GMT

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

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:38:08 GMT

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.

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:42:16 GMT

Hi Srikar,

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

...Regards

Rams

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:46:48 GMT

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

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 03:55:01 GMT

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

Re: ALV - Spreadsheet

Former Member — Wed, 29 Aug 2007 04:46:33 GMT

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