"External Connection" Ansys12.1 - Excel for managing parameters ?
"External Connection" Ansys12.1 - Excel for managing parameters ?
(OP)
Hi,
emphasized among the new features of v12.1, there is the "External Connection" capability based upon xml scripts in order to interface "non-Ansys" applications with Workbench.
I'm particularly interested in managing the Parameters of a simulation in Workbench 2 (v.12.1) with Excel, passing the parameters to Excel, manipulating them in several ways and then sending them back to Ansys, and other operations like that. A further goal would be to use a WB simulation "template" as a "solver" for an Excel calculation sheet. At the time present, this "interaction" is done manually: elaborate in Excel, annotate the parameters values, open Ansys, insert the values of the params, solve, annotate output params, write them in the appropriate cells in Excel. At least, up to v.11 I could do copy-paste from the Parameter Manager, now it's not even possible, so the External Connection is my only way to go, but where the hell is it explained? The Ansys Help is completely criptical about that...
Thanks in advance,
regards
emphasized among the new features of v12.1, there is the "External Connection" capability based upon xml scripts in order to interface "non-Ansys" applications with Workbench.
I'm particularly interested in managing the Parameters of a simulation in Workbench 2 (v.12.1) with Excel, passing the parameters to Excel, manipulating them in several ways and then sending them back to Ansys, and other operations like that. A further goal would be to use a WB simulation "template" as a "solver" for an Excel calculation sheet. At the time present, this "interaction" is done manually: elaborate in Excel, annotate the parameters values, open Ansys, insert the values of the params, solve, annotate output params, write them in the appropriate cells in Excel. At least, up to v.11 I could do copy-paste from the Parameter Manager, now it's not even possible, so the External Connection is my only way to go, but where the hell is it explained? The Ansys Help is completely criptical about that...
Thanks in advance,
regards





RE: "External Connection" Ansys12.1 - Excel for managing parameters ?
There is also the option to use python scripting in de project page.
Regards
RE: "External Connection" Ansys12.1 - Excel for managing parameters ?
Go to ANSYS Help System > Workbench > External Connection User's Guide
RE: "External Connection" Ansys12.1 - Excel for managing parameters ?
1) External Connection User Guide: it's the perfect example of what I call a "cryptical" manual. I'll have to spend much more time on it, of course, or... pay for a course on this subject
2) Python, for sure... would be nice, if I knew anything about this language. And how would Excel accomodate a python script?
Well, thanks to all anyway, I recognize the problem is much more involved than it could seem...
Regards