How to read password protected excel file
You can set the password property of the read range activity accordingly and read the password protected excel file
in read range there password property will be there give your password as string format
If the Password is in Encrypted form or Fetch from the orchestrator then Firstly use This Expression for decryption->
Password= new System.Net.NetworkCredential(string.Empty, Input_Password_Variable).Password
After Getting , Pass it as String Refernced by @kumar.varun2
Can you please elaborate with example
if We store credential in orchestrator , it uses AES-256 bit Encryption(Secure String) method for storing the Credential.
We Can not use the password Directly, Firstly we can Decrypt it.
Have a look on this thread->
If your excel is password protected then you need to provide the password to open the file.
In the excel application scope itself you can provide the password of the excel to open it.Else you can provide the excel password in the read range activity.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.