automationexcel.py

import openpyxl as xl
from  openpyxl.chart import BarChart, reference

def process_workbook(filename):
    wb = xl.load_workbook(filename)
    sheet = wb["Sheet1"]

    for row in range (2, sheet.max_row +1):
        cell=sheet.cell(row, 3)
        corrected_price = cell.value*0.9
        corrected_price_cell = sheet.cell(row, 4)
        corrected_price_cell.value = corrected_price
    wb.save('edited_excel_file_automated.xlsx')

process_workbook('transactions.xlsx')