win32com and Excel

[Eric Hagemann]

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.