Exit excel when found the Last row fullfiled

ifranity · February 3, 2019, 8:04pm

Hello EveryBody,

please I need Help,

How to exit excel when arrived to the last row of a column on an excel file ?

Thanks.
Best regards,

sreenivasm · February 4, 2019, 2:58am

@ifranity - Did you try this?

Sandeep_3 · February 4, 2019, 6:14am

@ifranity
Did you use for each row loop?
1.Store excel data into data table
2.loop data table using for each row.

ifranity · February 4, 2019, 7:23am

Hello,
No I use only for each and I try to read each item and use the item into a browser. What I want is to stop the process after the last row.

Thanks.

Sandeep_3 · February 4, 2019, 7:27am

@ifranity
Do you want to jump out of the loop after the last row?
or do you want to kill the process or excel after the last row?

ifranity · February 4, 2019, 7:51am

I want to kill excel and the browser after the last row use.

Thanks.

PrankurJoshi · February 4, 2019, 7:57am

Have a row count variable assign total number of rows to it datatable.rows.count
Have a counter variable starting from zero increase it by 1 after every row in loop
if these two have equal values than use kill process activity to kill excel and browser

Thanks,
Prankur