A RDA uses an excel connector with Visible component property = False.
In automation also excel Visible property is set to False.
But if a user opens another excel file during the automation run, he sees the automation excel file openened behind his one.
Then, the automation looses its excel control and gets an error since it doesn't succeed in filling cell i.e. using excel: Error executing link in Automation: ... Invalid worksheet cell: ...
Are there other properties or ways to get an excel session only for the automation to avoid that resources conflict?
Thanks in advance
Let me know which version of Robotics you are using at your end. Have you tried setting visible parameter to 'true', if not try once as by setting visible to false the main excel will not be visible for runtime.
Also share the complete automation screenshot.
Posted: 3 years ago
Posted: 27 May 2019 3:44 EDT
Ubaldo Di Giovanni (UbaldoD0)
Pega Robotics version is 8.0.1090.0
I've set Visible=True in the excel connector component and let Visible=False in the automation (i.e. only when using component) and it seems to work.
Even if I open and update another excel file during the automation, hidden excel file of the automation is not visible and is correctly updated.