Thanks!

[Matthew Miller]

Thanks for the help. As my project is mostly Python and not COM/Excel, I
was hoping for a quick fix. Looks like I'll have to become a bookworm
for abit. Thanks again, matthew.

Scott wrote:
> 
> 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.
> >
> >