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: 

Regarding ALV output export to Excel

Former Member
0 Kudos

Hi All,

Am displaying few fields in ALV using REUSE_ALV_GRID_DISPLAY FM. Till ALV Output we are able to achieve the user requirement. But while exporting the output to excel using LIST-->EXPORT-->LOCAL FILE-->SPREDSHEET the header of two fields are coming up with 3 extra spaces. Fields are of character type and we have cheked it in fieldcatalog also. inside Filecatalog the text dont have any extra spaces.

Could anyone please suggest some ideas to remove those trailing spaces from the header. Kindly note that the system is ECC4.6.

Thanks In Advance

Arun

2 REPLIES 2

hugo_amo
Employee
Employee
0 Kudos

Hi Arun,

Have a lock at note #569537.

There are several ways to export a ALV Grid, also an export way via XXL.
It' described in note #358644.
Exporting to a local file should be used for big amount of data.
There are no limitations like XXL export (defined by excel).

So keep in mind, by using download list -> export -> local file -> spreadsheet
You should start excel first and then use the excel import assistant (data -> import external data -> import data)
So you should set '"' to 'none' for text recognition in the excel import assistant to ensure, that the following columns could be loaded as column and not as text.

Regards,

Hugo

hugo_amo
Employee
Employee
0 Kudos

By the way that FM REUSE_ALV_GRID_DISPLAY is SAP internal function module, you should not use it.

Regards,

Hugo