[python-win32] excel access...

Christopher Quinn cq at htec.demon.co.uk
Thu Aug 21 13:21:57 EDT 2003


hello list.

i'm making a first foray into the windows world and using pythonCOM to 
access fields of an excel spreadsheet.
all seemed ok till i inquired the value of a cell containing a 
function which retrieved in turn it's value over DDE from another 
application (a stock price feed).
i opened the spreadsheet with the update option set and so expected 
excel to deliver a real result. unfortunately it returns -2146826259 
every time.
my question then is: should i be doing something other than 
Cells(x,y).Value  to extract the data at some instant?

i suspect i perhaps cannot use the COM interface to do what i want...
-- 
thanks.
- chris




More information about the Python-win32 mailing list