From 75a42ec54dbf721caa659ddf02c1f46fc2cb4bef Mon Sep 17 00:00:00 2001
From: mlot <petri-rush-curvy@duck.com>
Date: Fri, 6 Jun 2025 13:40:57 -0400
Subject: initial commit for archiving

---
 Chapter12ProjUpdateSpreadsheet.py | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 Chapter12ProjUpdateSpreadsheet.py

(limited to 'Chapter12ProjUpdateSpreadsheet.py')

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')
-- 
cgit