Is possible (and a good practice) to use Python to develop a macro in Excel?

Question

Python in Excel?

Answer 1

That should do the trick ;)
https://www.xlwings.org

Answer 2

nothing possible guys

Answer 3

I don't mind mangling the data in Excel, as it is very efficient in translating the regular user experience into organized and clean data.
You can restrict it in many ways which is especially important in a complex organization or corporation environment. It is your input() -- just for everyone :)
Finally, it can output a nice .csv which is easily converted to a DataFrame. So it takes a loooooot of data cleaning from you, at least at the first stage ;)

Answer 4

I've never tried Python in Excel but I might have to now, thanks for the link Kuba Siekierzyński.

Whether to use Python or VBA may depend on what you're trying to develop the macro for. I find VBA very easy to use and great to work between applications.

Answer 5

I think you might be confusing VB with VBA, VB support finished about 10 years ago but as far as I'm aware VBA is very much alive.

VBA has plenty of libraries and as I mentioned before, it's super simple to work with other applications just by adding them as a reference library.

I've used VBA in Excel to update thousands of records on an old main frame many times as an example.

Answer 6

Thanks both, Kuba and Duncan for your quick answers. I am asking because I think Excel is one of the most useful tools I have worked with, even without using Macros, and I would like to start creating Macros now, but I am doubting about the language. I have read that VBA is not longer maintained by Microsoft, so despite being still in use, looks like kind of obsolete and replaced by VB.NET. On the other hand, using Python for macros is pretty attractive due to its clean syntaxis and powerful libraries for data analysis (numpy, scipy, pandas...). Considering this, does still make sense using VBA? Looking forward for your expertise opinion :)

Answer 7

David Rueda Robles Yep, been there, done that, too :)

Answer 8

When I've seen this question I have put my eyes like 💖💖💖.
For me, Excel is a wonderful programme. I've been programming in excel without scripts, building an automatic time table for 50 persons.
If you change one data, the time table re build it.
I'll have very attention to this article.
Thanks

Answer 9

Maybe in Office 2019 :-)
https://www.bleepingcomputer.com/news/microsoft/microsoft-considers-adding-JUMP_LINK__&&__python__&&__JUMP_LINK-as-an-official-scripting-language-to-excel/

Answer 10

You are right Duncan, what finished for VBA was the supply of licenses to new users, but Microsoft has not been able yet of migrating its use on to .NET platform. Topic solved, thanks!!

Answer 11

when you record a macro in Excel or Word VBA is created in the background. you can open the module where it is stored to read or edit the code

Answer 12

I have been writing VBA coding in Excel, and other office products, for over 20 years. I find VBA very useful and fast, if done properly.

I’m looking forward to learning Python and am excited about the possibility of Microsoft adding Python as a scripting language.

Answer 13

I have learned some cool stuff

Answer 14

Hae gues python experts
How do I call savadata function to a button in a tk software to savedata to a local db
being entered to the tk?

Answer 15

Microsoft announced today Javascript support for Excel functions, but not python.
Available now for Office insider users.
https://www.bleepingcomputer.com/news/microsoft/microsoft-adds-support-for-javascript-functions-in-excel/

Answer 16

wow nice. python in excel. I should try

Answer 17

Thanks for the link! I am just starting in python but I have a lot of experience in Excel so I will definitely be trying to put this to use together now :)

Answer 18

Thanks for the update Udi :)

Answer 19

nothing is possible... who are intrested in creating new things... should try python in exal...

Answer 20

Kuba Siekierzyński thanks for sharing, I wanted to apply what I learned from python (At SoloLearn) in my daily basis. I think this information is what I need.