Skip cell value using Excel Process Scope

Help Activities
,
1

Hi everyone, I’m new to UiPath.
I’m trying to get the value in the cell. And I’m using for each excel row like this. I managed to get the exact value that i need but when ever it goes to the next row, which is EMPTY, the whole program is STOP.

image
image686×808 30.9 KB

Please help me to skip those empty cells. Thanks a lot

2

This is the value that i want to get

image
image381×899 22.1 KB

3

Hi @KSK_R_D

Place an if activity and give the condition as String.IsNullOrEmpty(CurrentRow(0).ToString) or String.IsNullOrWhiteSpace(CurrentRow(0).ToString)

Place the below activity in the if condition

image
image793×308 28.7 KB

Change the index from 0 to the number you required.

Regards

4

@KSK_R_D

After get use a if condtion as below

For that you need to open advanced editor and then keep this formula

IsNothing(target_name) OrElse String.IsNullOrEmpty(target_name)

On else side keep the next steps on then side do nothing

Cheers

5

Hi @KSK_R_D

If you want to skip empty cells, inside for each excel row use if activity

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

6

can you make i clear? i still don’t know what to do

7

what is that number i my case?

8

Hi @KSK_R_D

The A refers to 0

and in your case it’s like D so it will be 3

Regards

9

i get it, i want the B, so it will be number 2. but there is an error

image
image1139×472 26.6 KB

10

@KSK_R_D

Target_namr is what you want to check right? Then please use the above expression

Cheers

11

THANKS SO MUCH, I CAN FINALLY MAKE IT.
BOTH METHODS ARE WORKING VERY WELL.

1 Like
12

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