Password property of Excel Application scope doesn't accept Secure String


#1

Scenario: Excel is password protect and we are reading password from asset using Get credentials

Steps to reproduce:

Current Behavior: Error message ‘System.Security.String cannot be converted to String’

Expected Behavior: It should accept Secure string else no point of reading encrypted password from asset.

Studio/Robot/Orchestrator Version: 2016.2.6274

Last stable behavior:
Last stable version:
OS Version:
Others if Relevant: (workflow, logs, .net version, service pack, etc):


#2

Yes.
As excel password property is of type string hence it doesn’t support.
However you can still manipulate secure string to string and pass it.
string password = new System.Net.NetworkCredential(string.Empty, securePassword).Password;
It’s not just for excel, many activities requires secure string as default password field.