Python 操作 Excel (xlwings)

学习中

EXCEL文件操作

import xlwings as xw
app = xw.App(visible=True, add_book=False)
'''
visible
Ture：打开excel
False：不打开excel
add_book
True:打开excel并且新建工作簿
False：不新建工作簿
'''
wb = app.books.open('d:\\study\\1.xls')
wb2 = app.books.open('d:\\study\\2.xls')
print(app.books.active)
print(app.books)
wb.close()
wb2.close()
#app.books[0].close()
app.quit