Open MS Excel Spreadsheet with Python
A.Bailey
allisonb at terralogicgis.com
Thu Jul 17 20:43:44 EDT 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