Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

ALV GRID

Former Member

‎2005 Nov 11 3:34 PM

0 Likes
3,344

Hi Everybody ,

i am not able to display my result of ALV in Excel sheet when i am clicking EXCEL IN PLACE ?

One more question if my user who is making changes in the excel sheet could it be saved in my internal table and then in my dbase table

Every suggestion is welcomed.

Regards,

Azee

Hi Everybody ,

i am not able to display my result of ALV in Excel sheet when i am clicking EXCEL IN PLACE ?

One more question if my user who is making changes in the excel sheet could it be saved in my internal table and then in my dbase table

Every suggestion is welcomed.

Regards,

Azee

Reply
12 REPLIES 12
Read only

Former Member

‎2005 Nov 11 3:36 PM

0 Likes
2,232

As Aima my self would like clear this concern.

Regards,

Azee and Aima.

Read only

Former Member
In response to Former Member

‎2005 Nov 11 3:40 PM

0 Likes
2,232

Aima,

In the ALV grid, U could Export the data displayed to the Excel Sheet by pressing RIGHT HAND SIDE directed YELLOW Colored arrow mark and choosing SPREADSHEET.

Thanks

Kam

Note: Allot points for the worthful postings

Read only

Former Member
In response to Former Member

‎2005 Nov 11 4:12 PM

0 Likes
2,232

Aima,

In Excel on your PC, from the menu bar: Tools>Macro>Security

In the pop-up window, reduce your security level to Medium or less.

There is an OSS note about this. Microsoft has increased their default security settings in newer versions of Excel.

SAP's "Excel in Place" uses OLE automation (ie. macros, in this case) to switch to the Excel-view. You must grant SAP the ability to do this in newer Excel versions.

Please reward points accordingly.

Read only

Former Member
In response to Former Member

‎2005 Nov 11 4:45 PM

0 Likes
2,232

Hi John Jakabcsin ,

Thanks for ur reply but i tried this before posting this querie but still does'nt works for me.

Regards

Read only

RichHeilman
Developer Advocate
Developer Advocate

‎2005 Nov 11 3:38 PM

0 Likes
2,232

1) Are you sure that EXCEL is loaded onto that PC. If not, then it mostly likly will not work. Also, you may want to check SAP notes.

2) I would say that it is possible with the given technology, but I don't think that you want to go there. The standard functionality of ALV does not offer this. You can present the ALV grid to the user, allow them to change the ALV grid and then save to DB, but not from excel(in place).

Regards,

Rich Heilman

Read only

Former Member
In response to RichHeilman

‎2005 Nov 11 3:44 PM

0 Likes
2,232

Hi Rich,

) Are you sure that EXCEL is loaded onto that PC. If not, then it mostly likly will not work. Also, you may want to check SAP notes.

yes i am sure as i am able to embed excel in place of ALV GRID but culd not be able to view the output in excel!

I would say that it is possible with the given technology, but I don't think that you want to go there. The standard functionality of ALV does not offer this. You can present the ALV grid to the user, allow them to change the ALV grid and then save to DB, but not from excel(in place).

As the user is more familiar with excel and prefers this way .

Read only

RichHeilman
Developer Advocate
Developer Advocate
In response to RichHeilman

‎2005 Nov 11 3:52 PM

0 Likes
2,232

Then I would say that the easiest way to go would be to provide a download program, the user can then do whatever they want in excel, and then have a upload program which would read the data and update the database

Other then that, I would suggest the user imbrace the technology(SAP) that their company is paying big dollars for.

Regards,

Rich Heilman

Read only

Former Member

‎2007 Oct 10 8:09 PM

0 Likes
2,232

Hi, Rich:

My company uses SAP, latest GUI version 710 Final Release, and we just went to Vista with Microsoft Office 2007. Several of my business users are having problems as described here with the ALV reports. They run the report, click on the Excel InPlace icon, and they get either a blank spreadsheet or the following error:

<b>View could not be changed to: &VEXCEL

