xlwings - 让Excel跑得飞快!¶
xlwings (Open Source) is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa:
Scripting(脚本): 使用类似VBA的语法,在Python中自动处理Excel数据或者与Excel交互。
Macros(宏): 用强大而干净的Python代码替代VBA宏。
UDFs(用户定义函数): 用Python编写用户定义函数(UDFs),仅适用于windows系统。
完全支持 Numpy arrays(数组) 和 Pandas Series(序列)/DataFrames 。 带有xlwings支持的工作簿可以在 Windows 和 Mac 系统中很容易地分发和使用。
Use advanced features such as:
xlwings Server (self-hosted): no local Python required
xlwings Reports: work with templates
1-click installer: bundle Python and all your packages
Embedded code: easy deployment
Ultra fast file reader: no Excel required
No more VBA: Call Python from Office Scripts and Office.js
Excel on the web & Google Sheets
Free for non-commercial use only.