Author Archives: agilis

Working with Excel Cells using VBA and Python

Working with Excel is all about manipulating the data and relationships between cells, and there are lots of ways to do such a thing. Here’s a tour of a few of those variations. Subscribe to the comments on this post

Posted in Uncategorized | Leave a comment

Basic working with Excel workbooks with Python

Manipulating Excel with Python feels very much like manipulating Excel from within the VBA language. In fact, it uses the same objects, and the only major differences are that you don’t have access to autocompletion, and the syntax for function … Continue reading

Posted in Uncategorized | Leave a comment

Controlling MS Office with Python

Automating and extending the various features of Microsoft Office is often done with the Visual Basic for Applications (VBA), and in the (relatively near) future, the .NET frameworks. But thing about VBA that’s annoying is that it’s usually bound within … Continue reading

Posted in Uncategorized | Leave a comment