How to enable editing in excel in uipath

datatable
excel
uiautomation
activities
studio

#1

Hi all,

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

Thanks in advance :slight_smile:


#2

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.


#3

And I have found this…


#4

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


#5

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.


#6

Hello!

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

Regards,