I’m thrilled to see the availability of Pyvot, a python package for manipulating tabular data in excel. This is part of the Python Tools for Visual Studio (PTVS) ecosystem.
Check out the codeplex site at http://pytools.codeplex.com/wikipage?title=Pyvot or the tutorial on python.org.
Excel does expose an object model through COM, but it’s tricky to use. Pyvot provides a very simple python programming experience that focuses on your data instead of Excel COM object trivia. Here are some of my favorite examples:
Some other FAQs:
Anyway, if you need to excel goodness, especially filters, check out Pyvot and PTVS.