Michael Hoffman wrote:
Gregor Horvath wrote:

 > Or make any given standard python object accessible from MS Excel in 2
 > minutes.

from win32com.client import Dispatch

xlApp = Dispatch("Excel.Application")
xlApp.Visible = 1
xlApp.Workbooks.Add()
xlApp.ActiveSheet.Cells(1,1).Value = 'Python Rules!'
xlApp.ActiveWorkbook.ActiveSheet.Cells(1,2).Value = 'Python Rules 2!'
xlApp.ActiveWorkbook.Close(SaveChanges=0)
xlApp.Quit()
del xlApp

(stolen from <http://www.markcarter.me.uk/computing/python/excel.html>)

Nice, but not really what the OP asked for. You make Excel accessible from Python, instead of the other way round.


Regards,
Jan
--
http://mail.python.org/mailman/listinfo/python-list

Reply via email to