April 7th, 2008

Using Excel files with Python


there are 3 different ways to interact with Excel files:

1. To control the Excel application and read/write Excel files (.xls, etc.), you need a Win32 box with, you need to write a COM application. to do this, you need a Win32 box and Python for Windows Extensions:


2. To read Excel files (w/o requiring a Win32 box, say on *ix/MacOS), check out XLRD:


3. To create Excel files (again, w/o Win32), check out XLWT (replaces pyExcelerator):