How to check an excel row count

[Umesh_p (Umesh)]

Hi ,

I have a scenario to get the row count based on that I need to send an email if it’s zero

Thanks in advance

[nikhil.girish]

hi @Umesh_p

kindly use the expression
first store the xecel output via read range as datatable lets assume that its Dt

next use an if condition below
Dt.Rows.Count.ToString=0

then

use send email

[Vikas_M]

Hey @Umesh_p you can use an if activity

If YourDT.RowCount <> 0
continue

Else
Send email

Hiopeit helps you out

[mkankatala (Mahesh Kankatala)]

Hi @Umesh_p

You can use the rowcount function to get the row count of the datatable. Let’s called datatable name as dtinput.

dtinput.rowcount which gives the value of the rowcount.

In If condition check the count by below condition.

- Condition -> dtinput.rowcount=0

In then block you can give the activities for forward automation.

Hope it helps!!