Delete rows in excel dynamically when column has null value

[ppr (Peter Preuss)]

@Vishwanth_Raya

Have look here:

Find empty values in a datatable

@Shikhar_Tandon first idea as a quick shot, use it within an assign, returning a list (From d In dtData.AsEnumerable Where d.ItemArray.Any(Function (x) If(isNothing(x), True, String.IsNullOrWhiteSpace(x.toString.trim))) Select d).toList with the check on returned list count with YourDataRowListVar.Count within an if activity it can be reacted on result or no returned rows case. Find Demo Xaml here: GetRowsWithBlanksInAnyCol.xaml (7.7 KB) Edited: Statement saved up against Null Excepti…

As you need the opposite use this statement

(From d In dtData.AsEnumerable
Where Not d.ItemArray.Any(Function (x) If(isNothing(x), True, String.IsNullOrWhiteSpace(x.toString.trim)))
Select d).toList