You can use glob to create a list of the files, and then loop them using your code:
from openpyxl import load_workbook
from openpyxl.utils.cell import range_boundaries
from glob import glob
def process_xlsx(filepath):
wb = load_workbook(filename = filepath)
for st_name in wb.sheetnames:
st = wb[st_name]
mcr_coord_list = [mcr.coord for mcr in st.merged_cells.ranges]
for mcr in mcr_coord_list:
min_col, min_row, max_col, max_row = range_boundaries(mcr)
top_left_cell_value = st.cell(row=min_row, column=min_col).value
st.unmerge_cells(mcr)
for row in st.iter_rows(min_col=min_col, min_row=min_row, max_col=max_col, max_row=max_row):
for cell in row:
cell.value = top_left_cell_value
wb.save(filepath)
for filepath in glob("./*.xlsx"):
process_xlsx(filepath)
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…