{"id":364150,"date":"2024-04-25T10:42:58","date_gmt":"2024-04-25T10:42:58","guid":{"rendered":"\/forum\/forums\/topic\/how-to-automatically-export-csv-or-xls-after-solving-each-design-point\/"},"modified":"2024-05-01T09:30:30","modified_gmt":"2024-05-01T09:30:30","slug":"how-to-automatically-export-csv-or-xls-after-solving-each-design-point","status":"closed","type":"topic","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/how-to-automatically-export-csv-or-xls-after-solving-each-design-point\/","title":{"rendered":"How to automatically export .csv or .xls after solving each design point?"},"content":{"rendered":"

I have a static structural analysis in Workbench, and I would like Ansys Mechanical to automatically export the tabular data after solving a design point. Does anybody know how to do this?<\/p>\n

 <\/p>\n

Problem description:<\/p>\n

Currently, for every design point, I have to right click “set as current”, and wait for opening Mechanical, export the data manually, wait for closing Mechanical, which is quite time-consuming and laborious. It usually takes 1 munites to open or close the Mechanical. Here is how I manually export the .xls file now:<\/p>\n

<\/a><\/p>\n

Attempts:<\/p>\n

I have tried to put some Python code in “Python Code” under solution, and successfully export a blank csv file after solution. However, I couldn’t find an API to retrieve the result data to put in my csv and I don’t know if this way is the right way.<\/p>\n

<\/a><\/p>\n

I am using Workbench 2022 R1 Enterprise.<\/p>\n

Thank you in advance!<\/p>\n","protected":false},"template":"","class_list":["post-364150","topic","type-topic","status-closed","hentry","topic-tag-ansysworkbench-ansys-staticstructural","topic-tag-automationACT-1","topic-tag-python-ironpython-1","topic-tag-mechanical"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t