Message no. 0K000

And this is what comes up when I click application help

Report for Dynpro: SAPLSLVC_FULLSCREEN

Description

Instead of the modules of this function group, you can now use the ALV object model. For the representation kind Fullscreen of the simple two-dimensional tables you use the class CL_SALV_TABLE.</b>

I've looked at OSS notes 339830, 696069 and 1094693, all of which deal mainly with security. I've had my users make those Trust Center changes, but they're still having problems with viewing the report in Excel.

Please keep in mind I'm not a developer; I'm in Applications Support only, but I'm trying to troubleshoot this on my own because I get most of these calls.

Regards,

Ruth

Read only

Former Member

‎2009 Apr 01 1:25 PM

0 Likes
2,232

Hi,

I'd the same problem. When I clicked on Excel Icon in my ALV Grid, I got a Excel sheet. It looked same as correct one, but there wasn't any data. For correct you must set your Excel so:

1.In Tools->Macro->Security you set medium or low level in the forld security level(according to SAP NOTE).

2.In Tools->Macro->Security in the second fold - Trusted Sources in the bottom you must check both check boxes.

and then set OK and close and run your Excel sheet again

best regards

Tom

Read only

Former Member
In response to Former Member

‎2011 Feb 02 10:15 PM

0 Likes
2,232

I ran in to this problem today and your post really helped to resolve the issue.

We were having Office Excel 2007 . I changed the macro level to low ,but it was not working , When i added sapworkdir as a trusted locations in excel.It was working fine.

ThX a lot .

Read only

Former Member

‎2009 Apr 01 1:40 PM

0 Likes
2,232

Hi,

You need to declare layout in your data.

DATA : LAYOUT TYPE SLIS_LAYOUT_ALV,

LAY TYPE slis_layout_alv_spec1.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

  • I_INTERFACE_CHECK = ' '

  • I_BYPASSING_BUFFER =

  • I_BUFFER_ACTIVE = ' '

I_CALLBACK_PROGRAM = SY-REPID

  • I_CALLBACK_PF_STATUS_SET = ' '

  • I_CALLBACK_USER_COMMAND = ' '

  • I_STRUCTURE_NAME =

IS_LAYOUT = LAYOUT

IT_FIELDCAT = FIELDCAT

  • IT_EXCLUDING =

  • IT_SPECIAL_GROUPS =

  • IT_SORT =

  • IT_FILTER =

  • IS_SEL_HIDE =

  • I_DEFAULT = 'X'

  • I_SAVE = ' '

  • IS_VARIANT =

  • IT_EVENTS =

  • IT_EVENT_EXIT =

  • IS_PRINT =

  • IS_REPREP_ID =

      • I_SCREEN_START_COLUMN = 8

      • I_SCREEN_START_LINE = 3

      • I_SCREEN_END_COLUMN = 130

      • I_SCREEN_END_LINE = 25

  • IR_SALV_LIST_ADAPTER =

  • IT_EXCEPT_QINFO =

  • I_SUPPRESS_EMPTY_DATA = ABAP_FALSE

  • IMPORTING

  • E_EXIT_CAUSED_BY_CALLER =

  • ES_EXIT_CAUSED_BY_USER =

TABLES

T_OUTTAB = BTAB

  • EXCEPTIONS

  • PROGRAM_ERROR = 1

  • OTHERS = 2

.

IF SY-SUBRC <> 0.

  • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

  • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Hope your excel tab will get activated with this coding

Read only

Clemenss
Active Contributor

‎2011 Feb 02 10:30 PM

0 Likes
2,232

Hi aima and the rest having trouble,

dont know translate right because my excel is German version:

In Excel, once: Extras -> options -> security, button macro security, tab trustworthy sources, mark 'always trust visual basic project'.

Please, some one provide correct menu path, thanks.

Then Excel in place works.

Regards,

Clemens

P.S.: Ever thought about using a subject?

Edited by: Clemens Li on Feb 2, 2011 11:30 PM