Personally I’ve used Excel as a simple charting tool for quick science research. I figured that several screencasts on this leading to the creation of a Python COM server would make for a good introduction. The COM server can be used to embed Python code into other applications.
The 3 minute overview gives you an introduction to what’s covered. For the first two episodes I talk about using pyWin32 to talk interactively to Excel and fixing some weird behaviour with local references that’ll catch you out when you start experimenting.
The weird behaviour doesn’t cleanly close a previous Excel instance so you can’t start another one – you have to delete the process in TaskManager each time if you don’t know how to close things down nicely.
Over the next 10 days I’ll release the next three episodes covering:
- using Excel for charting
- using Excel for input as well as output
- building a Python COM server which we call from within Excel
This is one of our ShowMeDo Club tutorials for subscribers, a part of our 231 (mostly free!) screencasts that help you to learn Python. Subscribers get access to 6+ hours of Python tutorials, exercises and walk-throughs with new episodes every week.If you enjoyed this post, make sure you subscribe to my RSS feed!