Open MS Excel Spreadsheet with Python
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
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.
More information about the Python-list