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: 

ALV Output to Excel file

Former Member
0 Kudos

Hi All,

I am downloading the ALV output to Excel file.I am making use of LIST--->EXPORT--->SPREADSHEET option.

My list is having Header, Footer, sub totals and totals.When i transfer the list i am facing following problems

1.Even i am getting the empty columns betweeen my output.

2.In the Place of sub totals i am getting astericks

3.On the top of the records downloaded,"DYNAMIC LIST DISPLAY" is found.I want to avoid this text on the top

Thanks,

Ravee...

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Ravi,

Try to check this Class in SE24- CL_GUI_ALV_GRID-

In this class you have an method to export it to excel file and also displayeing totlas etc.

EXPORT_TO_SPREAD_SHEET

and for totals etc- use these-

GET_TOTALS

GET_SUBTOTALS

For heading also there are mehtods inthis Class.

This may sove ur issue.

Reward if helpful.

Best Wishes,

Chandralekha

1 REPLY 1

Former Member
0 Kudos

Hi Ravi,

Try to check this Class in SE24- CL_GUI_ALV_GRID-

In this class you have an method to export it to excel file and also displayeing totlas etc.

EXPORT_TO_SPREAD_SHEET

and for totals etc- use these-

GET_TOTALS

GET_SUBTOTALS

For heading also there are mehtods inthis Class.

This may sove ur issue.

Reward if helpful.

Best Wishes,

Chandralekha