How Fast is Python in Excel?
A performance comparison of Microsoft's recently announced Python in Excel feature, and the Python Excel add-in PyXLL.
Results (Spoilers ahead!)
====================
Test 1:
PyXLL: 137 milliseconds
MS Python in Excel: Didn't finish
Test2:
PyXLL: 11 milliseonds
MS Python in Excel: 6.56 seconds
Test3:
PyXLL: 822 milliseconds
MS Python in Excel: 12.98 seconds / 3.55 seconds*
*when using cached arguments
Resources
=========
PyXLL (Python add-in for Excel): https://www.pyxll.com
MS Python in Excel: https://techcommunity.microsoft.com/t...
FAQ on differences: https://support.pyxll.com/hc/en-gb/ar...
FastExcel add-in: https://www.decisionmodels.com/FastEx...
00:00 - Intro
00:24 - The test case
01:16 - Timing with the PyXLL add-in
02:40 - Setting up the test with MS Python in Excel
05:14 - Timing with MS Python in Excel
05:48 - Kill Excel and try something smaller
06:02 - A smaller test
07:28 - The result!
07:35 - A note on recalculation
08:27 - Bonus! A test using DataFrames and FastExcel
11:23 - Closing
On this page of the site you can watch the video online How Fast is Python in Excel? with a duration of hours minute second in good quality, which was uploaded by the user PyXLL - Write Excel Add-Ins with Python and Java 13 September 2023, share the link with friends and acquaintances, this video has already been watched 2,212 times on youtube and it was liked by 49 viewers. Enjoy your viewing!
