Creating Dictionary From Excel File

[Krishan_Rapswal]

Hello Guys,

I want to Create a Dictionary from Excel File as a Parameter

Books List.xlsx (16.5 KB)

[raja.arslankhan]

@Krishan_Rapswal do you want to read excel file as a Dictionary?

[Krishan_Rapswal]

yes correct

[supermanPunch (Arpan)]

Hi @Krishan_Rapswal ,

We see that you have created duplicate posts :

Using Dictionary to get the value from Output Of an Excel in New Sheet

From the Output of the Excel Sheet, I have to extract value in new Sheet Using Dictionary For Example:- In Output I have 100 rows but in new sheet i need selected rows only (From a Column “Rating” :- Value is 4.3 or greater than 4.3 ) Books List.xlsx (17.1 KB)

ConfigFile Dictionary In Excel

What is Wrong With This ConfigFile Main.xaml (8.6 KB) Excel File :- Books List.xlsx (16.5 KB) This excel file should be dynamic and stored the data in Dictionary ( If i take another Excel File The program will work and if i change the excel file data it will change according to that )

Use Of Dictionary In Excel Sheet

How to get the value from a Excel Sheet through Dictionary in new Sheet For Example In Given Excel file i have 100 rows , If i want only 30 rows or 55 rows in another sheet through Dictionary Or their is a Column Rating If i need 4.3 or Greater value through Dictionary How we get it Books List.xlsx (18.2 KB)

Do avoid duplicates, as it is the same topic being presented again.

We would suggest you to get the requirements in check and provide us with an Input and the Expected Output data in the form of Excel sheets, so that we can have a proper visualisation of the requirement.

We will not be able to help if we do not get the complete understanding of the requirement.

For a more thorough check, we could have a one-to-one discussion and explain the requirement in detail.

[Krishan_Rapswal]

I am not getting the satisfied answer
i am sorry

[Gokul_Jayakumar (Gokul Jai)]

Hello @Krishan_Rapswal
Kindly refer to this video you may get some idea

UiPath | Dictionary Variables with Example | Key Value Pair | EN | Yellowgreys - YouTube

Add to Dictionary Activity in UiPath with Example

[Krishan_Rapswal]

but when i change my data "Average of rating " in excel file it is not changing in the output of the program
( I am using Average of rating as Dictionary Value)

[RK_0 (RK)]

Hi,

Can you share snapshot of the method you are using to convert and please
Refer to the below xaml.
ConvertDataTableToDictonary.xaml (6.8 KB)