reg excel view

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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]

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