Close popover
Mangesh Walhe (Mangesh Walhe)
Sr. System Architect
Pegasystems Inc.
Mangesh Walhe Member since 2018 15 posts
Posted: November 26, 2018
Last activity: December 13, 2018

Dealing with latency while changing the Excel worksheet

Version: Using Pega Robotics Studio 8.0.1088.0

Problem: There is some latency observed when we switch to another worksheet inside a Workbook opened with an ExcelConnector. At times, the operation executed immediately after switching (by assigning the target worksheet name to property 'Worksheet' of the ExcelConnector) , for example GetCellValue(), we end up getting value from the previous sheet and not the intended one. Problem is the delay is fairly random and depends on system response of the machine.

Is there a way in which we can recognise that change of worksheet has been completed so that we can be sure that we are executing the operation for the correct worksheet all the time?

Robotic Process Automation
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.