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 …

@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)

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.

Please refer the below post. [image] How to set/unlock the password in excel file? Help Hi @11115 , It has an activity called “Set Password” . This will help you. Regards Balamurugan.S

Thank you @Vivek_Arunagiri and @anupamck , You can get this package in UiPath Go also. [image] UiPathGo - BalaReva Excel Activities Marketplace Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activitie…

@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

Hello @Rahul_S , In the below link , you can get the sample project. [image] BalaReva.Excel.Activities Community Feed 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 workshe…

Problem with Password Protected Excel file

Help

anupamck (Anupam Krishnamurthy) March 20, 2019, 2:00pm 5

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.

Thank you @Vivek_Arunagiri for pointing me there

Topic		Replies	Views
Open Excel document that requires a password to modify Help excel , activities	14	8215	April 7, 2018
Excel Passwords Help excel , activities	9	10641	February 6, 2018
Add password to Excel file Help excel , activities , question , security	7	7336	September 30, 2020
How to enable editing in excel in uipath Help datatable , excel , uiautomation , activities , studio	7	7195	March 31, 2022
Apply Password to the existing excel without using excel application scope Activities excel , activities , question	11	325	January 3, 2025

Problem with Password Protected Excel file

Related topics