how to add Excel File(Output) In Dictionary Using Invoke Method Author is Key & Rating Should Be Value Books List.xlsx (16.6 KB)

Hey @Krishan_Rapswal [image] Hope this is usefull Another alternative is [image (1)] where you can read the excel then apply for each row in data table to make it dynamic. Hope this will help Cheers.

Hello @Krishan_Rapswal Kindly Refer to this thread, you may get some idea. [image] How to use Invoke Method to Add items to Dictionary Help Hi, I want to add items to a Dictionary using the Invoke Method activity and Add method. Can you please tell me what should I supp…

You could also use LINQ: dict = dt.AsEnumerable.ToDictionary(Function(r) r("Author").ToString, Function(r) r("Average of rating").ToString)

I have 90 rows how i will add the data in this using for each ? and in starting we have to use read range activity right?

@Krishan_Rapswal Something like this [image] [image] Give row(“ColumnName”).tostring as key that you want to add and also Give row(“ColumnName”).tostring as Value [image] Hope this helps you Cheers.

[Screenshot (21)] there is no add to collection option in activity and what to find in packages?

@Krishan_Rapswal Maybe it is not present in the current package [image] Its available in this one. Cheers.

so what to use now how to do it

@Krishan_Rapswal you can use add to collection just keep the version as 20.10.4 That will do it.

[Screenshot (31)] Books List.xlsx (10.8 KB) How to change value in the code(Like If i change 4.5 and replace with 4.9 so it will change in Excel File) so it will automatically change in Excel File

Hey @Krishan_Rapswal You can change if its in key value of a perticular value pair use assign Something like this [image] And then if you want to change this in excel you have to use write range to change or else it wont reflect there. You need to get it as data table type to write in excel. H…

How to add excel file in dictionary through invoke method uipath

Help Studio

Gokul_Jayakumar (Gokul Jai) March 24, 2023, 10:09am 2

Hello @Krishan_Rapswal
Kindly Refer to this thread, you may get some idea.

Topic		Replies	Views
ConfigFile Dictionary In Excel Studio studio , question , activities_panel	13	924	March 16, 2023
Creating Dictionary From Excel File Studio studio , question , activities_panel	8	1322	March 15, 2023
Add to Dictionary Activity is replacing the dictionary values in dictionary with latest values for all keys Help excel , uiautomation , activities , studio	7	9617	April 27, 2018
Using Dictionary to get the value from Output Of an Excel in New Sheet Studio studio , question , activities_panel	15	1120	March 16, 2023
"Add to dictionary" Activity is not available in uipath studio Activities uiautomation , activities , question	5	1690	February 16, 2023

How to add excel file in dictionary through invoke method uipath

Related topics