blocks|key|2461972|text|Enovia使用MQL语言编写脚本。有一些可用的指南，如http://emdros.org/MQL-Programmers-Guide.pdf|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|2461973|我推荐一些培训，如http://www.techniatranscat.com/services/education/mql-and-tcl-intro，因为这似乎不是一种非常常见的语言。|2461974|不要与MetaQuotes软件公司的金融交易语言MetaQuotes混为一谈。|2461975|entityMap|0|LINK|mutability|MUTABLE|url|http://emdros.org/MQL-Programmers-Guide.pdf|1|http://www.techniatranscat.com/services/education/mql-and-tcl-intro^0|8|3|8|3|S|17|0|0|9|1V|1|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|D]]|E|@$9|Z|A|10|1|11]]|F|$]]|$1|G|3|H|5|6|7|12|8|@]|E|@$9|13|A|14|1|15]]|F|$]]|$1|I|3|J|5|6|7|16|8|@]|E|@]|F|$]]|$1|K|3|-4|5|6|7|17|8|@]|E|@]|F|$]]]|L|$M|$5|N|O|P|F|$Q|R]]|S|$5|N|O|P|F|$Q|T]]]]

Enovia uses the <code>MQL</code> language for scripting. There are some guides available, such as <a href="http://emdros.org/MQL-Programmers-Guide.pdf" rel="nofollow">http://emdros.org/MQL-Programmers-Guide.pdf</a>

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

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

blocks|key|1708162|text|ENOVIA没有Python编程接口。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1708163|阿巴克斯是一个有限元仿真软件，它可以用自己的Python编程接口编写脚本。|offset|length|1708164|不过，ENOVIA是一种PLM软件解决方案。它们是完全不同的应用程序的不同的软件。作为编程接口，您可能会看到这|1708165|简而言之，您可能需要与您的达索系统本地支持团队联系，以便为您指出正确的方向。|1708166|entityMap|0|LINK|mutability|MUTABLE|url|http://www.3ds.com/products-services/simulia/products/abaqus/|1|http://www.3ds.com/products-services/enovia/products/v5/latest-release/|2|http://www.3ds.com/products-services/enovia/products/enovia-v5/vplm/all-products/domain/CAA_RADE-1/^0|0|0|4|0|0|3|6|1|1I|1|2|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@$D|11|E|12|1|13]|$D|14|E|15|1|16]]|A|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]|R|$5|M|N|O|A|$P|S]]|T|$5|M|N|O|A|$P|U]]]]

ENOVIA does not have a Python programming interface.

<a href="http://www.3ds.com/products-services/simulia/products/abaqus/" rel="nofollow">Abaqus</a> is a FEA simulation software which can be scripted with its own Python programming interface. 

<a href="http://www.3ds.com/products-services/enovia/products/v5/latest-release/" rel="nofollow">ENOVIA</a> though, is a PLM software solution. They are different software for completely different applications. As programming interfaces you may look at maybe <a href="http://www.3ds.com/products-services/enovia/products/enovia-v5/vplm/all-products/domain/CAA_RADE-1/" rel="nofollow">this</a> 

In short, you may need to contact your Dassault Systemes local support team to point you in the right direction.

blocks|key|1256163|text|使用tcl和mql可以解决问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1256164|TCL+x-+MQL|offset|length|1256165|entityMap|0|LINK|mutability|MUTABLE|url|https://tcl.tk/|1|http://emdros.org/MQL-Programmers-Guide.pdf^0|0|0|3|0|7|3|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]|$D|U|E|V|1|W]]|A|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]|N|$5|I|J|K|A|$L|O]]]]

Using tcl and mql you can solve the problem

<a href="https://tcl.tk/" rel="nofollow noreferrer">TCL</a> | 
<a href="http://emdros.org/MQL-Programmers-Guide.pdf" rel="nofollow noreferrer">MQL</a>

blocks|key|1256180|text|最新的Enovia版本3+3DEXPERIENCE支持基于Rest的Rest服务。您可以在enovia中创建rest，并使用excel中的vb脚本调用rest服务。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1256181|3+3DEXPERIENCE+Rest+Rest服务框架|offset|length|1256182|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/xkBPQ.png^0|0|0|S|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Latest Enovia version 3DEXPERIENCE support Rest based webservices. you can create a rest API in enovia and can call rest service using vb script in excel.
<a href="https://i.stack.imgur.com/xkBPQ.png" rel="nofollow noreferrer">3DEXPERIENCE Enovia Rest webservice Framework</a>

