1 files changed, 20 insertions, 0 deletions
diff --git a/Chapter12ProjUpdateSpreadsheet.py b/Chapter12ProjUpdateSpreadsheet.py
new file mode 100644
index 0000000..08c37aa
--- /dev/null
+++ b/Chapter12ProjUpdateSpreadsheet.py
@@ -0,0 +1,20 @@
+#! usr/bin/env python3
+
+# Chapter 12 Project Updating a Spreadsheet
+# updateProduce.py - Corrects costs in produce sales spreadsheet.
+
+import openpyxl
+
+wb = openpyxl.load_workbook('produceSales.xlsx')
+sheet = wb.get_sheet_by_name('Sheet')
+
+PRICE_UPDATES = {'Garlic': 3.07,
+                 'Celery': 1.19,
+                 'Lemon': 1.27}
+
+for rowNum in range(2, sheet.get_highest_row()):
+    produceName = sheet.cell(row=rowNum, column=1).value
+    if produceName in PRICE_UPDATES:
+        sheet.cell(row=rowNum, column=2).value = PRICE_UPDATES[produceName]
+
+wb.save('updatedProductSales.xlsx')