Hi, I am opening a password protected excel using excel application scope and writing values to it using write cell activity. It seems to only open in read only mode (despite having the readonly checkbox unchecked) and when i exit the excel application scope it saves the spreadsheet under my docum…

Thanks for the reply. I see a difference between our files. Yours opens showing the below [image] Mine opens showing this. Do you know how to change this? [image]

Hy @Automater999 , I have changed the file to match your case and faced the same error you faced. My question to you is: can you change your file to match mine? In Excel, if you click Save As => More Options => Tools => General Options you will see that there are two passwords, on for protecting a…

Editing password protected excel and saving it

Help Studio

William_Blech_Sister (William Blech Sister) June 15, 2020, 11:20am 2

Hy @Automater999,

I made a simple workflow to test it and it worked easily.

Please have a look at it and let me know if you have any questions

EditProtectedExcel_Test.zip (32.7 KB)

Regards

Topic		Replies	Views
Excel is read-only Help excel , activities , question	5	2466	January 22, 2021
How to enable editing in excel in uipath Help datatable , excel , uiautomation , activities , studio	7	7159	March 31, 2022
Edit a shared excel workbook Help	8	2642	September 28, 2018
UiPath Excel Workbook Activities ---> Bypasses Password Protection (Possible Bug) Help studio	13	3658	May 29, 2019
Protecd excel with pwd Help	12	2278	March 22, 2018

Editing password protected excel and saving it

Related topics