Tag Archives: Excel

3D Matplotlib Plots in Excel

Posted on April 17, 2022 by dougaj4

As well as Excel, the code shown in this post requires current versions of Python, Numpy, Matplotlib, and pyxll. The required import statements at the head of the Python code are: The spreadsheets and Python code described below may be … Continue reading →

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

Python functools – cache and lru_cache

Posted on April 1, 2022 by dougaj4

Update 3rd April 2022: Following the comment from Larry Schuster I have modified the code so that the factorial0 function actually uses cache as intended, rather than lru_cache. I also added code to clear the cache after each timer run, … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , , | 2 Comments

More Matplotlib problems

Posted on March 23, 2022 by dougaj4

Following an upgrade to some Python libraries, I found that problems with plotting from Matplotlib causing Python to crash were recurring (previously reported here). When called from Excel with pyxll this was also causing instant crashes of Excel. I eventually … Continue reading →

Posted in Excel, Link to Python, PyXLL | Tagged , , , , , | 3 Comments

VBA procedures for the Numerical Analysis of Tabular Functions

Posted on March 12, 2022 by dougaj4

Long time on-line friend Alfred Vachris has recently been converting Fortran code developed through his working career into VBA: I had the opportunity to work at Grumman while going to Graduate School and they gave me a part-time job as … Continue reading →

Posted in Coordinate Geometry, Curve fitting, Excel, Fortran, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

Display Matplotlib animations in Excel

Posted on February 28, 2022 by dougaj4

The latest version of pyxll (5.4.0) allows animations generated in Matplotlib to be simply copied to Excel. A spreadsheet with the examples shown below, and the associated Python code can be downloaded from: Animations2.zip The screenshot below shows the simple … Continue reading →

Posted in Animation, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | 1 Comment