Chapter12ProjUpdateSpreadsheet.py


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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')