{"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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Dear Ansys Experts,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\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Ansys Learning Forum | Ansys Innovation Space\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Post processing Ansys WB results \u2013 Writing results to excel sheet | Ansys Learning Forum\" \/>\n\t\t<meta property=\"og:description\" content=\"Dear Ansys Experts,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\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/05\/31-05-2023-1685526431-Result.PNG\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/05\/31-05-2023-1685526431-Result.PNG\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-05-31T09:49:11+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-06-01T07:53:52+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Post processing Ansys WB results \u2013 Writing results to excel sheet | Ansys Learning Forum\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Dear Ansys Experts,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\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/05\/31-05-2023-1685526431-Result.PNG\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/topics\\\/#listItem\",\"name\":\"Topics\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/topics\\\/#listItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/topics\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic-tag\\\/apdl\\\/#listItem\",\"name\":\"apdl\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic-tag\\\/apdl\\\/#listItem\",\"position\":3,\"name\":\"apdl\",\"item\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic-tag\\\/apdl\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\\\/#listItem\",\"name\":\"Post processing Ansys WB results &#8211; Writing results to excel sheet\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/topics\\\/#listItem\",\"name\":\"Topics\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\\\/#listItem\",\"position\":4,\"name\":\"Post processing Ansys WB results &#8211; Writing results to excel sheet\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic-tag\\\/apdl\\\/#listItem\",\"name\":\"apdl\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#organization\",\"name\":\"Ansys Learning Forum\",\"description\":\"Ansys Innovation Space\",\"url\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\\\/#webpage\",\"url\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\\\/\",\"name\":\"Post processing Ansys WB results \\u2013 Writing results to excel sheet | Ansys Learning Forum\",\"description\":\"Dear Ansys Experts,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\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\\\/#breadcrumblist\"},\"datePublished\":\"2023-05-31T09:49:11+00:00\",\"dateModified\":\"2023-06-01T07:53:52+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#website\",\"url\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/\",\"name\":\"Ansys Learning Forum\",\"description\":\"Ansys Innovation Space\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Post processing Ansys WB results \u2013 Writing results to excel sheet | Ansys Learning Forum","description":"Dear Ansys Experts,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","canonical_url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum#listItem","position":1,"name":"Home","item":"https:\/\/innovationspace.ansys.com\/forum","nextItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/topics\/#listItem","name":"Topics"}},{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/topics\/#listItem","position":2,"name":"Topics","item":"https:\/\/innovationspace.ansys.com\/forum\/topics\/","nextItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic-tag\/apdl\/#listItem","name":"apdl"},"previousItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic-tag\/apdl\/#listItem","position":3,"name":"apdl","item":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic-tag\/apdl\/","nextItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/#listItem","name":"Post processing Ansys WB results &#8211; Writing results to excel sheet"},"previousItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/topics\/#listItem","name":"Topics"}},{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/#listItem","position":4,"name":"Post processing Ansys WB results &#8211; Writing results to excel sheet","previousItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic-tag\/apdl\/#listItem","name":"apdl"}}]},{"@type":"Organization","@id":"https:\/\/innovationspace.ansys.com\/forum\/#organization","name":"Ansys Learning Forum","description":"Ansys Innovation Space","url":"https:\/\/innovationspace.ansys.com\/forum\/"},{"@type":"WebPage","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/#webpage","url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/","name":"Post processing Ansys WB results \u2013 Writing results to excel sheet | Ansys Learning Forum","description":"Dear Ansys Experts,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","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/innovationspace.ansys.com\/forum\/#website"},"breadcrumb":{"@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/#breadcrumblist"},"datePublished":"2023-05-31T09:49:11+00:00","dateModified":"2023-06-01T07:53:52+00:00"},{"@type":"WebSite","@id":"https:\/\/innovationspace.ansys.com\/forum\/#website","url":"https:\/\/innovationspace.ansys.com\/forum\/","name":"Ansys Learning Forum","description":"Ansys Innovation Space","inLanguage":"en-US","publisher":{"@id":"https:\/\/innovationspace.ansys.com\/forum\/#organization"}}]},"og:locale":"en_US","og:site_name":"Ansys Learning Forum | Ansys Innovation Space","og:type":"article","og:title":"Post processing Ansys WB results \u2013 Writing results to excel sheet | Ansys Learning Forum","og:description":"Dear Ansys Experts,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","og:url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/","og:image":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/05\/31-05-2023-1685526431-Result.PNG","og:image:secure_url":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/05\/31-05-2023-1685526431-Result.PNG","article:published_time":"2023-05-31T09:49:11+00:00","article:modified_time":"2023-06-01T07:53:52+00:00","twitter:card":"summary_large_image","twitter:title":"Post processing Ansys WB results \u2013 Writing results to excel sheet | Ansys Learning Forum","twitter:description":"Dear Ansys Experts,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","twitter:image":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/05\/31-05-2023-1685526431-Result.PNG"},"aioseo_meta_data":{"post_id":"286497","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"content","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":true,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2024-10-28 18:06:19","updated":"2024-10-28 18:06:19","ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/innovationspace.ansys.com\/forum\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/innovationspace.ansys.com\/forum\/topics\/\" title=\"Topics\">Topics<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic-tag\/apdl\/\" title=\"apdl\">apdl<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPost processing Ansys WB results \u2013 Writing results to excel sheet\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/innovationspace.ansys.com\/forum"},{"label":"Topics","link":"https:\/\/innovationspace.ansys.com\/forum\/topics\/"},{"label":"apdl","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic-tag\/apdl\/"},{"label":"Post processing Ansys WB results &#8211; Writing results to excel sheet","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/post-processing-ansys-wb-results-writing-results-to-excel-sheet\/"}],"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":["4272"],"_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}]}}