有翅膀的Excel——xlwings
pip install xlwings
xlwings addin install
创建项目:
命令:xlwings quickstart ProjectName
测试语句:
import xlwings as xw import pandas as pd def main(): wb=xw.Book.caller() values=['a','b','c','d','e'] wb.sheets[0].range('A1').value=values @xw.func def hello(name): return f"Hello {name}!" if __name__=="__main__": xw.Book("pyexceltest1.xlsm").set_mock_caller() main()
完成插件时,菜单栏有xlwings:
选择samplecall:
出现如下:
,Best Wish 不负年华