Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Header not visible when downloading

Former Member

‎2013 Jul 02 11:46 AM

0 Likes
2,690

Hi All,

Header not visible when downloading using List->Export->Spreadsheet option in ALV repen using List->Export->Spreadsheet download option in ALV rep...

I am trying to download ALV report in an excel file using List->Export->Spreadsheet (Excel in Office 2007 Xlsx format) option, but the ALV header doesn't get downloaded. But if i use List->Export->Local file it shows the alv header in the dowloaded excel file. I checked the basis version, its 702. I tried with fieldcatalogue lwa_fieldcat-ddictxt      =   'L'. But this didnt work either. Is there anyhting else that i should do to get this option? Please help.

Thank you,

CB

Message was edited by: Matthew Billingham - made subject more readable.

Hi All,

Header not visible when downloading using List->Export->Spreadsheet option in ALV repen using List->Export->Spreadsheet download option in ALV rep...

I am trying to download ALV report in an excel file using List->Export->Spreadsheet (Excel in Office 2007 Xlsx format) option, but the ALV header doesn't get downloaded. But if i use List->Export->Local file it shows the alv header in the dowloaded excel file. I checked the basis version, its 702. I tried with fieldcatalogue lwa_fieldcat-ddictxt      =   'L'. But this didnt work either. Is there anyhting else that i should do to get this option? Please help.

Thank you,

CB

Message was edited by: Matthew Billingham - made subject more readable.

Reply
5 REPLIES 5
Read only

Former Member

‎2013 Jul 02 7:00 PM

0 Likes
1,489

hello,

check if you have the event 'TOP_OF_PAGE' when you are displaying the ALV report in the output.

best regards,

swanand

Read only

Former Member
In response to Former Member

‎2013 Jul 02 7:49 PM

0 Likes
1,489

Yes I have used event top_of_page in my ALV report.

Read only

venkateswaran_k
Active Contributor

‎2013 Jul 02 7:15 PM

0 Likes
1,489

In REUSE_ALV_GRID_DISPLAY  -  is following are set?    g_save = 'A' 

      i_grid_title             = grid_title
      i_save                   = g_save   g

Read only

Former Member
In response to venkateswaran_k

‎2013 Jul 02 7:52 PM

0 Likes
1,489

Yes, it is set, point to be noted is, i get the header in my downloaded excel file, if i choose the option 'Local file' from the application tool bar or from menu option List->Export->Local file, but i don't get the header when i choose List->Export->Spreadsheet option. Please help.

Read only

Former Member

‎2013 Jul 02 8:40 PM

0 Likes
1,489

Hi,

CL_DD_DOCUMENT / HTML_TOP_OF_PAGE is used to display on the 'Screen'.

You would need to use TOP_OF_PAGE event to download to 'Excel' .

And PRINT_TOP_OF_PAGE event to print in 'Printer'.

Helpful links below:

http://scn.sap.com/thread/3221653

http://scn.sap.com/thread/3160322

Regards,

Nisha Vengal.