this should be a really simple one, but I can’t get it to work properly.
The starting point is that I am using a Windows version project, not Windows legacy. I am scraping multiple websites, and wish to write the results in different sheets, one for each website scraped.
The scraping is looping thru each website using queues in Orchestrator, and for the process it is vital that each loop is written to the workbook and appended to the data from the previous loop.
So data should not be appended to the datatable and written to the Excel file after the scraping is done.
What will be the best way/activities to do this?