Open MS Excel Spreadsheet with Python
sybrenUSE at YOURthirdtower.imagination.com
Tue Jul 15 03:44:06 CEST 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
> 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.
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