How to read password protected excel file

Help Activities
, ,
1

How to read password protected excel file

2

Hi @Aleem_Khan

You can set the password property of the read range activity accordingly and read the password protected excel file

image

1 Like
3

in read range there password property will be there give your password as string format

1 Like
4

@Aleem_Khan

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

1 Like
5

Can you please elaborate with example

6

@Aleem_Khan

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.

1 Like
7

@Aleem_Khan
Have a look on this thread->

8

Hello @Aleem_Khan

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.

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.