Skip to Content

In ALV grid report ,the excel sheet does not display any data.

In ALV grid report , when we click on Microsoft Excel button(CTRL+SHIFT+F7) , the excel sheet does not display any data.

I have already enabled all macro setting, still not getting any data in excel.
Any help would be appreciated.

Thanks in advance !!

1.png (15.6 kB)
2.png (61.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jul 28, 2020 at 11:14 AM

    Hi,

    Check the Fieldcatalog code, refer all field element are mentioned in CAPS.

    Add a comment
    10|10000 characters needed characters exceeded

    • Do we write any thing else for excel functionality, its an standard functionality right?

      Its is my code for field-catalog

      fieldcatalog-fieldname = 'ZSP_ID'.
      fieldcatalog-seltext_m = 'Id'.
      fieldcatalog-col_pos = 0.
      APPEND fieldcatalog TO fieldcatalog.
      CLEAR fieldcatalog.

      Please guide me.

      Thanks

  • Posted on Jul 29, 2020 at 02:52 AM
    1. if it's standard Icon button, then no need to do anything. Maybe try to re-login if some ALV setting/field changes. Sometimes it's not refresh everything immediately for me.
    2. If it's a customized button, then check the table populate logic at customized code.
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 29, 2020 at 06:17 AM

    @Shristy,

    As this icon already there and excel can be triggered, I think all ALV setting is fine for this button.

    I'll check the internal table contents and debug the Click Event.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2020 at 06:01 AM

    Thanks to all for your help.
    I have raised issue to SAP.
    Hope it helps me to get the issue fixed.

    Add a comment
    10|10000 characters needed characters exceeded