Write range activity not working as expected

Hi All,

i have excel file which i am filtering using linq query after reading it,and after that i am trying write back in same sheet but it is writting those also which is not required for me(means filter is not working).

Thanks in advance


can you check it by writing it in other sheet or

can you share your filter linq


share the input and output so that can help you

Hi @Shiva_Nikhil ,

i tried writting in another sheet, it is working fine.

linq qery


can you try with this

DT.Asenumerable.where(function(x) x(“Vendor status”).tostring<>“inactive”).copytodatatable


1 Like