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.