CST - Access CSTResultReader.dll from EXCEL VBA

  • Thread starter Thread starter katto01
  • Start date Start date
  • Tags Tags
    Excel
Click For Summary
SUMMARY

The discussion focuses on accessing CSTResultReader.dll from Excel VBA to retrieve e-field values and insert them into an Excel sheet. Users noted the absence of direct examples for Excel VBA in the CST documentation, although examples in C# and Visual Basic .NET are available. A suggested workaround includes saving CST project results as an ASCII file for easier data import into Excel. This approach allows users to effectively manage and analyze CST simulation results within Excel.

PREREQUISITES
  • Familiarity with Excel VBA programming
  • Understanding of CST Studio Suite and its output formats
  • Basic knowledge of using DLLs in programming
  • Experience with data import techniques in Excel
NEXT STEPS
  • Explore examples of CSTResultReader.dll usage in C# and Visual Basic .NET
  • Learn how to save CST simulation results as ASCII files
  • Research Excel VBA array manipulation techniques
  • Investigate advanced data import methods in Excel for better performance
USEFUL FOR

This discussion is beneficial for Excel VBA developers, CST users looking to automate data extraction, and anyone interested in integrating CST simulation results into Excel for analysis and reporting.

katto01
Messages
2
Reaction score
0
Hello,

I am trying to control CST from Excel VBA. For instance, I would like to create a routine in Excel VBA similar to the postprocessing template “Evaluate Field in arbitrary coordinates” into Excel VBA, i.e. get the e-field values into an array and insert them on an excel sheet.
I read the topic “CSTResultReader.dll” in the help but saw no example for Excel VBA. I am not a professional programmer, so I would need an example I could use to write my routine.
Please advise
Thank you

PS. Any suggestion on a different way that I could use to get the data from the CST project results into excel would be welcome.
 
Physics news on Phys.org
</code>Unfortunately, CST does not currently provide an example of using the CSTResultReader.dll in Excel VBA. However, you can find some examples of how to use the dll in other programming languages, such as C# and Visual Basic .NET, on our website: https://www.cst.com/content/cst/en/support/solutions/tutorials/fieldresultsreader.html. You may be able to use the examples provided to create your own routine in Excel VBA. Alternatively, you can save your results as an ASCII file and then read the data into Excel from there.
 

Similar threads

  • · Replies 2 ·
Replies
2
Views
9K
  • · Replies 6 ·
Replies
6
Views
55K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 18 ·
Replies
18
Views
6K
  • · Replies 10 ·
Replies
10
Views
2K
  • · Replies 41 ·
2
Replies
41
Views
6K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 19 ·
Replies
19
Views
5K
  • · Replies 1 ·
Replies
1
Views
696