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

[Shristy]

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

[Abinathsiva]

Hi,

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

[Shristy]

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

[Jigang_Zhang]

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.

[Shristy]

Its standard Microsoft excel button present on the toolbar.
Any configuration needs to done for this, any idea
Thanks

[Jigang_Zhang]

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

[Shristy]

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