topic Re: reg excel view in Application Development and Automation Discussions

reg excel view

Former Member — Mon, 05 Nov 2007 05:02:20 GMT

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

Re: reg excel view

Former Member — Mon, 05 Nov 2007 05:07:11 GMT

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

Re: reg excel view

Former Member — Mon, 05 Nov 2007 05:11:30 GMT

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

Re: reg excel view

suganya_rangarajan — Wed, 30 Jan 2008 20:18:20 GMT

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