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支持的工作簿可以在 WindowsMac 系统中很容易地分发和使用。

Getting Started

Start here if you are new to xlwings. Learn about the syntax, the RunPython call, the add-in and UDFs.

Advanced Features

More in-depths explanations about converters, debugging or how to write your own add-in.

xlwings PRO

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.

API Reference

This is a description of all the classes, methods, properties and functions that xlwings offers to work with the Excel object model.