How filter data in Datatable I want to data of dissimilar data I want only 3 6 9 12 no of rows
Hi @Sachin_Bile , Welcome to the Community.
Can you please be more clear about dissimilar data? Like what are the basic criteria that you need to filter the data table?
new_dt = dt.AsEnumerable.Where(Function(x) dt.Rows.IndexOf(x) Mod 3=0).CopyToDataTable
mod 3=0 is for selecting rows by index which are divisible by 3 and dt is your output datatable used in Read Range.
Please mark this as solution if it solves your problem.