How do I find the last row?

[Perawat]

Hi.
A condition is a check from the last text of column i.
Then show the value 3

Thanks.
Perawat

[ImPratham45 (Prathamesh Patil)]

Use Read Range and store output in Dt
Give range as per your convenience if you want for Column “I” then type “I:I”
and then use DT.Rows.Count+1 will give “3”

[Perawat]

@ImPratham45

[ImPratham45 (Prathamesh Patil)]

Data Type will be Int
If you want it as string then use
(Dt.Rows.Count+1).ToString

[Perawat]

@ImPratham45

I changed to Int but the resulting value is 1048576.

[ImPratham45 (Prathamesh Patil)]

is there any data in “I” Column

[Perawat]

@ImPratham45

Yes, I have information.

[Perawat]

@ImPratham45

The file I used to test.
Master Stock - Copy.xlsx (11.3 KB)

[Latika10011740 (Latika V N Durga Bhavani)]

Hi @Perawat

Please check the workflow attached,
Rowcount_Excel.zip (24.9 KB)

or
Please check this post might help you,

How to get row count of specific column name

Hi @mohininemade301094, Good, so kindly use this method, you will be having a name for datatable , say “dt_1” Inside for each row loop, mention the datatable name, with for each row loop variable name “rows” say you want to know the total row count (ignoring empty rows) of second column, with index 1, use a if condition mentioning, Not String.IsNullOrEmpty(rows(1)). or you can mention even column name instead of index like Not String.IsNullOrEmpty(rows(“ColumnName”)) Use a counter with as…

Thanks
Latika

[amaresan (Amaran)]

Hi Perawat,

Use below query in assign activity to get row count

Dt.AsEnumerable().where(Function(x) not string.IsNullOrWhiteSpace(x(“Status”).ToString)).ToArray().Count+1

Thanks,
Amaresan

[RoboHeart]

Hi. It should actually work when you just empty the range area field.

[Perawat]

@Latika10011740, Thank you so much for your help.