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..?????? _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
