EXCEL FILTER SELECTION(CHECK AND UNCHECK)

Help
, ,
1

I want to filter the current month and year. I encountered some error in checking the filter checkbox. I want to check only the current month and year dynamically.
filter

2 Likes
3

i need a rush response please

4

Hi
We can do that filteration once after getting the whole data from excel as a datatable with excel application scope and read range activity
—once after getting the datatable named dt
Use a SELECT method to filter the datatable

cheers @Ruben_Uson

5

is that select item in activities list?

6

which one? enlighten me

7

No buddy
It’s not an activity
It’s a method of datatable like for example
datatable = datatable.Select(“[yourcolumnname] = ‘yourvalue’ “).CopyToDatatable()

Cheers @Ruben_Uson

8

thanks hope it will work

1 Like
9

Cheers @Ruben_Uson

1 Like
10

image
ERROR

11

.Select is not a member of “date”

12

image
image1920×1080 211 KB

It says here the cannot perform ‘=’ operation on system.datetimen and system.string

1 Like
13

delete it hahhahaa

1 Like
14

It must be Dt_Filtered.Select(…)

Cheers @Ruben_Uson

15

not worked also :frowning:

16

Oh what is the error we are getting
@Ruben_Uson

17

image
image1920×1080 204 KB

18

Is Dt_Filtered the variable obtained from read range activity
@Ruben_Uson

19

image
image1920×1080 205 KB

stocked over here

20

hello please help me to my problem. how to use the select method

21

hello everyone,
have got any solution to uncheck #NA in filter