Error "Given key is not present in the dictionary"

Hi Team,

I am facing attached issue while using excel loop. I have used if condition and write to excel activity inside an excel loop. What could be the reason for this error?

Hi,

Column in which you are trying to write either is not present or you are trying to write a null value

Regards,
Amit

Hi Amit,

Column is present in the excel. Please find below screenshot. I am trying to write in column H and the value which am writing is non zero.

Hi,

Is it happening for a specific row in excel you are using in Excel loop or happening in general

Regards,
Amit

Hi Amit,

It is happening for specific excel. I tried to create new excel with same column names but still facing the same issue. Please help.

Hi,

If it is not happening in general, lets focus on this i excel only and data present inside it. Have you applied filters in this excel. From the screenshot you have attached it is shown. Try removing it and running process
Also, wanted to confirm if this is happening for all data row or specific row

Even I am facing the same issue. I have not applied any Filter. But i have applied vlookup on the columns. Please help in resolving that.

Regards,
Pooja Parameswaran

Hi,

Can you please elaborate and explain your issue in detail in separate thread

Regards,
Amit Anand