ScribeDocLoad excel file with password

[SailER]

1. Is it possible to work with an excel file that is password protected?

2. What is the syntax to add the password to scribedocload?

Thanks,

Ed

[ryan360Works]

Hi ScribeDocLoad has an optional key=value parameter to pass in a password. You can pass in a password like so:

Set Variable[$load; Value: ScribeDocLoad(someTable::someContainer;"password=MySuperSecretPassword")

 

[SailER]

Ryan,

Thanks for the quick response. I am confused on how to get the script to work. How do I use the $load variable to load the document?

My script works fine on a non-password protected file.

Thanks

[ryan360Works]

Calling a Set Variable script step with a plugin function as the value executes the plugin function. In this case, ScribeDocLoad is executed and will set the value of the $load variable to 1 if the document was successfully loaded or ERROR if there was an error loading the document. 

[SailER]

Thanks for your patience... here's my script -

Set Variable [ $Load; Value:ScribeDocLoad(Invoice::TMMprice;"password=MySecretPassword") ]
// Set Variable [ $MpriceQty; Value:ScribeDocReadValue("Web Price!C8") ]
// Set Field [ Invoice::TMQty; $MpriceQty ]
// ScribeDocCancel

 

This is the error message:

[ryan360Works]

Hi Ed,

I was able to reproduce this error. It seems there is a bug when trying to supply a password for a password protected Excel file. I will report this to our developers. I am not sure when this issue will be addressed but I will bump this thread once I have a fix or more information.