Alteryx Designer Desktop Discussions

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

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

AkisM
10 - Fireball

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 Alumni (Retired)

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
13 - Pulsar
13 - Pulsar

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

Labels