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)
Hi @Krishan_Rapswal
Give a try to this workflow
FilterUnwantedData.xaml (5.9 KB)
Output - Refer Sheet2
Books List (2).xlsx (17.8 KB)
Hope this helps
Jithesh_R
(Jithesh Karkera)
March 13, 2023, 11:39am
3
Hii @Krishan_Rapswal ,
I didn’t get why you want to filter using dictionary .
Kindly check the below workflow to filter data table
FilterDataTable.zip (1.5 KB)
Hope this might Help you
how to filter this excel file by Dictionary
Means "if i take another sheet and type 4.3 then all the Rating value shows up in that sheet "
Hi @Krishan_Rapswal
Check this workflow.
FilterUnwantedData.xaml (8.3 KB)
Output
Books List.xlsx (19.7 KB)
Hope This helps.
Hi @Krishan_Rapswal
Give a try to this.
Keep this value in config.
FilterUnwantedData.xaml (12.3 KB)
Hope this helps.
What is Wrong With This ConfigFile
Main.xaml (8.6 KB)
Excel File :-
Books List.xlsx (16.5 KB)
How can we Change Dictionary (" Object, Object ") as (“String, String”)
Hi @Krishan_Rapswal
Remove .toString from key and value then check.
or else while initializing dictionary use config = New Dictionary(of String,String)
I have Change this in “Add To Dictionary”
How to Change IDictionary <Object, Object> to , <String, String>
@Krishan_Rapswal
In the variable panel change the type.
how to read this excel file as a Dictionary
Books List.xlsx (16.5 KB)
Main.xaml (8.6 KB)
Books List.xlsx (18.0 KB)
Hello Friends,
How I Make My Excel Sheet Dynamically Through So The Other Person Can Change The Data from His Personnal Excel Sheet (Using Dictionary)
For Example I have 100 rows in my Excel File but Today he need Only 60 rows With Above Rating “4”
Next day if he wants 30 rows With Above Rating “4.1”
but he is using “His Excel File” to change the Data
system
(system)
Closed
March 24, 2023, 10:02am
17
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.