Author Archives: agilis

Testing post

Gonna test a ton of posts! GWAR! Subscribe to the comments on this post

Posted in Uncategorized | Leave a comment

Moving around Excel efficiently in code

Let’s face it, Excel is horrible at iteration over cells. Somewhat like in Matlab where a loop over entries will kill your processing time, you don’t want to move from cell to cell reading information and processing unless you have … Continue reading

Posted in Uncategorized | Leave a comment

Patterns in Python: Strategy

With all the posts about Objective-C and design patterns lately that David’s been posting, it’s only fair that we bring back some of it to Python with some simple patterns. So, let’s  steal the strategy pattern post today! Subscribe to … Continue reading

Posted in Uncategorized | Leave a comment

Python, Subversion, and revision diffs

One of my hobbies is working as an amateur translator for scripts (of the textual kind) and assorted short stories. Since I move around to different machines often, it just makes sense to put everything on subversion. Of course, when … Continue reading

Posted in Uncategorized | Leave a comment

Pulling data from Excel using Python, COM

Previously, I had a quick overview of extracting data from Excel files using the python xlrd module. While that’s the recommended way of extracting data that you need from Excel data files you receive, it’s not the way to make … Continue reading

Posted in Uncategorized | Leave a comment

Working with named Excel ranges with Python/VBA code

Named ranges are useful things, especially for writing formulas that need to refer to the same block of cells constantly. You can easily set them by hand just by selecting the range you’re interested in, and then clicking the box … Continue reading

Posted in Uncategorized | Leave a comment

Closing Excel using Python

Closing Excel from Python using COM seems pretty simple, but there’s a few little caveats to remember. Subscribe to the comments on this post

Posted in Uncategorized | Leave a comment

R1C1, the unused Excel cell reference system

Everyone knows about the “A1 style” notation for referring to cells in Excel. It’s what the labels on the edges of the worksheet are after all, and it’s the most natural thing to work with if you’re using the standard … Continue reading

Posted in Uncategorized | Leave a comment

Playing with data: CSV, quirks and pitfalls

Comma Separated Values, CSV, is the most basic way to export data out of just about any program that handles data in table format, from databases to spread sheets. The problem is that CSV isn’t standardized, so different programs can … Continue reading

Posted in Uncategorized | Leave a comment

Pulling data from Excel using Python, xlrd

Excel’s data format is everywhere in the business world, and more often than not, you’ll wind up getting chunks of data from people dumped into an Excel file. Sure, CSV tends to be the “lowest common denominator” exchange format for … Continue reading

Posted in Uncategorized | 1 Comment