Read/Write Password protected excel files

[mohit9garg]

Can I read and write password protected excel files?
I want to save password protected files and need to update the same file in subsequent runs.

Thanks

[OllieClarke]

@mohit9garg Alteryx cannot natively read from and write to password protected excels. 

I've seen a number of different approaches to this problem, but here's an Alteryx KB which shares some R code to read a password protected .xlsx file into Alteryx. 
https://knowledge.alteryx.com/index/s/article/R-code-to-extract-password-protected-file-in-Designer 

I've also seen python solutions, and even VBS ones too. There are lots of threads on this, but this one is relatively recent and has a robust discussion. https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Alteryx-to-read-and-output-pas... 

Hope that helps,

Ollie

[caltang]

Adding to @OllieClarke 's fantastic links, the R Version always works for me. My favourite tool from R so far.