Purchase order Dispatcher

Create a new sequence called PurchaseOrderDispatcher in UiPath Studio. Within the Dispatcher, we will read the Excel file we created earlier and upload each row as a queue item. Before we do that, go ahead and put the PurchaseOrders.xlsx file we created earlier in the Data folder of the project:

Let's now read each of the Excel rows to upload them to the queue:

1. We'll start by adding an Excel Application scope activity within the sequence that we just created. For this activity, go ahead and update the Workbook path to point to the PurchaseOrders.xlsx file.

2. Within the Do sequence of the Excel scope, let's add an Excel Read Range activity to read the content to a new DataTable variable called dtPurchaseOrders, as shown in the following screenshot:

3. We will now use the DataTable we created as the input for the Dispatcher to create the queue items. We will iterate each DataTable row and add them to...