Skip to content

xlwings Lite

Excel 网页版,功能区 -> 开始 -> 加载项 -> 搜索 -> xlwings Lite ,免费使用,支持函数、数组函数和脚本。 xlwings Lite 通过 Pyodide 使用 WebAssembly ,在浏览器环境运行,文档 https://lite.xlwings.org/

xlwings 商业版包含 xlwings Lite 自部署,6000 美元/年。

文件:

  • main.py
  • requirements.txt
"""
xlwings Lite allows you to define
automation scripts and custom functions
with Python instead of VBA/Office Scripts.

Select a function in the green dropdown
above and run it by clicking the button or
or by pressing F5. One of the sample
scripts will insert custom functions,
which are defined using the @func
decorator. You can add, delete, or edit
functions in this file."""
# Pin the version of packages that are installed from PyPI.
# Don't pin the version if they are on this list:
# https://pyodide.org/en/stable/usage/packages-in-pyodide.html
#
# New packages are installed on the fly.
# However, the following situations require a restart:
# - removing a package
# - changing the version of a package
# - adding an optional dependency of xlwings, e.g, polars

xlwings==0.33.20  # required
python-dotenv==1.2.1  # required
pyodide-http  # required
black  # required
pandas
matplotlib
seaborn

面板:

  • OUTPUT
  • PYTHON CONSOLE
  • WINGMAN

卸载 xlwings Lite ,功能区 -> 开始 -> 加载项 -> 更多加载项 -> 我的加载项 -> xlwings Lite -> 右侧三点 -> 删除。

联系 math@baima.site