Excel Output Files - Password protected

Question

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

pedrodrfaria · Answer

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-with-write-xlsx

Hope this helps.

Pedro.

HannahSwain7 · Answer

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

Thank you,

Hannah

afv2688 · Answer

Hello @HannahSwain7 ,

Have you checked this post?:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-and-Output-password-protected-XLSX-files-in-Alteryx/td-p/142295

Regards