documentation for win32com?

[John Salerno]

Is there anything better to read on how to use this module for working
with Office programs? This is not very heartening to read in the
official docs:
-----------------------
How do I know which objects are available?

Good question. This is hard! You need to use the documentation with the
products, or possibly a COM browser. Note however that COM browsers
typically rely on these objects registering themselves in certain ways,
and many objects to not do this. You are just expected to know.
-----------------------

Yeah, thanks...

So does this mean that the code can be different each time, or is there
still a pre-determined way to refer to things, such as opening Excel,
reading a spreadsheet and working with it, etc.? If so, where can I find
a list of those objects and methods?

Thanks.

[Ross Ridge]

John Salerno wrote:

So does this mean that the code can be different each time, or is there
still a pre-determined way to refer to things, such as opening Excel,
reading a spreadsheet and working with it, etc.?
For a given version of Excel, there's a "pre-determinied way" of doing
those things. Different versions of Excel may do things the same way or
differently depending on what exactly you're trying to do.
If so, where can I find a list of those objects and methods?

In the documentation for the version of Excel you're using.

Ross Ridge

[Roger Upole]

The Excel docs are your best bet. The examples they give
are all MS-specific languages like VB, but most translate
fairly easily to Python.

You can also run makepy on the Excel typelib, which will
generate a file with all the methods, events etc available
thru the Excel object model.

Also, searching this group and the pywin32 mailing list
for "excel.application" turns up a bunch of sample code.

hth
Roger
"John Salerno" <jo******@NOSPAMgmail.com> wrote in message news:hQ******************@news.tufts.edu...

Is there anything better to read on how to use this module for working with Office programs? This is not very heartening to
read in the official docs:
-----------------------
How do I know which objects are available?

Good question. This is hard! You need to use the documentation with the products, or possibly a COM browser. Note however that
COM browsers typically rely on these objects registering themselves in certain ways, and many objects to not do this. You are
just expected to know.
-----------------------

Yeah, thanks...

So does this mean that the code can be different each time, or is there still a pre-determined way to refer to things, such as
opening Excel, reading a spreadsheet and working with it, etc.? If so, where can I find a list of those objects and methods?

Thanks.

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

[Méta-MCI]

Hi!
MS-Office-2007 beta2, can downloaded here :
http://www.microsoft.com/office/prev...etthebeta.mspx
(with a passport account).

Doc, for COM access, are include in the help-system.
@-salutations

MCI

[Tim N. van der Leeuw]

Roger Upole wrote:

The Excel docs are your best bet. The examples they give
are all MS-specific languages like VB, but most translate
fairly easily to Python.

You can also run makepy on the Excel typelib, which will
generate a file with all the methods, events etc available
thru the Excel object model.

You should definately run makepy, it will be a great help, but there
are objects for which you can still not get any 'help' from your IDE's
autocompletion...
In those cases you'll just have to wing it, and indeed refer to the
Excel helpfiles for VBA methods/objects/etc.

Look at some samples on the web, and experiment a lot (using the
PythonWin IDE seems to work quite well for this kind of experimenting,
perhaps IDLE would also do it quite well. Due to the dynamic nature of
this kind of explorations, the pydev Eclipse plugin doesn't work well
for it).

Also, searching this group and the pywin32 mailing list
for "excel.application" turns up a bunch of sample code.

hth
Roger

Cheers,

--Tim