win32com and Excel

[Scott]

As a side note, I also recommend this book.  I really wouldn't even try
any python-com programming without reading it first.  If you can't afford
to buy it, it seems you can view it at http://www.netlibrary.com .  It's
a neat site that allows you to "check out" books for a period of time 
(usually 24 hours at a time) and read them online.  The only drawback is
they only allow so many "check outs" of each book so it may or may not
be available to read.

-Scott

PS.
Here is an exact URL:
http://www.netlibrary.com/SUMMARY.ASP?EV=1239265&ID=24666&advquery=

and chapter 9 is the main Excel chapter.

In article <B_u_4.111323$E85.2192336 at news1.rdc1.md.home.com>, 
Eric Hagemann wrote:
>Matthew,
>    Read Hammonds "Programming Python in Win32".  There is a very good
>headstart there with an example of a class that eases the interaction
>w/Excel via COM.  Next get "Writing Excel Macros" by O'Reilly.  It is all
>about how to program Excel via Visual Basic but translates very well into
>Python COM.
>
>Cheers
>Eric Hagemann
>
>"Matthew Miller" <matthewm at zebrasoft.co.nz> wrote in message
>news:3939D364.2EF22B13 at zebrasoft.co.nz...
>> hi everyone,
>>
>> A couple o0f questions:-
>> 1)
>> can you access an excel (.xls) file via com without having excel loaded
>> on that machine?
>> 2)
>> once you've done:-
>>  blah = win32com.client.Dispatch("Excel.Application")
>> can anyone give details of
>> a) howto open a particular s/s in the current directory
>> and
>> b) howto access particular cells in that particular s/s
>> and
>> c) howto close that s/s
>>
>> I have to admit that I'm hoping some kind soul will help before I'm
>> consigned to grappling with what looks like grooling documentation!
>> thanks alot matthew.
>
>