


{"id":310950,"date":"2023-10-10T23:51:29","date_gmt":"2023-10-10T23:51:29","guid":{"rendered":"\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/"},"modified":"2023-10-10T23:51:29","modified_gmt":"2023-10-10T23:51:29","slug":"extraction-of-linearized-stress-worksheet-results-via-python-script","status":"closed","type":"topic","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/","title":{"rendered":"Extraction of Linearized Stress Worksheet Results via Python Script"},"content":{"rendered":"<p>I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.<br \/>What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that are part of my structure.<br \/>I wanted to automate the process and obtain the spreadsheets for these Worksheets. I have come across the following Python script (found in https:\/\/blog.ozeninc.com\/resources\/using-python-to-export-tabular-data-from-within-ansys-mechanical) that works to automate this process but to export Tabular Data, not Worksheet.<\/p>\n<p><img decoding=\"async\" src=\"\/forum\/wp-content\/uploads\/sites\/2\/2023\/10\/10-10-2023-1696981860-mceclip0.png\"><\/p>\n<p>I tried changing the &#8220;TabularData&#8221; to &#8220;Worksheet&#8221; in the Pane variable but I couldn&#8217;t get the code to work in any way. How would I extract the Worksheets via python scripting in Ansys Workbench?<\/p>\n","protected":false},"template":"","class_list":["post-310950","topic","type-topic","status-closed","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/\" \/>\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=\"Extraction of Linearized Stress Worksheet Results via Python Script | Ansys Learning Forum\" \/>\n\t\t<meta property=\"og:description\" content=\"I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/10\/10-10-2023-1696981860-mceclip0.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/10\/10-10-2023-1696981860-mceclip0.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-10-10T23:51:29+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-10-10T23:51:29+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Extraction of Linearized Stress Worksheet Results via Python Script | Ansys Learning Forum\" \/>\n\t\t<meta name=\"twitter:description\" content=\"I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/10\/10-10-2023-1696981860-mceclip0.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\\\/extraction-of-linearized-stress-worksheet-results-via-python-script\\\/#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\\\/extraction-of-linearized-stress-worksheet-results-via-python-script\\\/#listItem\",\"name\":\"Extraction of Linearized Stress Worksheet Results via Python Script\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/extraction-of-linearized-stress-worksheet-results-via-python-script\\\/#listItem\",\"position\":3,\"name\":\"Extraction of Linearized Stress Worksheet Results via Python Script\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/topics\\\/#listItem\",\"name\":\"Topics\"}}]},{\"@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\\\/extraction-of-linearized-stress-worksheet-results-via-python-script\\\/#webpage\",\"url\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/extraction-of-linearized-stress-worksheet-results-via-python-script\\\/\",\"name\":\"Extraction of Linearized Stress Worksheet Results via Python Script | Ansys Learning Forum\",\"description\":\"I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/innovationspace.ansys.com\\\/forum\\\/forums\\\/topic\\\/extraction-of-linearized-stress-worksheet-results-via-python-script\\\/#breadcrumblist\"},\"datePublished\":\"2023-10-10T23:51:29+00:00\",\"dateModified\":\"2023-10-10T23:51:29+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":"Extraction of Linearized Stress Worksheet Results via Python Script | Ansys Learning Forum","description":"I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that","canonical_url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/#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\/extraction-of-linearized-stress-worksheet-results-via-python-script\/#listItem","name":"Extraction of Linearized Stress Worksheet Results via Python Script"},"previousItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/#listItem","position":3,"name":"Extraction of Linearized Stress Worksheet Results via Python Script","previousItem":{"@type":"ListItem","@id":"https:\/\/innovationspace.ansys.com\/forum\/topics\/#listItem","name":"Topics"}}]},{"@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\/extraction-of-linearized-stress-worksheet-results-via-python-script\/#webpage","url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/","name":"Extraction of Linearized Stress Worksheet Results via Python Script | Ansys Learning Forum","description":"I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/innovationspace.ansys.com\/forum\/#website"},"breadcrumb":{"@id":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/#breadcrumblist"},"datePublished":"2023-10-10T23:51:29+00:00","dateModified":"2023-10-10T23:51:29+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":"Extraction of Linearized Stress Worksheet Results via Python Script | Ansys Learning Forum","og:description":"I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that","og:url":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/","og:image":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/10\/10-10-2023-1696981860-mceclip0.png","og:image:secure_url":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/10\/10-10-2023-1696981860-mceclip0.png","article:published_time":"2023-10-10T23:51:29+00:00","article:modified_time":"2023-10-10T23:51:29+00:00","twitter:card":"summary_large_image","twitter:title":"Extraction of Linearized Stress Worksheet Results via Python Script | Ansys Learning Forum","twitter:description":"I need to extract the normal and shear stresses for a big number of nodes (which I have already selected) in Ansys Workbench 2023 R2.What I have been doing is manually export these stresses, obtained in the Worksheet Vew, since I have been simulating the linearized equivalent stress along the thickness of the plates that","twitter:image":"https:\/\/innovationspace.ansys.com\/forum\/forum\/wp-content\/uploads\/sites\/2\/2023\/10\/10-10-2023-1696981860-mceclip0.png"},"aioseo_meta_data":{"post_id":"310950","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 17:41:13","updated":"2024-10-28 17:41:13","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\tExtraction of Linearized Stress Worksheet Results via Python Script\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":"Extraction of Linearized Stress Worksheet Results via Python Script","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/extraction-of-linearized-stress-worksheet-results-via-python-script\/"}],"acf":[],"custom_fields":[{"0":{"_bbp_subscription":["32913","88","18229"],"_bbp_author_ip":["96.7.218.215"]," _bbp_last_reply_id":["0"]," _bbp_likes_count":["0"],"_btv_view_count":["1001"],"_edit_lock":["1696982160:234453"],"_bbp_topic_status":["unanswered"],"_bbp_status":["publish"],"_bbp_topic_id":["310950"],"_bbp_forum_id":["27791"],"_bbp_engagement":["88","18229","32913"],"_bbp_voice_count":["3"],"_bbp_reply_count":["6"],"_bbp_last_reply_id":["313173"],"_bbp_last_active_id":["313173"],"_bbp_last_active_time":["2023-10-24 22:50:47"]},"test":"gabrielchavesalvesid-uff-br"}],"_links":{"self":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/310950","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\/310950\/revisions"}],"wp:attachment":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/media?parent=310950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}