Append datatable to Excel sheet in multisheet workbook - Uipath Windows version


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?

You can store the sheet name in a variable and use it while writing into the Sheet in Write range or Append Range Activity