Excel Output Files - Password protected

[HannahSwain7]

Morning all,

I have been using the R tool to remove passwords from excel input files. Is there a way I can use the R tool to put a password on the output files please?

Thank you,

Hannah

[afv2688]

Hello @HannahSwain7 ,

Have you checked this post?:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-and-Output-password-protected-XL...

Regards

[HannahSwain7]

Yes I looked at this post but ideally wanted to use the R tool rather than macros.

Thank you,

Hannah

[pedrodrfaria]

Hi @HannahSwain7 

Here is a post from StackOverflow regarding how to do this.

https://stackoverflow.com/questions/50867641/how-do-i-password-protect-an-excel-file-created-in-r-wi... 

Hope this helps.

Pedro.