Shodan Shodan - 4 months ago 29
Python Question

Accessing Enovia's python interface from Excel / VBA?

We are using software called Enovia.

I would like to query Enovia from inside Excel / VBA.

After some search, Enovia seems to have a programming interface called Abaqus.

http://www.3ds.com/products-services/simulia/services/training-courses/course-descriptions/introduction-to-the-abaqus-scripting-interface/

I would like to access this interface in VBA directly but I didn't find anything to that effect.

I found two projects that might allow Excel/VBA to talk to python components or at least to python scripts.

They are as follows

Python For Excel
http://opentradingsystem.com/PythonForExcel/main.html

And the discontinued excelpython
github.com/ericremoreynolds/excelpython
which became integrated in xlwings
xlwings.org

I am not familiar with python nor these two projects. I'm not sure if they will allow me to do what I want.

I'm ok with learning some python to do this but my main program and user interface is in excel.

I figure I could make some simple python scripts then call them through the python interpreter from excel with shellexecute but that is not a very elegant solution I think.

Any advice welcomed

thanks !

Answer

Enovia uses the MQL language for scripting. There are some guides available, such as http://emdros.org/MQL-Programmers-Guide.pdf

I would recommend some training such as http://www.techniatranscat.com/services/education/mql-and-tcl-intro as this doesnt seem to be a very common language.

Not to be confused with the financial trading language MQL4/MQL5 from MetaQuotes Software Corp.

Comments