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

Help Studio
, ,
1

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)

2

Hi @Krishan_Rapswal

Give a try to this workflow
FilterUnwantedData.xaml (5.9 KB)

image
Output - Refer Sheet2
Books List (2).xlsx (17.8 KB)

Hope this helps

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 :slightly_smiling_face:

4

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 "

5

Hi @Krishan_Rapswal

Check this workflow.
FilterUnwantedData.xaml (8.3 KB)

Output
Books List.xlsx (19.7 KB)

Hope This helps.

7

Hi @Krishan_Rapswal

Give a try to this.
Keep this value in config.
image

FilterUnwantedData.xaml (12.3 KB)

Hope this helps.

8

What is Wrong With This ConfigFile

Main.xaml (8.6 KB)

Excel File :-
Books List.xlsx (16.5 KB)

9

Screenshot (9)
Screenshot (9)1920×1080 256 KB

How can we Change Dictionary (" Object, Object ") as (“String, String”)

10

Hi @Krishan_Rapswal

Remove .toString from key and value then check.

or else while initializing dictionary use config = New Dictionary(of String,String)

11

I have Change this in “Add To Dictionary”

12

@Krishan_Rapswal yes

13

Screenshot (11)
Screenshot (11)1920×1080 281 KB

How to Change IDictionary <Object, Object> to , <String, String>

14

@Krishan_Rapswal

In the variable panel change the type.

image
image1240×255 9.95 KB

15

how to read this excel file as a Dictionary
Books List.xlsx (16.5 KB)

16

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

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.