UIPath Excel to Dictionary & LINQ [Add to Dictionary/ LINQ / LINQ GroupBy & Sum]

Hey, Here is my video after long time for "UIPath Converting Excel to Dictionary" using Add to Dictionary/LINQ.

Major coverage
1. Excel to Dictionary using "ForEach & Add to Dictionary"
2. Excel to Dictionary using "LINQ"
3. Excel Data/Datatable Group By & Sum in LINQ then convert to Dictionary

Code Available in github below link

Sample Data can be downloaded from

If have any questions & suggestions please post in the comment section.

Appreciate if you like the video and subscribe to my channel.

Thanks for watching.

[denisovan]

How do you convert it to nested dictionary using linq. Dict (of String, dict(of string, string))
EmpId as outer dictionary key, inner dict keys are other columns.

Result: empid1:{column1name: row value of column1name, column2name: row value of column2name}