Monday, October 6, 2008

Reading/Writing Microsoft Excel in Python

Creating report invariably ends up with using excel and most of the time the data for same isn't really in excel format. Yeah, it comes in through cvs files. And most of the time one would end up sync the csv file into the excel file and vice versa (probably).

This is where, I dig around on the internet and found this amazing stuff:
According to the author:
Provide a library for developers to use to extract information from Microsoft Excel (tm) spreadsheet files. It is not an end-user tool.

A good wrapper for same is available here:
According to the author:
readexcel is a somewhat streamlined rewrite of this small python wrapper class by Bryan Niederberger on top of John Machin's xlrd package, intending to make reading worksheets in an Excel file even simpler and more convenient.

... on the side note, the ExcelMailer is pretty exciting stuff, I had written similar thing previously and am gonna try the same.