Write range activity not working as expected

[Rakesh_Tiwari]

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
Rakesh

[Shiva_Nikhil]

@Rakesh_Tiwari

can you check it by writing it in other sheet or

can you share your filter linq

cheers

[sasi_poosarla (sasi p)]

@Rakesh_Tiwari
share the input and output so that can help you

[Rakesh_Tiwari]

Hi @Shiva_Nikhil ,

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

linq qery

[Shiva_Nikhil]

@Rakesh_Tiwari

can you try with this

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

cheers