Convert Excel to Dictionary

[sandeep13 (Sandeep Pathak)]

https://go.uipath.com/component/convert-excel-to-dictionary-key-value-pair

Hello guys
I am very happy to announce to my first component has been published and you can see it
I request you to give your valuable feedback and review.

Thanks

[venkatmalla6 (venkat malla)]

@sandeep13 that’s really cool man. Congrats.

[sandeep13 (Sandeep Pathak)]

thanks, man @venkatmalla6

[Mara_Pitiga (Mara Crainic)]

Congratulations, @sandeep13!

[sandeep13 (Sandeep Pathak)]

Thanks @Mara_Pitiga

[MF.RPA (M.Farrell)]

@sandeep13

Hi, When attempting to use this add on I receive an error message stating that “Excel to dictionary: only .xls or .xlsx file allow”. I have tried using files formatted as both file types and still receive the same error message.

[sandeep13 (Sandeep Pathak)]

@MF.RPA
I checked . its working fine…
Could you download latest package from Connect?
send me Workflow so I go through it

[sandeep13 (Sandeep Pathak)]

and one more think, file path must have .xls or .xlsx extension
like c:/Book1.xlsx

[gaffar_shaikh]

Hi @sandeep13

i want create a dictionary of excel header as key and corresponding as values

plz help

want to add name, age, city, country to key and gaffar, 27,mumbai,india as values

any help will be deeply appreciated

[sandeep13 (Sandeep Pathak)]

Hi @gaffar_shaikh
Dictionary data type contain only key , value pair,we can create dictionary like all header as key.
You need type of Excel for Create dictionary

I am not sure about your Task but I suggested you should used Read Excel activity to read Excel and store data in Data table , then use it further in the process

Thanks