How to filter column values in excel using Filter data table activity

Help Studio
, ,
9

Hi Jack

image "This is Sheet 2"
image "This is Sheet 2"813×272 5.08 KB

This main sheet ,First we need know which data is present in column
so I using this Activities
excel app scope
Read range
Assign :ReadRange .DefaultView.ToTable(True,“Number”)
Write line : Assign
output show :5,3,1,1
the next step
Assign :ReadRange.Select("[Number]<> 5 and [Number]<>3 ").CopyToDataTable
Output Data Table
Write line :output Assign
It shows like :1
1
Write Range: writing the data in to sheet 1
image

After how can we delete from sheet 2 which was present in sheet 1 data.