How to covert data from excel file to dictionary?

Help
1

I would like to convert my data from the entire sheet in excel file to dictionary. Please help!

2

Hi
This could help you buddy
https://go.uipath.com/component/convert-excel-to-dictionary-key-value-pair

Cheers @BSC

3

Do I have to sign in using gmail account?

4

No buddy not needed
we can directly download the file just clicking on the link
Cheers @BSC

5

I did click on the link. But it keep bringing me back to the same page.
How do you download this thing?

6

@BSC

Do you have UIpath GO account or not ?

If not then create it and then download that file.

7

No worries
Create an account and download
that would help you in future as well
You were almost done

Cheers @BSC

8

Thank you guys. I probably going to use a different method.

1 Like
9

hi @Palaniyappan

image
image1366×768 88.7 KB

i want to take all the headers in key and corresponding row in a value

using below code i am able to get values but my row number is dynamic

(From c In dtData.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName).toArray
Select Tuple.Create(c, dtData.Rows(0)(c))).ToDictionary(Of String, Object)(Function (t) t.item1, Function (t) t.Item2 )

plz help…