Problem with Password Protected Excel file

[anupamck (Anupam Krishnamurthy)]

I am trying to use the Write Range activity to write a datatable into a password protected Excel file.

If I use the Application Integration Activity (with Excel App scope) to write into a password protected cell range, I get the “Range does not exist” error message.
I have already tried inputting the “Password” and the “Edit Password” options here. That does not help.

If I use the System Integration Activity, it disturbs the formatting of the Excel Template - especially cell borders.

Is this a bug or a known issue? How do we get around this?

EDIT: Certain ranges within a particular sheet in my Excel are password protected - not the entire file itself. I want the robot to be able to make edits in these protected ranges.

[Rahul_S (Robot_L)]

@anupamck

While taking Excel Application Scope if you pass password in Properties it will perfectly work.

Find attached implemented solution.ExcelPassword.zip (20.0 KB)

[anupamck (Anupam Krishnamurthy)]

Hi @Rahul_S

Thank you for your response. Unfortunately, it doesn’t solve my problem.

I must make a clarification here. My entire excel file isn’t password protected - just select fields in a worksheet are locked for editing. I want the robot to be able to input something into these sheets.

[Vivek_Arunagiri]

Please refer the below post.

How to set/unlock the password in excel file?

Hi @11115, It has an activity called “Set Password” . This will help you. Regards Balamurugan.S

[anupamck (Anupam Krishnamurthy)]

The activity called Protect Unprotect, developed by Balamurali as a part of the BalaReva excel activites solved my problem here.

Thank you @balupad14 for developing this package! This is a real service to the community.

BalaReva.Excel.Activities

Hi Friends, I have included some new activities that merge and unmerge the cells Name Space : [image] Merge Cells - Merge the cells inside the excel file. Properties : [image] Sample File : MergeCells.zip (24.9 KB) UnMerge Cells- Unmerge the cells inside the excel file. Properties: [image] Sample : UnMergeCells.zip (24.8 KB) Let me know if you have any errors. I would be happy to get more suggestions Regards Balamurugan.S

Thank you @Vivek_Arunagiri for pointing me there

[balupad14 (Balamurugan)]

Thank you @Vivek_Arunagiri and @anupamck,

You can get this package in UiPath Go also.

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. https://go.uipath.com/component/balareva-xl-activities This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using…

Regards
Balamurugan.S

[Rahul_S (Robot_L)]

@anupamck

Is it possible for you to send sample excel file which you are talking about?

So, we can get exact idea what you are trying to do

[balupad14 (Balamurugan)]

Hello @Rahul_S,

In the below link , you can get the sample project.

BalaReva.Excel.Activities

Hi Friends, I have included the below new custom components in the package. 1.Create Workbook.(Create a new worksheet) 2.Copy to File (Copy the worksheet to another excel file). 3.Copy to WorkBook (Copy the worksheet inside the workbook). 4.HideUnhide the worksheet 5.Protect Unprotect the worksheet [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

Regards
Balamurugan.S