How do I find the last row?

[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