BASIC vs Python
Michael Hoffman
m.h.3.9.1.without.dots.at.cam.ac.uk at example.com
Sat Dec 18 08:34:08 EST 2004
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>)
--
Michael Hoffman
More information about the Python-list
mailing list