Excel Auto filter error or not working from c# code

Hello All , i'm facing a problem to load the filtered data from excel .

my problem is , filtering the year from excel filters using c# code . i have tried all the possible ways , but yet i didnot get any result, i hope here anybody will solve my issue .

i want to filter a column only by year , but it contains date/mm/year. please check the below code for your understanding .

when i give the input like 1/1/2016 , it will work , but when i entered only year , it will not work . please let me know where i'm failing .

range.AutoFilter (29, "2016",XlAutoFilterOperator.xlFilterValues,"2016",true);

range.AutoFilter(29, "*2/2016", XlAutoFilterOperator.xlFilterValues, "*2016", true);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

9y ago
Hello all , at the end of the day , i have got the solution i.e ,

i used the >(Greater than) and < (Lessthan) to get the particular year data
example :
if i need only 2016 data out 2001 to 2016

range.AutoFilter (29, ">=1/1/2016",XlAutoFilterOperator.xlAnd,"<=12/31/2016",true);

Thnaks for your support .
Nilesh Shah9y ago
Probably you need to extract only year from cell value then use it to comapre in AutoFilter function.

For more help, please post your project source as rar file