Niki Spahiev wrote:
Is this COM DLL server? I am interested in using wxPython as DLL plugin.
Yes, it is a COM DLL server. I had to do a few tricks to get it working as
you cannot use functions from within excel(2000) if they are defined in a
COM server, except from within VBA. I wrote a little excel .xla to load the
com server and forward the function calls to the python server.
You would call your python code in the following manner
=FTCall("date.AddDays,A11,10), within a cell. The FTCall function is
implemented in the .xla. The .xla then forwards the call and parameters to a
method defined in the com server. The com server then calls the correct
python method with the parameters.
This works extremely well for us. Once the .xla is written no futher
development work in VBA is required and you can write extensions to excel
with python.
You can pop dialogs, get values from excel, set values in excel etc.
If anyone else is interested I could elaborate a little more and maybe set
up a document on how to do this.
Regards
Gerrit van Dyk
···
-------------------------------------------------------------------------
This e-mail is intended only for the use of the individual or entity named
above and may contain information that is confidential and privileged,
proprietary to the company and protected by law. If you are not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this e-mail is strictly prohibited. Opinions, conclusions and
other information in this message that do not relate to the official
business of our company shall be understood as neither given nor endorsed by
it.