Read only some rows in excel

Build
, , ,
#1

Hi,

I need to read only the rows which content is not empty for one column and only for that column, not care about other columns close by… any idea?

#2

Hi @mz3bel

can you given read range and in for each row in dt

use if condition

String.IsNull or empty(row(“Column1”).ToString or String.IsNullorEmptyWhitespace(row(“Column1”)

Then use it as log message and in else condition process the row

Thanks
Ashwin S

1 Like
#3

@AshwinS2

Not realy what i’m looking for, the thing is i have many rows. For example the email column has like 2 mails, if i want to send email depending on the column list, it will send email as like all the full rows have mail adresses, not like just for the 2 first rows only, it’s sends blank for the others. So i get error…

#4

Hi @mz3bel

in the condition you can give Dt.Rows.Count>1 and then check it

Thanks
Ashwin S

1 Like
#5

Use FIlter data table activity

1 Like
#6

@mz3bel

Good morning Mz3bel, @MuralidharVankamaddi has the right idea.

Use the “Filter Data Table” activity, enter your datatable + column name and then select “Is Not Blank” from the dropdown menu to only retain/process populated rows.

1 Like
#7

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