Reading MS Excel Files ?

[Les Schaffer]

Peter Skipworth wrote:

> Quite a few of the scripts I develop need to be able to parse a
> Microsoft Excel spreadsheet - with Perl, this was quite simple, using a
> module called Spreadsheet::ParseExcel. Does anything similar exist for
> Python ?

well, its not pretty but it works fine:

run xlhtml on your spreadsheet to produce an html table, then run w3m on 
that html to get the data

        result = os.popen( "/usr/bin/xlhtml -te %s > %s" % \
                           ( excelFile, tempFile ) ).close()
...

        sheet = os.popen( '/usr/bin/w3m -dump %s' % tempFile )

w3m's output is lines for rows, and '|' seperating columns. works fine for 
me.

les schaffer