We are in the final days to enter our Data and Analytics - "What's your why?" raffle with SparkED!

Reply with your "why" in text/video format to our forum post by January 28 to be entered! 

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Is it possible to unprotect+protect specific cells of an excel within alteryx?

AkisM
9 - Comet

Is it possible within Alteryx to protect/unprotect specific cells in a sheet that Alteryx will be reading/writing to?

 

If yes, can someone post a sample workflow where alteryx reads from a password protected sheet, then writes to it and protects some of the cells it wrote to?

2 REPLIES 2
mnorberg
Alteryx Community Team
Alteryx Community Team

Hi @AkisM!

 

I'm linking some posts that might help with this issue: A quick tip for reading in password protected excel files and How to Read/Extract password protected Excel file using R Code in Alteryx Designer. The comment section of the first link also includes info on writing to a protected Excel file.

DawnDuong
12 - Quasar
12 - Quasar

I was also searching for a solution for this. Thanks @mnorberg!

Labels