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: 

Download a password protected excel file with (some) readable column

Former Member
0 Kudos

Hi Experts,

I have a requirement to-

1. Download an excel file

2. Some columns of this excel file will be readable (not all columns).

3. The excel file will be password protected.

Now,  I have found a function module (MS_EXCEL_OLE_STANDARD_DAT) to create an password protected excel file, but it will not help me to create the readable column. So is there any function module that will help to create an excel file with above 3 features or any function module that will create a readable column after createing the password protected excel file.

Thanks and Regards,

Suman

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Suman,

Check this link.

http://wiki.sdn.sap.com/wiki/display/Snippets/Download+Data+into+Multiple+Sheet+Excel+Document+with+...

This will show you how to download into multiple sheets as well.

Thanks,

Shambu

1 REPLY 1

Former Member
0 Kudos

Hi Suman,

Check this link.

http://wiki.sdn.sap.com/wiki/display/Snippets/Download+Data+into+Multiple+Sheet+Excel+Document+with+...

This will show you how to download into multiple sheets as well.

Thanks,

Shambu