Open MS Excel Spreadsheet with Python

Sybren Stuvel sybrenUSE at YOURthirdtower.imagination.com
Mon Jul 14 21:44:06 EDT 2003


Allison Bailey enlightened us with:
> I would like to open an existing MS Excel spreadsheet and extract
> information from specific worksheets and cells.

Save the files as OpenOffice.org spreadsheets. They have an
open format, which basically boils down to a few XML files zipped up and
named something.sxc. It's about 20 minutes to make a program that
parses it.

> I think I'm missing something fairly fundamental, but I've
> googled all over the place and can't seem to find anything very
> introductory about opening and using data from MS Excel using Python.

That's probably because most sensible Open Source users make sure they
don't come anywhere close to MS Office.

Sybren
-- 
The problem with the world is stupidity. Not saying there should be a
capital punishment for stupidity, but why don't we just take the
safety labels off of everything and let the problem solve itself? 




More information about the Python-list mailing list