xlwings是一个BSD许可Python库,可以很容易地从Excel调用Python
参考链接:https://www.jianshu.com/p/e21894fc5501
demo
import time
import xlwings as xw
data = {
'sheet1': [{
'3_18': 2004302.0
}, {
'10_18': 2004406.0
}],
'sheet2': [{
'3_10': 20.0
}, {
'7_10': 60.0
}, {
'10_10': 100.0
}],
'sheet3': [{
'3_10': 'jingyugushan'
}, {
'4_10': 'baguaqiankundao'
}]
}
# app = xw.App(visible=True, add_book=False)
# # 文件位置:filepath,新建test文档,然后保存,关闭,结束程序
# filepath = r'xlwings_test.xlsx'
# wb = app.books.add()
# wb.sheets['paybiggift'].range('A1').value = 'hello xlwings'
# wb.save(filepath)
# time.sleep(8)
# wb.close()
# app.quit()
# 作者:早起收果子
# 链接:https://www.jianshu.com/p/e21894fc5501