Author Archives: agilis

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

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 →

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 →