[python-win32] Excel COM-object for cursor position UPDATE
James Matthews
nytrokiss at gmail.com
Fri Nov 24 21:35:39 CET 2006
Thanks helped me i was just working on that also!
On 11/23/06, Bob Gailer <bgailer at alum.rpi.edu> wrote:
>
> Please reply to the list as well as me. Others learn and sometimes offer
> help.
> Rikard Bosnjakovic wrote:
> >
> > I'm an utter novice of COM/DOM and I really don't have much knowledge
> > about it. I know how to launch Word/Excel from Python by using
> > Dispatch("Excel.Application"), but that's about it. I haven't found
> > any reference manual for the (DOM?-)commands I can use within Excel,
> > except for the ones I found in a couple of tutorials similiar to this
> > one: http://www.markcarter.me.uk/computing/python/excel.html
> Where you see exactly what you want.:
>
> xlApp = Dispatch("Excel.Application")
> xlApp.Visible = 1
> xlApp.Workbooks.Add()
> xlApp.ActiveSheet.Cells(1,1).Value = 'Python Rules!'
>
> The last line enters the text 'Python Rules!' in the upper left cell of
> the worksheet.
>
> Where do you need help with that?
> >
> > I have browsed MSDN with the hope of finding any references/short
> > tutorials or what so ever, but I was out of luck. I am also aware
> > that COM is "dead"
> Dead? As in no longer functioning? No way. And .NET AFAIK is no
> replacement for COM.
> > now that .NET is growing, but again; the only thing
> > I'm after is a bunch of small commands for me to try out so I can
> > automate Excel from within Python.
> So try the above code sample and see what happens.
>
> The DOM is documented in MSDN at:
>
> See
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrconexcelobjectmodeloverview.asp
>
> --
> Bob Gailer
> 510-978-4454
>
> _______________________________________________
> Python-win32 mailing list
> Python-win32 at python.org
> http://mail.python.org/mailman/listinfo/python-win32
>
--
http://www.goldwatches.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/python-win32/attachments/20061124/8b5fa869/attachment.html
More information about the Python-win32
mailing list