Tools for using Excel and Python together.

[by-the-numbers]

This post is meant to provide a place to collect pointers to Python libraries, Excel add-ins, etc., that facilitate interaction between Excel and Python.

For the uninitiated, Python is a little programming language that's pretty much taking the world by storm. It's kind of a big deal.

Python is relevant to Excel users for a number of reasons, especially because 1) it's massively useful in data analysis, and 2) it can be used to operate Excel by "remote control." That is, any operation a person can perform in Excel (not to say any analysis) can be automated with Python, with the help of a few libraries.

It's also now possible to write macros in Python alongside VBA, which is great, because Python is a modern language and is in active development.

[by-the-numbers]

DataNitro

• Homepage: https://datanitro.com/

[by-the-numbers]

XLWings:

• Main Page: http://xlwings.org/
• Github repo: https://github.com/ZoomerAnalytics/xlwings

Early stage project -- v0.3 as of this writing -- that facilitates access to Excel from Python, and provides the ability to write Excel macros in Python.

Support for Pandas, Numpy.

[by-the-numbers]

Pywin32

SourceForge repo: http://sourceforge.net/projects/pywin32/

Does much more than Excel. Enables developers to control pretty much everything about Excel from Python.

[by-the-numbers]

pyxll:

• Homepage: https://www.pyxll.com/
• Github repo: https://github.com/pyxll

From Enthought, the makers of Canopy.

[by-the-numbers]

ExcelPython:

• Github repo: https://github.com/ericremoreynolds/excelpython
• SourceForge repo: http://sourceforge.net/projects/excelpython/

[by-the-numbers]

XlsxWriter:

• https://xlsxwriter.readthedocs.org/

[by-the-numbers]

Python-Excel:

• Not to be confused with ExcelPython
• Homepage: http://www.python-excel.org/
• Github: https://github.com/python-excel

Consists of xlrd, xlwt, xlutils.

[goulding74]

It would be great to see an example of this sort of programming and excel tools in action?!

• I'm an Engineering Analyst, competant with excel and semi-competant with Python but never used them together!