{"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":[],"acf":[],"custom_fields":[{"0":{"_bbp_subscription":["51314","61162","58821"],"_bbp_author_ip":["23.52.43.16"]," _bbp_last_reply_id":["0"]," _bbp_likes_count":["0"],"_btv_view_count":["7243"],"_bbp_topic_status":["unanswered"],"_edit_lock":["1714041819:247038"],"_bbp_status":["publish"],"_bbp_topic_id":["364150"],"_bbp_forum_id":["27791"],"_bbp_engagement":["51314","58821","61162"],"_bbp_voice_count":["3"],"_bbp_reply_count":["8"],"_bbp_last_reply_id":["365029"],"_bbp_last_active_id":["365029"],"_bbp_last_active_time":["2024-05-01 09:29:26"]},"test":"ch-yehtum-de"}],"_links":{"self":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/364150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics"}],"about":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/364150\/revisions"}],"predecessor-version":[{"id":364151,"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/364150\/revisions\/364151"}],"wp:attachment":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/media?parent=364150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}