How to enable editing in excel in uipath

[tgopalas (Tanuja)]

Hi all,

How can i write into excel when it is in protected mode, any activity for that?

Thanks in advance

[dna (Dna Hjd)]

Hi,

Using Excel Application Scope, that has a property
EditPassword if the excel can be edited only with a password and also a
Password property, if the whole table is protected.

[dna (Dna Hjd)]

And I have found this…

Excel Passwords

Apologies if this is a duplicate but I couldn’t seem to find an answer. I have run into problems when getting UIPath to access password protected documents. My current project required me to open a password protected Excel sheet, but each approach I have tried has yielded no results. This is what I have tried so far; Enter the password into the Password property of Excel Application Scope. Enter the text once the password box appears. Click within the password field once it appears an…

[tgopalas (Tanuja)]

Hi,

The sheet is not password protected, just we need to click enable edit option, so for that i want to know whether any activity is there or not.

Please find the attached screenshot

[dna (Dna Hjd)]

Hi,
If I try to do something in an excel, that is protected like this, I do not have any problems. I tried using Excel Application Scope and to see if it works, I’ve created a random datatable that I put in an AppendRange activity, and it worked! What would you like to do in that excel? If something that you can do in Excel Application Scope, it has to work.

[Lucas.Pimenta]

Hello!

This is not a problem when you use “Excel Application Scope” activity. It will work without problems

Regards,

[mitradev_das]

same issue happened in my current project as well, so if anyone knows how to get rid of it, please let me know. Thanks…!!

[ushu (Usha kiranmai)]

@mitradev_das As like @Lucas.Pimenta you can use excel application scope to get rid of this issue