Question

5
Replies
147
Views
Hari Busarapu (HariB209)
Upton Hill

Upton Hill
US
HariB209 Member since 2019 16 posts
Upton Hill
Posted: April 30, 2020
Last activity: May 7, 2020
Posted: 30 Apr 2020 12:03 EDT
Last activity: 7 May 2020 14:45 EDT
Closed

Pega Robotics Excel connector issues

Hello I have 2 questions

 

1) Iam trying to save/download excel file from a web application and then edit the excel. The process is when i hit save button on the webapp the excel file should be downloaded into my downloads folder. In my automation iam using file exists before i proceed to next step of editing the file but file exists method returns false as file hasnt completed download yet. There is no waitforcreate option for files. Any suggestions how to resolve this

 

2)I am actually trying to update cells(rows) with same formula and there are 70,000 rows in the excel and doing a for loop and updating using set cell value takes 45 mins. is there a way to bulk updates of cells in excel ? Or is there a way to use SendKeys to flash fill all the cells in the column. Same formula need to be copied to 70k rows. Other option I thought is writing a C# script to create OLEDB connection from Excel and do bulk updates. Please let me know if there is better solution for this.

Robotic Process Automation
Moderation Team has archived post, 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.