from pathlib import Path
import xlwings as xw
src_folder = Path(‘文件夹’)
file_list = list(src_folder.glob(‘*.xlsx’))
app = xw.App(visible=False, add_book=False)
for i in file_list:
if i.name.startswith(‘~$’):
continue
workbook = app.books.open(i)
for j in workbook.sheets:
data = j[‘A2’].expand(‘table’).value
for index, val in enumerate(data):
if val[2] == ‘A’:
val[2] = ‘B’
data[index] = val
j[‘A2’].expand(‘table’).value = data
workbook.save()
workbook.close()
app.quit()