find and replace a value in a given column inside an excel

excel-env.yml

# conda env create -f excel-env.yml
name: excel
dependencies:
  - python=3.7
  - openpyxl

excel.py

# python excel.py example.xlsx B value "new value"

import sys
from openpyxl import load_workbook

def main(argv):
    filename = argv[0]
    col = argv[1]
    value = argv[2]
    replace = argv[3]

    workbook = load_workbook(filename=filename)
    sheet = workbook.active

    print("Replacing at {} in the column {}".format(sheet.title, col))

    for cell in sheet[col]:
        cell.value = str(cell.value).replace(value, replace)

    filename="replaced-"+filename
    workbook.save(filename=filename)
    
if __name__ == "__main__":
    main(sys.argv[1:])