BASIC vs Python
Jan Dries
jan.dries at dcube-resource.be
Sat Dec 18 09:06:31 EST 2004
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
More information about the Python-list
mailing list