As the hands-on tutorial for this chapter, we will be reading the shopping list from a Microsoft Excel spreadsheet. Previously, we hardcoded the shopping list by entering the items that we want to purchase as initial values of a collection. We wouldn't want to do that every week; editing the collection requires the person updating the list to be proficient in Blue Prism. Instead, what happens in real life is that the list is maintained somewhere like a Microsoft Excel file as a worksheet. Excel makes it easy for anyone, even a novice computer user, to enter their shopping needs.
Before we start the chapter, let's observe the following steps to prepare our shopping list:
- Create a new Excel named ShoppingList_Henry.xlsx: We added the name of the shopper (in our example, that's our friend, Henry) at the back. In this...