Excel connector session lost
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?
Any suggestion?
Thanks in advance
Accepted Solution
Comdata Digital
IT
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.
Pegasystems Inc.
IN
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.
Accepted Solution
Comdata Digital
IT
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.