Sending password protected excel attachment with multiple worksheet in background

[former_member574546]

I have done creating an excel attachment with multiple worksheets using xml method and attached to mail in backend using FM 'SO_DOCUMENT_SEND_API1'.Now, I have to create a password protection to the attachment. Pls anyone can help me to do that with xml method

[matt]

Don't use the function module, use the CL_BCS classes.

Abap2xlsx is the way you should be creating Excel spreadsheets. Then you'll be able to password protect easily. This question has been asked many times. You should search before posting.