xlSciPy 1.01

The xlSciPy spreadsheet, introduced here, has been updated with many new functions.  The new version, including full open source code (VBA and Python) can be downloaded from:


The spreadsheet requires Python to be installed, including NumPy and SciPy.  It is written for Python 2.7 and has not been tested with Rel 3.  All other files, including the required ExcelPython package, are included in the download file.  Just unzip everything to its own folder, and it should work.  Note that the first time it is loaded compilation is quite slow, so be patient.

See the previous post for details of the original inclusions.  New functions in this version are:

Fast Fourier Transform functions:


New sparse matrix solvers, including iterative and direct solvers:


SciPy distance functions:




This entry was posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.