Filter data and write data to another excel (By use Linq)?

I want copy Mobile No by filter column Recheck = Blank

I write data to file template.

File data : filter data.xlsx (9.2 KB)

File template : Templete.xlsx (10.4 KB)

I want output as below.
image

Please guide me about it.

Hi @Maria99
try this linq query

dt2=dt1.AsEnumerable().Where(Function(row) row(“Recheck”).ToString.Trim.Equals("")).CopyToDataTable.DefaultView.ToTable(False,“mobile”)

this dt2 should be written to another excel using write range

Regards,
Nived N

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.