from xlrd import open_workbook
import pandas as pd
from xlrd import open_workbook

# filter out all sheets that are not Pro (aka: models)
with open('t0.xlsx', 'rb') as f:
    book = open_workbook('t0.xlsx')
sheets = [sheet for sheet in book.sheet_names() if sheet.startswith('Pro')]
mapping = {}
for number, sheet in enumerate(sheets):
    mapping[number+1] = sheet
print(mapping)

# remove all 0 values from models
with open('t0.xlsx', 'rb') as f:
    df = pd.read_excel(f, sheet_name='EM1')
    df.loc[df[no_y != 0]]

# now doit
with open('t0.xlsx',  'rb'):
    wb = openpyxl.load_workbook('t0.xlsx')
    print(wb.sheetnames)
    sheet = wb['Procédure et Relevé_AVEC BONI']
    sheet['U9'] = 99999


    wb.save('t7.xlsx')
    wb.close()