Question
Pegasystems Inc.
JP
Last activity: 13 Dec 2018 20:02 EST
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?
Pegasystems Inc.
JP
Solution tried:
Using WaitForEvent on ExcelConnector.SheetActivate, setting it up with Property ExcelConnector.Worksheet = Target Worksheet name, and on fired proceed with actual task.
Works fine.
Only problem with this is that we will have to add it in all the places wherever the target sheet is being switched to.
Need your opinion whether this is a right approach.
