Is there any easy method available to read password-protected Excel files?
When we use the normal “Read Excel” activity, it pops-up the password input pop-up message and waits.
Can we send a password as an argument or some other way to continue without hassle??
@Tharindu_Prasad, with “Read Excel” activity is not possible. I would suggest you to automate the process of opening the file with Excel, enter the password, then unprotect it and finally save it as a temp .xlsx file. At that point, you can work with the temp file with all MS Excel activities.