前言

本人目前还是学习阶段,编写内容如有错误还望指出,勿喷!
本内容主要方便查找模块方法

安装和导入模块

• pip install xlwings -i https://pypi.tuna.tsinghua.edu.cn/simple
• impor xlwings as xw

创建excel程序

import xlwings as xw

with xw.App(visible=False，add_book=False) as app:
	app.display_alerts = False
	app.screen_updating = False
	wb = app.books()	# type: xw.Book
	sht = wb.sheets(1)
	res = sht.range("a1").value
	wb.close()

未完待续...