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?