blocks|key|1258825|text|以上提到的Rest框架可能无法在2014X版本中使用。您必须尝试基于SOAP的服务或JAX。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1258826|选项1|offset|length|style|BOLD|1258827|Enovia是基于java的应用程序，不支持VBA+ADK直接处理后端数据。然而，webservice可以在不同平台的应用程序之间进行通信，或者由不同的编程ADK管理。|1258828|为此，您需要创建自己的服务(REST/SOAP)。为此，您需要访问服务器，首先必须编写一些java代码(Rest/SOAP服务)，并将类/jar更新为2014年服务器(tomcat)。然后，您可以在vba函数中使用该服务。同样，您必须决定数据的类型，无论是xml还是json，它都是单独的主题。|1258829|选项2|1258830|正如我先前告诉过的，Enovia是基于Java的应用程序，它提供JAVA来扩展其功能。|1258831|示例代码展示了如何获取上下文并使用Enovia。|1258832|matrix.db.Context+ctx+=+new+matrix.db.Context("http://myserver-nocas:8080/enovia");
ctx.setUser("Test+Everything");
ctx.setPassword("");
ctx.connect();
System.out.println("Is+context+set+"%2Bctx.isConnected());|code-block|syntax|javascript|1258833|正如您刚才提到的，您目前使用的是3+3DEXPERIENCE，然后3+3DPassport可能会阻塞上面的URL方法连接，因此您需要传递NO-CAS+URL。|1258834|您可以通过从本地eclipse运行上面的java代码来获得上下文。使用此ADK，您还可以调用MQL查询并无缝工作。|1258835|import+com.matrixone.apps.domain.util.MqlUtil;
String+strPartFamily++=+MqlUtil.mqlCommand(ctx,"temp+query+bus+Part+*+*+select+attribute[Length]");|1258836|但这还是基于java的解决方案，而不是VBA。|1258837|最后，3+3DEXPERIENCE在服务器中提供MQL控制台，以更友好的方式使用SQL类查询来处理所有数据。Enovia还提供了基于web的MQL控制台，但您需要获得相应的许可(管理员应该有访问权限)。|1258838|entityMap^0|0|0|3|0|0|0|0|3|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@$D|1A|E|1B|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|1C|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1D|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1E|8|@$D|1F|E|1G|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1H|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1I|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|1J|8|@]|9|@]|A|$U|V]]|$1|W|3|X|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1L|8|@]|9|@]|A|$]]|$1|10|3|11|5|T|7|1M|8|@]|9|@]|A|$U|V]]|$1|12|3|13|5|6|7|1N|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|1O|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]]|17|$]]

Above mentioned Rest framework may not be available with 2014X version. You have to try SOAP based service or JAX-RS.
Option 1
Enovia is java based application and doesn't support VBA ADK to directly work with backend data. However webservice can be used communicate between applications of different platforms or managed by different programming ADK.
For this you need to create your own service (REST/SOAP). For this you will need server access and first you have to write some java code (Rest/SOAP service) and update the class/jar into 2014 server (tomcat).
Then you can make use of that service in to your vba function.
Again you have to decide the kind of data whether xml or json it is separate topic.
Option 2
As I told earlier Enovia is Java based application, It provides JAVA ADK to extend its functionality.
Sample code shows how you can get the context and work with Enovia ADK.
<pre><code>matrix.db.Context ctx = new matrix.db.Context(&quot;http://myserver-nocas:8080/enovia&quot;);
ctx.setUser(&quot;Test Everything&quot;);
ctx.setPassword(&quot;&quot;);
ctx.connect();
System.out.println(&quot;Is context set &quot;+ctx.isConnected());
</code></pre>
As you mentioned you are currently using 3DEXPERIENCE then 3DPassport might block above URL method connection, So you need to pass NO-CAS URL.
You can get the context by running above java code from your local eclipse. Using this ADK you can also call MQL queries and work seamlessly.
<pre><code>import com.matrixone.apps.domain.util.MqlUtil;
String strPartFamily = MqlUtil.mqlCommand(ctx,&quot;temp query bus Part * * select attribute[Length]&quot;);
</code></pre>
But again this is java based solution and not VBA.
Finally 3DEXPERIENCE provides MQL console in server, to play around with all the data using SQL like queries in more developer friendly manner. Enovia also provides web based MQL console but you need to have some license for that (Administrator should be having access).

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.

<a href="http://www.3ds.com/products-services/simulia/services/training-courses/course-descriptions/introduction-to-the-abaqus-scripting-interface/" rel="nofollow">http://www.3ds.com/products-services/simulia/services/training-courses/course-descriptions/introduction-to-the-abaqus-scripting-interface/</a>

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
<a href="http://opentradingsystem.com/PythonForExcel/main.html" rel="nofollow">http://opentradingsystem.com/PythonForExcel/main.html</a>

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 !

Accessing Enovia's python interface from Excel / VBA?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我们正在使用叫做Enovia的软件。我想从Excel / VBA内部查询Enovia。经过一些搜索，Enovia似乎有一个名为Abaqus的编程接口。我想直接在VBA中访问这个接口，但是我没有找到任何类似的东西。我发现了两个可能允许Excel/VBA与python组件或至少与python脚本对话的项目。它们如下：Python 以及已停产的exelpythongithub.com/ericremor

问从Excel / VBA访问Enovia的python接口？
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从Excel / VBA访问Enovia的python接口？EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从Excel / VBA访问Enovia的python接口？
EN