This is my current project:
I’ve a list of invoice number in a sheet call “input”. Had build the robot to pick invoice number and search in a web and then scrape some data there. After that the scraped data should paste in “output” sheet in column B. In column A - should specify the respective invoice number (which was looped).
Issue that I’m facing:
How to specify the respective invoice number (which was looped) in column A as shown in below screenshot. (blue highlight - looped invoice number, red highlight - scrapped data)
What should I do to paste the scraped data into the last row (in this case, next scrapped data for next invoice number should paste at row 18)
How do I compeletly clear content of old data in “output” sheet
Read this Excel using Read Range activity and store it in a datatable variable.And loop it using for each row activity then access invoice number as follow row(“Invoice Number”) this returns current row’s invoice number
Start your operation of scraping data here and save it in another sheet (Output) as you said. My suggestion would be add it in a datatable using Add Data Row activity with pre-build datatable with headers such as Piece ID, Pickup Date…,etc
Process Continues until you have invoice number
Finally write it in the same sheet using Write Range Activity by specifying the range
Hope it helps you ! Sorry If I have confused you. Let me know if you have any concerns.
