win32com question

[Jeff Shannon]

Matthew Miller wrote:

> hi,
>
> i'm trying to figure out how to use the win32com interface. i haven't
> yet figured out how to 'phrase' optional arguments within a python
> expression. given something in vba like:-
>
> Workbooks.Open "spam.xls", ReadOnly:=true, Password:="password"
>
> how do you phrase this in python/win32. i got this far
>
> xlapp=win32com.client.Dispatch("Excel.Application")
> xlapp.Workbooks.Open("spam.xls")
>
> but can't figure out how to pass in the named args for the required
> functions .
> any help would be great.
> Thanks...

Use keyword arguments:

xlapp.Workbooks.Open("spam.xls", ReadOnly='True', Password='pass')

Note that, particularly the ReadOnly option, may use COM constants rather
than
the string "true", so you might need to use

from win32com.client import constants
xlapp.Workbooks.Open("spam.xls", ReadOnly=constants.True,
Password='pass')

Of course, you'll have to check your COM server's docs to find what uses
constants,
and constants are only available if you use early binding
(makepy/gencache)...

Jeff Shannon
Technician/Programmer
Credit International