I was able to crack the blue prism but instead of reading 10 records form the excel bot is only reading records from 2-11 that is 9 records and updating those 9 records in the rpachallenge site.
I am using BP version 5, using open source excel (file name is saved as xls).
From VBO MS Excel using
1. Open Instance
2. Open Workbook
3. Get Workbook As Collection
4. Closing the workbook instance
I am using BP version 5, using open source excel (file name is saved as xls).
From VBO MS Excel using
1. Open Instance
2. Open Workbook
3. Get Workbook As Collection
4. Closing the workbook instance