{"id":286497,"date":"2023-05-31T09:49:11","date_gmt":"2023-05-31T09:49:11","guid":{"rendered":"\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/"},"modified":"2023-06-01T07:53:52","modified_gmt":"2023-06-01T07:53:52","slug":"post-processing-ansys-wb-results-writing-results-to-excel-sheet","status":"closed","type":"topic","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/","title":{"rendered":"Post processing Ansys WB results &#8211; Writing results to excel sheet"},"content":{"rendered":"<p>Dear Ansys Experts,<\/p>\n<p>An equivalent stress results from Ansys Workbench (2023 R1 version) is written to an excel (.csv) using APDL commands as shown below. In doing so, the excel file holds the data in a single column separated by a comma (,). Is it possible to get the data separated into 4 different columns in the .csv file without any manual intervention?&nbsp;<\/p>\n<p>APDL command snippet used to write the results from an array MARRAY to an excel file named Results_VerticalPath_SX: where column 1 (X-coordinate), column 2 (Y-coordinate), column 3 (Z-coordinate) and column 4 (Equivalent stress)<\/p>\n<p><span style=\"font-size: 12pt\">*CFOPEN, Results_VerticalPath_SX,csv<\/span><br \/><span style=\"font-size: 12pt\">*VWRITE, MARRAY(1,1), MARRAY(1,2,), MARRAY(1,3), MARRAY(1,4)<\/span><br \/><span style=\"font-size: 12pt\">%i, %g, %g, %g<\/span><br \/><span style=\"font-size: 12pt\">*CFCLOS<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"\/forum\/wp-content\/uploads\/sites\/2\/2023\/05\/31-05-2023-1685526431-Result.PNG\" alt=\"\"><\/p>\n<p>Let me know in case of any additinal information. Thanks in advance.<\/p>\n<p>Regards,<\/p>\n<p>Shravani<\/p>\n","protected":false},"template":"","class_list":["post-286497","topic","type-topic","status-closed","hentry","topic-tag-ansysworkbench-ansys-staticstructural","topic-tag-apdl","topic-tag-excel-csv"],"aioseo_notices":[],"acf":[],"custom_fields":[{"0":{"_bbp_subscription":["128670","58821","11091"],"_bbp_author_ip":["23.47.145.29"]," _bbp_last_reply_id":["0"]," _bbp_likes_count":["0"],"_btv_view_count":["3886"],"_bbp_status":["publish"],"_bbp_topic_status":["unanswered"],"_bbp_topic_id":["286497"],"_bbp_forum_id":["27791"],"_bbp_engagement":["11091","58821","128670"],"_bbp_voice_count":["3"],"_bbp_reply_count":["8"],"_bbp_last_reply_id":["286666"],"_bbp_last_active_id":["286666"],"_bbp_last_active_time":["2023-06-01 07:53:22"]},"test":"shravani-bojjasaueressig-com"}],"_links":{"self":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/286497","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":0,"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/286497\/revisions"}],"wp:attachment":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/media?parent=286497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}