Skip to content

ExcelPython v2.0.0

Compare
Choose a tag to compare
@ericremoreynolds ericremoreynolds released this 17 Jul 09:28
· 143 commits to master since this release

ExcelPython v2 is a major rewrite of ExcelPython. Whereas the old version was based on loading the Python runtime into the Excel process via PythonXX.dll, now Python is run out-of-process. This has a few advantages:

  • any version of Python is immediately supported (as long as PyWin32 is installed) - and you can mix 32/64-bit Excel/Python.
  • the Python runtime behaves exactly as it does when run from the command prompt
  • no more DLL not found issues
  • you can target a specific version of Python very easily and configure the execution environment precisely (e.g. path, environment variables, etc.) enabling you to embed a portable copy of Python in your project and ship it with your workbooks in a zip file.

ExcelPython v2 is designed to be portable in the sense that no installation, registration or admin rights are required to use it - just unzip it into the folder containing your workbooks, import the xlpython.bas VBA source file and you're set!

It should (hopefully) all work out of the box without hassle! See the readme for instructions on how to get started.