How To Read Excel Files In Python?

gene tani gene.tani at gmail.com
Tue Dec 13 12:35:31 EST 2005


Anand wrote:
> Hello,
>
> Can I get some help on how to read the excel files using python?
>
> from win32com.client import Dispatch
> xlApp = Dispatch("Excel.Application")
> xlWb = xlApp.Workbooks.Open("Read.xls")
> xlSht = xlWb.WorkSheets(1)
>
> But sadly, I am unable to proceed further about how to read the cells of the
> worksheet of my excel file!
>
> Thanks for your help and cooperation.
>
> Best regards,
> Anand

http://www.python.org/pypi/xlrd/0.3a1
and the online (activestate) cookbook has lots of hits, search on
"excel" "MS office" "CSV" "ODBC" etc
http://aspn.activestate.com/ASPN/search/searchRecipes?query=excel




More information about the Python-list mailing list