alv report in excel view

[Former Member]

hi friends..

now i am displaying the data in alv grid..

my requirement is i want to display the data in excel format.. (not in seperate excel..)

i want to display the excel sheet with data within the screen itself.

for this

i tried this scenario by fallowing steps

in layout->view tab->microsoft excel..

(layout button in the application toolbar i.e pf-status)

it show excel sheet within report but no data with excel sheet.

how can i get the data into that excel sheet.

its very important..can you please tell me

[Former Member]

hi selva

you can use PF status in your ALV Report....include ICON_XXL for exporting data into Excel sheet....

i have used it it wil def work...

reward if useful....

[Former Member]

Selva,

This is security setting issue in Excel.

Open up MS Excel on your desktop...

From the Excel menu bar, choose: Tools > Macro > Security...

In the pop-up, change to the Security Level to Medium (or Low - if necessary).

And don't forget points for helpful answers!!!

[Former Member]

hi friends..

now i got data in excel sheet.

but my requirement is if i made any changes in data in excel means

i want those updated or edited data in the another internal table..

this scenario is work in the case of abap list viewer (instead of microsoft excel)

for this i use one button in the pf-status (UPDATE).

after made changes in grid data i export those modified data to abap memory and download to another internal table..

how can i get the same scenario in micosoft excel

[Former Member]

hi john ..

thanks 4 ur replay that was help full..

can you proceed for the above query