Skip to Content
author's profile photo
Former Member

alv report in excel view

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 01:04 PM

    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....

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 01:14 PM

    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!!!

    Add comment
    10|10000 characters needed characters exceeded