[python-win32] DDE: python server/excel client - pass array?

[timr at probo.com]

On Wed, Dec 24, 2008 at 05:28:18PM -0800, David Haas wrote:
>
> I've run into a problem with DDE which, after much googling and trial
> & error, I managed to work around, but I'm pretty sure there's a
> better solution.
> 
> I think the problem is this: there's currently no way for a python DDE
> server to pass an array back as a response from a DDE Request - it's
> either a string, or nothing.  Since Excel expects the response it
> receives from a DDE Request that it makes to be an array, it dies
> (with what I believe is an Error 2042) when communicating with a
> Python DDE server.

DDE works exclusively in strings.  So, the key is to figure out how
to encode the array as a string in order to satisfy Excel.  I've been
searching for an Excel DDE reference guide without success, although
I'm certain there must be one.
-- 
Tim Roberts, timr at probo.com
Providenza & Boeklheide, Inc.