Read row until row blank

Help Activities
, ,
4

Hi @fairymemay

Please try this

dtTable.AsEnumerable.TakeWhile(Function(row) row.ItemArray.Any(function(col) not string.IsNullOrEmpty(col.ToString))).CopyToDataTable

image

image

Thanks

2 Likes