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