Make Excel fly: Interact with Excel from Python and vice versa.
xlwings is a BSD-licensed <http://opensource.org/licenses/BSD-3-Clause>
_ Python library that makes it easy to call Python from Excel and vice versa:
Numpy arrays and Pandas Series/DataFrames are fully supported. xlwings-powered workbooks are easy to distribute and work on Windows and macOS.
xlwings includes all files in the xlwings package except the pro
folder, i.e., the xlwings.pro
subpackage.
xlwings PRO offers additional functionality on top of xlwings (Open Source), including:
pandas.read_excel()
(no Excel installation required)full list of PRO features <https://www.xlwings.org/pricing>
_xlwings PRO is source available <https://en.wikipedia.org/wiki/Source-available_software>
_ and dual-licensed under one of the following licenses:
PolyForm Noncommercial License 1.0.0 <https://polyformproject.org/licenses/noncommercial/1.0.0>
_ (noncommercial use is free)xlwings PRO License <https://github.com/xlwings/xlwings/blob/main/LICENSE_PRO.txt>
_ (commercial use requires a paid plan <https://www.xlwings.org/pricing>
_)License Key
To use xlwings PRO, you need to install a license key on a Terminal/Command Prompt like so (alternatively, set the env var XLWINGS_LICENSE_KEY
::
xlwings license update -k YOUR_LICENSE_KEY
See the docs <https://docs.xlwings.org/en/latest/pro/license_key.html>
_ for more details.
License key for noncommercial purpose:
noncommercial
.License key for commercial purpose:
xlwings PRO licenses are developer licenses, are verified offline (i.e., no telemetry/license server involved) and allow royalty-free deployments to unlimited internal and external end-users and servers for a hassle-free management. Deployments use deploy keys that don't expire but instead are bound to a specific version of xlwings.