How To Write Excel Macros In Python?

Tom Smykowski
6 min readOct 21, 2022

As a Python programmer you have to remember when four years ago Microsoft was considering to introduce Python as a scripting language for Excel — Microsoft’s flagship spreadsheet application.

So what happened over the course of four years, and do we have Python for Excel?

Microsoft was for some time gathering user feedback about the use of Python in Excel. Eventually the topic somehow died.

Then, just a year ago someone asked again about the Python for Excel and received this official response from Microsoft team:

I have been working for some large organizations and what I understand from this answer, is that some people from the Excel team and Python team were holding some conversations about the integration of Python into Excel.

It means that they had to spend time allocated for that very topic. Such inter-team communication is usually a marker that there was enough business data to put the concept on the table of two teams.

--

--

Tom Smykowski
Tom Smykowski

Written by Tom Smykowski

Software Engineer & Tech Editor. Top 2% on StackOverflow, 3mil views on Quora. Won Shattered Pixel Dungeon.

No responses yet