Hello,
I have an excel file which my loop doesn't stop on the last result/row.
This file will have a different number of rows filled everyday, so its not static:
Here is my loop:
After it reads the last row with data, it will keep trying to populate the browser (above) with empty data from empty rows.
My 2 questions:
1-How to make it stop on the last row with value, and;
2-How to clean all rows on excel.
*All rows with data must be erased once its done, because I faced the following:
Yesterday, 20 lines were written on the excel.
Today there was only 10 lines to be written, so it overwrote the first 10 lines, but the other 10 lines was the results from yesterday.
Thanks for your help in advance.
