批量打印工作簿

pip install xlwings
代码如下：
import os
import xlwings as xw

filelist = os.listdir()
app = xw.App(visible=True, add_book=False)
for file in filelist:
    try:
        if os.path.splitext(file)[1] == '.xlsx' or os.path.splitext(file)[1] == '.xls':
            workbook = app.books.open(file)
            workbook.api.PrintOut()
    except:
        pass
app.quit()
os.system('pause')