Move data from one excel sheet to another

image
image

If age >= 20, from sheet 1 to sheet 2

Hi @llllllkt99 ,

You could try using Filter Datatable Activity and Write the Output datatable to a new Sheet or Sheet2 using Write Range Activity.

HI @llllllkt99

How about this expression

BuildDt.AsEnumerable.Where(Function(r) (r("Age").ToString)>=CDbl(20).ToString).CopyToDataTable

Check out this XAML file

FilterDataTable.xaml (8.7 KB)

image

Regards
Gokul

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