Hi All,
An existing process which interacts with Excel is very slow after Blue Prism upgrade.
Background: Existing process was developed in BP version 5 and it is working fine for more than a year.
Now, we tested the process by importing it to BP 6.7.1 and found out that it very slow.
Below listed steps are taking almost 20 minutes to get completed in BP 6.7.1, whereas it got completed within a minute in BP V5.
- Bot opens two excel files (
MS Excel VBO: Create Instance -> Open workbook -> Show -> Remove Blank rows)- Navigates to Each cell and gets cell value in both excel files (
MS Excel VBO: Select - > Get Cell value)- Compares the value
- Moves to the Next cell (
MS Excel VBO: Go to Next Cell)- It repeats the steps for 10 cells.
- Closes the files. (
MS Excel VBO: Close Instance)Has anyone faced the similar issue? Kindly provide your thoughts.
Thanks in advance
------------------------------
Fazil
------------------------------