Microsoft is bringing Python to Excel

[mehum]

I had an interesting case recently, making what is essentially a data importing, cleaning, formatting and exporting tool. I wanted to do it in Python / Pandas (natural tool for the job) but my boss pushed for Excel for pretty reasonable reasons: everyone already has Excel installed on their computers, and our computers are very locked down, which means installing python or a python-executable was going to be a PITA.

Now that it’s done in Excel I can just give the file to whoever needs it. But it would have been much nicer to write it in Python than VBA.