

PyXLL also offer a 30 day free trial, and then paid options after that.įor this, I chose to look at DataNitro, but will look at the others in the future. If you purchase one of their membership options you get added benefits like ongoing support and updates, and the ability to write UDF's in Python. There are a number of packages that allow you to run Python in Excel: xlwings, PyXLL, and DataNitro are three options.ĭataNitro offers a 30 day free trial, but will keep working after this. The issue was how do I get Python to run in Excel? Python in Excel

I turned to Python to do this as it has the capability to plot equations quite easily. I know there are ways to do this that involve producing a set of data points, and then using those to create a chart, but I want to be able to just say, here's my equation, plot it. If I have something like 2x 2 + 3x + 2, I want to see a plot or graph of the curve that the equation produces.

Something I've wanted to do easily in Excel is plot equations.
