Question

3
Replies
46
Views
Mangesh Walhe Member since 2018 15 posts
PEGA
Posted: November 26, 2018
Last activity: December 13, 2018
Closed

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
Share this page LinkedIn