Read row until row blank

Help Activities
, ,
1

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

image

Please guide me about it.

2

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

Regards
Chethan P

3

image
image799×470 11.7 KB

image
image711×475 10.1 KB

image
image975×381 14 KB

image

2 Likes
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
5

@fairymemay did the issue got resolved?

Thanks

1 Like
6

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