Hi All,
Good Morning...
I am currently facing an issue while performing excel operations inside a loop. I have to apply multiple excel functions(vlookup, IF) in a workbook. I have placed the function values, column name in a collection and the using the collection to loop through the excel and perform each functions. I am creating the excel instance and opening the workbook outside the loop and inside the loop I am just performing the copy paste functions and finally outside the loop I am copying the workbook values in a collection. The issue is inside the loop I keep facing either of these issues
1. "The given key was not present in the dictionary." Facing this even with Attach Instance.
2. "The workbook xyz.xls is not present in the instance".
There is one fix available, ie., to create and close instance inside the loop but that is time consuming and some how I feel is a waste of resource.
In the attached screenshot you can see the flow. Any suggestion on how we can fix this issue is very much appreciated.
Thanks,
Parnab
------------------------------
Parnab Sinha Choudhury
RPA Developer / Business Analyst
------------------------------
Parnab Sinha Choudhury
RPA Developer / Business Analyst