Check Write Access Restriction for Excel

[CC_Pet]

Hi, currently having issues with opening excel files as UiPath interaction with the 2 types of protection are different in excel scope. To my knowledge, password protected excel will require the Password field to be populated while the write access restricted excel file will need the Editing Password field to be populated. At the moment, I have no way to know which type of protected excel file I am receiving and so if I open a write access restricted excel file using Password field, it will open the excel file and the password input field will open causing the bot to get stuck at this step as it won’t go to the next activity.
Maybe is there a way to do a check without opening excel to see if a file is password or write access restricted?

[suraj.setty]

Hi @CC_Pet

Please have a look

Check Access To File Using UiPath

How to check if the read write permissions on a file using UiPath? To check if write access is present on a file for the UiPath Robot user, Write a code in an “Invoke Code” activity. Arguments : Name : path Direction : In Type : String Name : result Direction : Out Type : Boolean Value : res Code: Dim writeAllow As Boolean = False Dim writeDeny As Boolean = False Dim dInfo As New DirectoryInfo(path) Dim accessControlList As System.Security.AccessControl.DirectorySecurity = d…

Thanks

[CC_Pet]

Hi @suraj.setty, trying the code you have shared seems to always return True result even though I have not set any access restrictions.

[CC_Pet]

I tested on a file that requires password to get write access and according to the code, there is no access control when there should be: