Hi all Good afternoon,
I am able export data to excel but I want lock the cells in which the data has been entered in the excel. Do we have any option like locking cells in excel through dynamo ?
I don’t want to alter any of the exported data by any user. So it will be helpful for me if I get solution. Thanks in advance.
Hi,
I think you’ll need to work in Python to get what you want… The package BumbleBee allows you to get inside and have a look, for example by using the Python in the ‘Write Excel’ node and adding 'Password = “test” to the SaveAs, I was able to create a password protected file…
wb.SaveAs(unicode(filePath), Password = "test")
This post by @c.poupin & @GavinCrump also discusses how you can create workflows…
Though you may have to play around with the Microsoft Docs…
Best of luck, hope that is useful,
Mark