Ejemplo para leer un archivo de excel en python, cambiar los valores de una columan especifica usando un patron y correlativo y luego imprimir los valores generados y salvar el archivo con los cambios

cambiarplaca.py

# -*- coding: utf-8 -*-
import openpyxl
import sys

first_row=3
last_row=10
filename='Prueba.xlsx'
placa_name='B'
serial_name='H'
chasis_name='J'

def modificar_columna(sheet, column_name, prefix, inital_value, zerosToleft):    
    for x in range (first_row,last_row):        
        valorStr = prefix + str(inital_value).zfill(zerosToleft)     
        sheet[column_name+str(x)] = valorStr
        inital_value+=1
    

def imprimir_columna(sheet, column_name):
    values_to_use = []
    for x in range (first_row,last_row):
        values_to_use.append(sheet[column_name+str(x)].value)
    outputStr = '\', \''.join(values_to_use)
    print('\''+outputStr+'\'')    
    print("\n")

def main(argv):
    workbook=openpyxl.load_workbook(filename)
    sheet=workbook.active
    modificar_columna(sheet, placa_name, 'PL000',3175,4)
    imprimir_columna(sheet, placa_name)
    modificar_columna(sheet, serial_name, 'SER00000',8670,4)
    imprimir_columna(sheet, serial_name)
    modificar_columna(sheet, chasis_name, 'CHA00000',3562,4)
    imprimir_columna(sheet, chasis_name)
    workbook.save(filename)

if __name__ == "__main__":
    # print('Hola mundo')
    main(sys.argv[1:])