Reading the excel sheet and filter the values by a parameter?

excel
uiautomation
activities
studio

#1

Hey,

“Read Excel.xlsx and filter the values by employee city (manual input). Also, Count the resulting rows.”

What exactly am i suppose to do in this case?

Thanks and Regards,
@ENGINEERING_FAIL


#2

*Use readrange and assign output to datatable
*use input dialog and enter your value to compare
*Use assign activity,Write linq query to compare datatable.select(Column name=’ “+input dialog value+” ')
*use rows .count for resulting rows
@ENGINEERING_FAIL


#3

Hey @sreekanth,

Can you please send me the xaml for the same?

I am having some issues.


#4

What’s your issue?can you provide more details?


#5

I am getting some syntax error.
Selection of the filter is making an issue,

Getting problems in your 3rd step.

I understand it is not a big deal and can be sorted out pretty easily.

Please send the xaml file if possible.


#6

sample.xaml (6.5 KB)
Refer this @ENGINEERING_FAIL