How to avoid loop while adding values in dictionary

Hi All,

I’m having an excel in which there are more than 200k row values in which need to add those values into dictionary without using for loop. Can anyone please share me of how to add the key, value pairs from excel to dictionary without looping the data table, as looping takes more time while debugging the code.

Thanks in the Advance.

have a look here:

keep in mind that the key needs to be unique

Pushing 200k rows to a dictionary raises the question if an alternate can be found to achieve the same. Maybe you can share some more details to your requirements / motivations?

1 Like

Thank you @ppr

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.