How To Read Excel Files In Python?
steve at holdenweb.com
Tue Dec 13 11:33:44 CET 2005
> 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,
The best way to proceed is to record actions as macros in Excel and then
use the recorded VBA as a guide to the Pythin required.
Unfortunately the office APIs aren't very complete in their documentation,
Good places to look, as long as you don't mind rooting around:
Steve Holden +44 150 684 7255 +1 800 494 3119
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/
More information about the Python-list