Open MS Excel Spreadsheet with Python

A.Bailey allisonb at terralogicgis.com
Fri Jul 18 02:43:44 CEST 2003


"Allison Bailey" <allisonb at terralogicgis.com> wrote in message news:<mailman.1058229111.12248.python-list at python.org>...
> Hi Folks,
> 
> I would like to open an existing MS Excel spreadsheet and extract
> information from specific worksheets and cells.
> 
> Then, I get errors when I try the following:
> sh = wb.worksheets(1)
> 
Thanks to everyone for suggestions, hints, and code, particularly the
ideas about where to find more information.  I know that MS Excel is
not every Open Source-er's idea of a good time, but my plan is to get
my data out of there as fast as I can and do the fun stuff in Python!

It turns out, as some people pointed out, that after running the
makepy utility, the methods become case-sensitive, so it should have
read:
sh = wb.Worksheets(1)
and everything would have gone smooth as silk!

And yes, I would love to preview Excel/Python code if you would like
to pass it along to me.

Allison




More information about the Python-list mailing list