Hi , i am trying to create an automatic Uipath studiox process that is able to update an excel sheet daily with stock prices from the internet. I would want it to be able to find the next empty row in the excel table to update the columns " Date" , current price of stock A , current price of stock B , current price of stock C.
I have managed to retrieve the 3 stock prices for yesterday 31/12/2020 from the website and wrote it into my excel sheet ( row 7).
However , i do not know how to get UiPath to find the next empty row in the table which contains column " Date" , current price of stock A , current price of stock B , current price of stock C. i.e., i want to run an automatic process to update today’s 1/1/2021 stock prices and date in row 8 of excel sheet and tomorrow’s stock prices and date in row 9 and so on.
For all your advice please. Thank you.