How can I open an Excel file protected by a password

Help Studio
, ,
1

I want to open an excel file that is protected by a password. I’ve difficulties to open the Excel file.
See below print screen.
What did I do wrong?

image
image1317×703 34 KB

2

use excel workbook activity.

Happy Automation, Cheers

Mark Solution if it helps.

3

It doesn’t work. Can you share which activities you used to open an Excel file protected by a password?
I want then to select a particular sheet in the workbook and then say if you see that info on that column insert data on the right 3 columns later.

1 Like
4

Hello Maic Cariani,

What you have done is good. No need to change. I don’t thing that problem come from the password. Create a new sequence and try to only open the excel.

When a exeption appear because the password. Uipath will clearly alert on you about it. With a “Uipath.excel.excelexpetion” with the message “invalid password”

5

What error are you getting?

6

Basically no error (Nothing happens, its not responsding)
I have to enter the password in order to continue the process.

I tried to only put the ativity Build data table and excel application scope (using the password properties) but apparently I’m still not able to automatically enter in the Excel file.

image
image1492×820 227 KB

image
image1452×672 36.3 KB

7

because your file is restricted by another ID. If your excel simply has a password and no restriction then it will work.

But because your file is restricted by another ID, You can try the following first. Open the excel manually then:

  • Click File.

  • Go to Info.

  • Click the drop down for Protect Workbook.

  • Click Restrict Permission by people.

  • And ensure the option Unrestricted Access is selected.

    image
    image961×663 149 KB

Then run your program again and see if it works

8

no it still doesnt work.

9

still showing this popup?

image

10

Hi,

we are using “BelaReva.Excel.activities” which come with set password activities (set to empty would unset password). Please try.

image

image

Brg,

11

yes I still have this pop up. It seems that i dont have the possiblity to open an Excel file because nothing happens ( no error / no log message)

12

I tried that but I ve the same problem.

13

Hi, I still waiting for answer for that topic, could someone have an idea how to copy data to the Excel file protected by a password?

Your help would be much appreciated.

14

Basically it works after filled in 2 times the password under Edit password and Password properties of the activity Excel application Scope

15

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