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
Showing results for 
Search instead for 
Did you mean: 
Read only

Export to Excel with protected columns

Francis417
Participant
0 Likes
507

Hi,

I have written some abap program which use the FM 'REUSE_ALV_LIST_DISPLAY' and I would like to know if it is possible to have some of the columns protected when I export the data from the ALV list to Excel.

For example, in the ALV list display, I have the following columns

Personnel No., Organizational Unit, Basic

And I want to protect the column for Basic automatically once the data are exported to Excel. Is it possible?

Thanks.

Hi,

I have written some abap program which use the FM 'REUSE_ALV_LIST_DISPLAY' and I would like to know if it is possible to have some of the columns protected when I export the data from the ALV list to Excel.

For example, in the ALV list display, I have the following columns

Personnel No., Organizational Unit, Basic

And I want to protect the column for Basic automatically once the data are exported to Excel. Is it possible?

Thanks.

1 REPLY 1
Read only

Former Member
0 Likes
284

Hello Francis,

To be precise, your requirement cannot be accomplished directly using the FM <b>REUSE_ALV_LIST_DISPLAY</b>.

You would have to resort to OLE for that. Here's another thread which discusses how that can be done -

Regards,

Anand Mandalika.