Automated script result need to import in excel sheet. Is it possible?
I had made a script to perform automated review for Meshing based on defined requirement. If 10 steps are there, when each step performing it popup with PASS or FAIL.
Now am planning to import this pass or Fail data into Excel sheet. Is it possible?
Best Answer
-
Hello @Saravanan R_20730
we already have several tools available in HyperMesh to generate mesh reports. Did you already review them. I'm asking because it is generally better to rely on existing core features, than to re-create from scratch a full process.
That said, to answer your question, tcl offers some modules to interact with Excel, but we used them in the past and found several limitations. So either you use tcl scripting and we recommend in that case to export data from the script to text format, or you have access to a recent version of HyperMesh (2024 or above), then you can start moving to Python automation
Hope that helps,
Best Regards,
Michael
0
Altair EmployeeAnswers
-
Hello @Saravanan R_20730
we already have several tools available in HyperMesh to generate mesh reports. Did you already review them. I'm asking because it is generally better to rely on existing core features, than to re-create from scratch a full process.
That said, to answer your question, tcl offers some modules to interact with Excel, but we used them in the past and found several limitations. So either you use tcl scripting and we recommend in that case to export data from the script to text format, or you have access to a recent version of HyperMesh (2024 or above), then you can start moving to Python automation
Hope that helps,
Best Regards,
Michael
0