Read row until row blank

fairymemay · June 15, 2021, 3:58am

I want to read row until row blank (red text)
input2.xlsx (9.0 KB)

Please guide me about it.

copy_writes · June 15, 2021, 4:15am

First count up to blank
then use that count in the range simple

Regards
Chethan P

copy_writes · June 15, 2021, 5:16am

prasath_S · June 15, 2021, 5:35am

Please try this

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

Thanks

prasath_S · June 16, 2021, 4:44am

@fairymemay did the issue got resolved?

Thanks

system · June 19, 2021, 4:44am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.