[Tutor] how to do excel in python

[Chris Fuller]

There are many ways.  The simplest is to export the file to CSV and load that, 
but you'll only get one worksheet, and it's a big hassle to update the Excel 
file that way.  You can save the spreadsheet as an ODF file, which is a fully 
documented XML format that Python can read and write easily, but you might 
give up some Excel features (but a lot fewer than with CSV format).

You can also have the spreadsheet open in excel and talk to it from Python via 
COM.  If you're on Windows and have Excel, this approach can be the most 
flexible.

http://docs.python.org/library/csv.html
http://www.linuxjournal.com/article/9347
http://www.google.com/search?q=excel+com+python

Cheers

On Thursday 05 August 2010, invincible patriot wrote:
> hi, can any one tell me how can I access MS excel worksheet in python and
> how can I access itz individual cells..??????