We will create an Excel spreadsheet with a few sample POs for our automation to process. The PO will have the following columns:Â Supplier, Address, City, State, Zip, and ItemName.Â
Add three sample rows to the sheet, as shown here:Â
We will place this folder within the Project folder once we create it in the next section. For now, you can save it to any place where you can retrieve it quickly. Make sure to name it PurchaseOrders.xlsx. The sample input file is also available on the GitHub repo for the project.