alv help

[Former Member]

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

<b>First way</b>

Views ->excel inplace ->

I get empty page

<b>Second way</b>

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

it open 2 rows (available templates for excel )

and when I choose one it open <b>empty</b> 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 ?

<b>regards</b>

[Former Member]

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 <b>Trusted Publishers</b> and check the checkbox <b>Trust access to visual basic Project</b>

[Former Member]

thankes Chandrasekhar

u solved my problem

[Former Member]

Hi Antonio,

Please try in this way.

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

Thanks&Regards,

Siri.

[Former Member]

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.