How to delete rows in the same sheet (Excel)?

[prasath17 (Guru)]

@Tana20 - Here you go…

LINQ Query in the Assign activity

dtInput.AsEnumerable().Where(Function(row) Not(row(“Z”).ToString.Trim.Contains(“0”) or row(“Z”) Is DBNull.Value Or row(“Z”).Equals(“”) )).CopyToDataTable

Input

Output