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: 

reg excel view

Former Member
0 Kudos

hi friends..

i hav one issue in alv..

now i am showing my report in alv grid.

for eg suppose i want to show my report in excel view by pressing one custom button in application tool bar..

how can i get tis..

i know by using layout we can change the view

is there any possiblities by dynamically change the layout from normal alv grid to excel view only after user press the button in application tool bar

3 REPLIES 3

Former Member
0 Kudos

u first assign <fcode> for that buton.

u have to write

case sy-ucomm.

when <fcode>.

call fm gui_download---here u have to enter u r table name, download path for file with .xls extension (as mode 'dat')

endcase.

u will get it

0 Kudos

hi madhavi..

thanks for ur replay..

i don't want that excel as a seperate file.

i want that excel view in the screen itself..

note..

layout option we can change but i want it as seperate button.. can you tell me standard fcode for excel view in the screen itself

suganya_rangarajan
Participant
0 Kudos

Hi deva,

I have the same issue as yours.I want to have excel embed in ALV without using the 'change layout' button.

Can you tell me how you resolved the issue?

thanks

Suganya