Application Development 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
Showing results for 
Search instead for 
Did you mean: 

alv help

Former Member
0 Kudos

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>

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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>

4 REPLIES 4

Former Member
0 Kudos

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>

0 Kudos

thankes Chandrasekhar

u solved my problem

Former Member
0 Kudos

Hi Antonio,

Please try in this way.

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

Thanks&Regards,

Siri.

Former Member
0 Kudos

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.