Empty cell skip

Help Studio
, ,
1

Hello ,I have to put all items in queue which is in Excel i have empty cell that should to skipped…
error in excel row1

2

Hi @sathya_auto

String.IsNullOrEmpty(CurrentRow(“EmailAddress”).ToString)

3

Thankyou will try it…suppose if the empty cell contains all rows

4

@sathya_auto

EmailAddress contains contains empty so it will skip that row

5

@sathya_auto

Try the below sequence

String.IsNullOrEmpty(CurrentRow("EmailAddress").ToString)

image
image871×716 24.5 KB

Regards

6

if some cases empty cell contains all rows like first name,second name means ?

7

@sathya_auto

String.IsNullOrEmpty(CurrentRow(“EmailAddress”).ToString) or String.IsNullOrEmpty(CurrentRow(“FirstName”).ToString) or String.IsNullOrEmpty(CurrentRow(“LastName”).ToString)

8

thankyou Got it… :slightly_smiling_face: :slightly_smiling_face:

1 Like
9

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