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)
Give a try to this workflow
FilterUnwantedData.xaml (5.9 KB)
Output - Refer Sheet2
Books List (2).xlsx (17.8 KB)
Hope this helps
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 "
Check this workflow.
FilterUnwantedData.xaml (8.3 KB)
Output
Books List.xlsx (19.7 KB)
Hope This helps.
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”
@Krishan_Rapswal yes
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
