EXCEL FILTER SELECTION(CHECK AND UNCHECK)

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

i need a rush response please

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

is that select item in activities list?

which one? enlighten me

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

thanks hope it will work

1 Like

Cheers @Ruben_Uson

1 Like


ERROR

.Select is not a member of “date”

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

1 Like

delete it hahhahaa

1 Like

It must be Dt_Filtered.Select(…)

Cheers @Ruben_Uson

not worked also :frowning:

Oh what is the error we are getting
@Ruben_Uson

Is Dt_Filtered the variable obtained from read range activity
@Ruben_Uson


stocked over here

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