topic Re: alv help in Application Development and Automation Discussions

alv help

Former Member — Wed, 11 Apr 2007 13:49:47 GMT

HALLOW

I doing a alv report and after display the report I wont to import the data to excel (or see data in excel)

I try it in to ways but I not working

First way

Views ->excel inplace ->

I get empty page

Second way

Select layout -> change layout -> view -> Microsoft excel

it open 2 rows (available templates for excel )

and when I choose one it open empty page of excel

1)why empty

2)do I have to add anther code to my program

If u wont that I explore my code please tell

what i doing wrong ?

regards

Re: alv help

Former Member — Wed, 11 Apr 2007 13:53:16 GMT

hi,

Change the macro settngs in your excel sheet and checkout if it works

Open empty excel sheet

In menu Tools~~>Macros~~>Security , change the radiobutton to medium

And also

In the Same popup , goto the second tab Trusted Publishers and check the checkbox Trust access to visual basic Project

Re: alv help

Former Member — Wed, 11 Apr 2007 13:53:26 GMT

Hi Antonio,

Please try in this way.

Goto Export button and try with Spreadsheet or Localfile->spread sheet.

Thanks&Regards,

Siri.

Re: alv help

Former Member — Wed, 11 Apr 2007 13:59:47 GMT

Hi ,

If you are displaying the alv report there should be an icon for 'download' or 'F9' it will ask for 'in which format should the list be save' go for 'Spreadsheet'

and assign a path with .xls file .

Vind.

Re: alv help

Former Member — Wed, 11 Apr 2007 14:31:18 GMT

thankes Chandrasekhar

u solved my problem