Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Shristy
Explorer
0 Kudos
898

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

6 REPLIES 6

Abinathsiva
Active Contributor
290

Hi,

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

0 Kudos
290

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张吉刚
Active Contributor
0 Kudos
290
  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.

0 Kudos
290

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

Jigang_Zhang张吉刚
Active Contributor
0 Kudos
290

@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
Explorer
0 Kudos
290

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