Reading multiple excel file with password protected and save it another excel file

Help Studio
, ,
1

Dear community,

Currently, i try to explore on UiPath to read the multiple excel file with password proctected file and save the data in the new excel file.

May i know if there is any workflow that can i refer to for this issue?

Many thanks

2

Hi @SH_94
You can try the excel application scope, in that there is an option to enter password

image

or in workbook activities, u have the option to enter password

Thanks & Regards,
Nived N

3

Hi @NIVED_NAMBIAR ,

Below is my attached workflow. Could you please advise on how to edit the workflow so that i can save the data in another excel file?

Thank you.
MultipleFiles.zip (23.2 KB)

4

for every file , there is unique pwd right ?

5

Hi @NIVED_NAMBIAR ,

Sorry for the confusion, you may refer to the attached file below ( with password protected)

The password for each file is the same which is “abc”
NewMultipleFiles.zip (23.7 KB)

6

Hi @SH_94
sorry for delay, u need to combine all excel data into single excel right?

7

Hi @SH_94
Kindly find the attached workflow

MultipleFiles.zip (29.0 KB)

8

Hi @NIVED_NAMBIAR ,

The combining of excel file i have did it ady. The part that i stuck is the reading the password proctected excel file and save it in other excel file. You may refer to the attached file below for reference.

I also went through the file provided and notice there is error as below:

image
image1470×563 37.6 KB

May i know what is the activity being used in this case?
NewMultipleFiles.zip (23.7 KB)

9

It is read range

10

Hi @NIVED_NAMBIAR ,

Thank for the prompt response. Could you help me to look at the file that i shared below to open th password proctected file ?

Thank again.
NewMultipleFiles.zip (23.7 KB)

11

Hi @SH_94

As i mentioned in below, you can add the password in password field of excel application scope. That is all is needed.