Fine
hope these steps would help you resolve this,
–use a excel applicatiion scope and pass the file path as input
–inside the scope use READ RANGE activity and get the output with a variable of ttype datatable named dt
–now use a assign activiity like thiss
dt = dt.Asenumerable().Where(Function(a) Convert.ToInt32(a.Field(of string)(“yourcolumnname”)) mod 2 =0).CopyToDatatable()
–now use a write range activity and mention the datatable as dt and sheetname as “sheet2” and enable add headers property in the property panel of write range activity
if you are not getting AsEnumerable as a method for datatable then kindly follow these steps
hope this would help you
kindly try this and let know any queries or clarification
Cheers @Darba