topic Re: problems excel view in ALV in Application Development and Automation Discussions

problems excel view in ALV

Former Member — Tue, 24 Oct 2006 19:26:23 GMT

Hi,

I am displaying data through an ALV_LIST_DISPLAY.

When I click on the Microsoft Excel at the ALV toolbar to view the same data in excel sheet it does open the excel sheet WITHOUT ANY DATA.

I changed macro options in excel and nothing happened

Re: problems excel view in ALV

messier31 — Tue, 24 Oct 2006 19:33:56 GMT

Normally we dont have to write any code for getting data in ALV's Excel inplace View. It is taken by SAP itself.

check out if u r using

it_events = gt_events[]

if u r not using any custom event then just comment this parameter of ALV_LISTDISPLAY and test whether the data is getting populated in excel..

Let me know the result...

Enjoy SAP.

Pankaj Singh

Re: problems excel view in ALV

Former Member — Tue, 24 Oct 2006 19:53:10 GMT

I am using it_events = gt_events[]

Re: problems excel view in ALV

messier31 — Tue, 24 Oct 2006 19:55:58 GMT

Can just comment

it_events = gt_events[]

for a test run and check if data is coming in excel inplace view...

Re: problems excel view in ALV

Former Member — Tue, 24 Oct 2006 20:09:46 GMT

Sorry, I was wrong, I use FM REUSE_GRID_DISPLAY

Re: problems excel view in ALV

messier31 — Tue, 24 Oct 2006 20:15:03 GMT

No issues jose..both FM have

it_events = gt_events[]

comment it once and do a test run

Re: problems excel view in ALV

Former Member — Wed, 25 Oct 2006 09:22:04 GMT

Hi,

Me too facing the same prob then i took alternate method List->Export->Local File->Spread Sheet->File Path & File Name-> Generate. U may use this method if client is ready to accept that.

Cheers.

Re: problems excel view in ALV

Former Member — Wed, 25 Oct 2006 09:33:00 GMT

Hi Pankaj,

I am also having same problem . I hv commented out it_events = gt_events[] and tried but same prob. Giving warning message from xl as "Thsi workbook has lost its VBA Project, ActiveX controls and any other programmability- related features. If i poress on the OK button then it opens xl sheet but without any data. Why itis happening , any idea?

Thanks in Adv,

Cheers

Re: problems excel view in ALV

Former Member — Tue, 05 Dec 2006 08:38:46 GMT

I had the same problem and solved it by changing the security->trusted publishers setting in EXCEL... select both 'Trust all installed add-ins...' and 'Trust access to Visual Basic Project'.