IF excel row(24) is empty, stop process

[DTECH (Frank DTech)]

Greetings,

As title above, how do I write in IF else statement expression (IF excel row(24) is empty → stop process). I also apply “Stop Job” activities but I don’t know how to make it function. Appreciate the solution and guidance.

[Nithinkrishna]

Hey @DTECH

In the If statement pass the below condition,

String.IsNullOrEmpty(String.Join(String.Empty,dt_Excel.Rows(24).ItemArray).Trim)

If the above is true, then the row is empty.

Thanks
#nK

[Yoichi]

Hi,

If you can accept ungraceful terminate, TerminateWorkflow activity helps you.

Condition will be

row(24) is Nothing OrElse String.IsNullOrEmpty(row(24).ToString)

Regards,

[Yoichi]

Hi,

Do you mean the following IF?

If so, can you try to remove “dateTableT1 =” at the beginning of the condition?

Regards,

[DTECH (Frank DTech)]

Sorry it was wrong file with same name, apologies. Im sending the correct one.

Flowchart.xaml (10.5 KB)

[Yoichi]

Hi,

Can you also share excel fiel : test4.xlsx ?

Regards,

[DTECH (Frank DTech)]

It was empty inside. Here:

test4.xlsx (6.0 KB)

You can create new one and try.

[Yoichi]

Hi,

It’s because the datatable is empty and activity in the for each row won’t execute. (There is no row to iterate)

Regards,

[DTECH (Frank DTech)]

I see, is there any other solution ? Because Im trying to make IF datatable is empty → Stop process, Else → start key-in/type into

[Yoichi]

Hi,

Can you try the following expression?

gotah2 is Nothing OrElse gotah2.Rows.Count=0

Regards,

[DTECH (Frank DTech)]

Still Else output which is “N” instead of “Stop Process”.

[Yoichi]

Hi,

Can you check the following workflow?

Regards,

[DTECH (Frank DTech)]

Realized still putting inside for each row. Now it works. Appreciate and thanks a lot Cheers