import os
import xlwings as xw
from tqdm import tqdm
path = 'E:\\tempory_download\\'
path_list = os.listdir(r'E:\tempory_download')
whole_path_list = []
for i in path_list:
if 'xls' in i:
whole_path_list.append(path+i)
elif 'xlsx' in i:
whole_path_list.append(path+i)
else:
pass
app = xw.App(visible=False, add_book=False)
for i in tqdm(whole_path_list):
wb = app.books.open(i)
ws = wb.sheets['sheet1']
ws.range("B2").value = "***"
ws.range("B3").value = "***"
ws.range("H2").value = "***"
ws.range("D3").value = "***"
wb.save()
wb.close()
app.quit()
第一部分是通过os.listdir()获得文件夹下的文件路径
第二部分是通过条件判断,将xls和xlsx两种Excel文件筛选出来
第三部分是通过xlwings读取文件并修改保存,循环过程通过tqdm在命令行可视化进度条