I have an Excel sheet like this.
How to delete the empty rows.
Row number:2,5,6,9. etc… dynamically (if Column a is null/blank).
I need only the yellow colour highlighted data.
Have look here:
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)))
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.