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
@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-password-protected-Excel-Files/td-p/1082514 Hope that helps,
Ollie
Adding to @OllieClarke 's fantastic links, the R Version always works for me. My favourite tool from R so far.
