interfacing to a remote excel app

Guyon Morée gumuz at NO_looze_SPAM.net
Mon Apr 26 10:39:54 EDT 2004


Let me start by saying, that I don't have a 'solution-to-go' on this, but
I'll give it a go anyway.

An idea would be to investigate on DCOM (Distributed COM) and accessing that
from Unix. I have no clue on how to do this, so I leave that as an exercise
for yourself.

Otherwise...

If you have no problem having 2 seperate interpeters, It's fairly easy to
come up with a small xml-rpc interface and acces it through that.

just my 2 cents,

ps. de groeten aan Gijs en Bas :)

"Bram Stolk" <bram at nospam.sara.nl> wrote in message
news:20040426150428.69010a3c at pistache.sara.nl...
> pyHello,
>
>
> Google helped me find a nice package to interface python with MS Excel.
> "win32all", or sometimes called by the name "pywin32".
>
> http://starship.python.net/crew/mhammond/
>
> However, this win32all extension seems to be specifically built for the
> windows platform only.
>
> What could I use if I want to interface to excel from a python interpreter
> running on a remote UNIX machine?
>
> The specific task I want to accomplish is as follows:
> I want python on UNIX to be able to make selections in excel (highlight
rows).
> Also, I want to have changes in the selected (highlighted) items in excel
> to be communicated to the python running on UNIX.
>
> What would be the best way to do this?
>
> Thanks,
>
>   Bram
>
> PS: A possible approach would be to run two interpreters, one on both
> platforms, and have the MS python talk to excel. However, I would like a
> solution with low-impact to the MS platform, and want to get away without
> having to install python and win32all on the MS machine.
>
> -- 
> --------------------------------------------------------------------------
----
>  Bram Stolk, VR Engineer.
>  SARA Academic Computing Services Amsterdam, PO Box 94613, 1090 GP
AMSTERDAM
>  email: bram at nospam.sara.nl   Phone +31-20-5923059  Fax +31-20-6683167
>
> "For the costs of subsidized agriculture in the EU, we can have all 56
million
>  European cows fly around the world. First Class." - J. Norberg
> --------------------------------------------------------------------------
----





More information about the Python-list mailing list