[Tutor] Read Excel file without COM

[Liam Clarke-Hutchinson]

Actually, and I'm surprising myself here, but COM would be the easiest way
to go about this if you're not able to convert to CSV. If you want to avoid
COM, why don't you use it to save each page of the spreadsheet as a CSV file
and then go from there?

The close tie-in between Excel and COM is designed for your problem...
Alternatively check PyPI, I'm sure there's something that will do what you
want, but most of what you find will probably just use the Win32 package
instead of reinventing the wheel.

Regards, 

Liam Clarke

-----Original Message-----
From: tutor-bounces at python.org [mailto:tutor-bounces at python.org] On Behalf
Of wkranec at gmail.com
Sent: Wednesday, 30 November 2005 8:59 a.m.
To: tutor at python.org
Subject: [Tutor] Read Excel file without COM


Hi,

I have written a script which reads a Microsoft Excel file and moves the
data inside onto a database.  The script uses the PyWin32 module written by
Mark Hammond, but I was wondering if anyone knew of a way to extract the
data without using COM.  A Python module would be best, but I suppose any
conversion program that could be called from Python would be satisfactory.

Saving the file as .csv isn't really an option since there are multiple
pages in the sheet, and the people sending the files have been somewhat
"standardized" to send an Excel sheet.  I have thought briefly about using
xml, but this would require me to rewrite a lot of my code, and I would like
to avoid this unless there are some other good reasons to do so.

I think I found a good resource at
http://chicago.sourceforge.net/devel/docs/excel/, but it doesn't include any
Python code.  Does anyone know of something similar for Python?

Thanks,

Bill
_______________________________________________
Tutor maillist  -  Tutor at python.org
http://mail.python.org/mailman/listinfo/tutor

A new monthly electronic newsletter covering all aspects of MED's work is now available.  Subscribers can choose to receive news from any or all of seven categories, free of charge: Growth and Innovation, Strategic Directions, Energy and Resources, Business News, ICT, Consumer Issues and Tourism.  See http://news.business.govt.nz for more details.




http://www.govt.nz - connecting you to New Zealand central & local government services

Any opinions expressed in this message are not necessarily those of the Ministry of Economic Development. This message and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivery to the intended recipient, be advised that you have received this message in error and that any use is strictly prohibited. Please contact the sender and delete the message and any attachment from your computer.