我开发了一个脚本,该脚本使用xlwings打开大量受保护(不受密码保护,仅受保护)的excel文件,读取每个文件中的一列并将其写入字典,然后关闭。它可以正常工作而不会产生任何错误,但是suuuper速度很慢。 有没有比下面的代码更快的方法?
import xlwings as xw
def unprotect_xls(filename,date):
workbook = xw.Book(filename)
sheet = workbook.sheets['Table1']
error_length[date] = dict(zip(range(1,21),sheet['BN7:BN26'].value))
workbook.close()
#### not working example ####
file_names = ['file1','file2',...,'file999']
dates = ['date1',...]
new_files = len(file_names)
# make dict
error_length = {}
# open excel in background
app = xw.App(visible=False)
#fill dict
for i in range(new_files):
unprotect_xls(file_names[i],dates[i])
app.quit()