Live data from Hacker News

Show HN: Script Excel with Python

ironspread.com

11–20 of 63 posts

Re: Show HN: Script Excel with Python

#16
I still have a soft spot for VBA, especially in Excel. I wrote a supply-chain management application in Excel+VBA that's still in production today. As comfortable as I am with VBA, I wouldn't mind in the least ditching it for Python, which makes writing routine methods trivial. Great work!

Re: Show HN: Script Excel with Python

#17
The big question I have is why would I use this instead of a real database. If i am not mistaken excel can hook up to ODBC sources and then I can just script things as I normally would using the database drivers.

Re: Show HN: Script Excel with Python

#19
post #12

This seems really cool, but I'm admittedly not familiar with this area. How does this compare or supplement to Excel VBScript?

Our goal is to replace VBScript. We'll have the same basic functionality, but using Python instead of VB, and with access to all of Python's libraries.

It's backwards compatible too - you can run VBA scripts and Python scripts at the same time.

Post reply on HN