[BangPypers] Excel and Python

[Satheesh Babu Vattekkat]

Check out win32com (I am assuming you want to do this from a Windows
machine).  Here is a small snippet on reading the value from cell A1 in the
active sheet.
from win32com.client import Dispatch
flxls = "c:\\my\\file.xls"
xl = Dispatch ("Excel.Application")
xl.Visible = True
xl.Workbooks.Open(flxls)
workbook = xl.ActiveWorkbook
sheet = xl.ActiveSheet
param_1 = sheet.Cells(1,1).Value
workbook.Close()
xl.Quit()
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/bangpypers/attachments/20090902/91109dba/attachment.htm>