topic Re: (API) Extraction of Automatic Generated Loads into Excel in Robot Structural Analysis Forum

(API) Extraction of Automatic Generated Loads into Excel

esdraspo — Thu, 07 Aug 2025 02:21:17 GMT

Hello everyone. I read the post "(API) Load Extraction for Excel" and it actually solved the proposed problem. However, I would like your help in improving the API developed to also obtain the loads automatically generated by the program; for example, the wind loads applied to the cladding and transferred to the bars.

Through the program interface, I can partially generate tables with this information. I say partially because the automatically generated trapezoidal loads only show the maximum load value. They do not indicate the minimum value, nor where the load begins and ends along the bar.

I created a small model to illustrate this. This can be verified, for example, by consulting the automatically generated loads for load case 3, bar 10, in the load table.

Re: (API) Extraction of Automatic Generated Loads into Excel

Stephane.kapetanovic — Thu, 07 Aug 2025 10:11:10 GMT

hi @esdraspo

The automatically generated loads are not fully accessible, although they are visible through the API. Therefore, the Excel program in this topic ignores these loads. To make them visible, you need to slightly modify the program by disabling these lines :

line 49

line 183

Then, you will need to add or adjust the load types applied to the bars (uniform, point, trapezoidal over multiple points, etc.) in order to capture those applied to bar 10.

Besr Regards

Re: (API) Extraction of Automatic Generated Loads into Excel

mannyorton101 — Thu, 07 Aug 2025 09:08:41 GMT

Hi everyone, I found the post "(API) Load Extraction for Excel" really helpful and it solved the main issue I was facing. However, I still need some help to improve the API so that it can also extract loads that are automatically generated by the program, like wind loads applied to cladding and then transferred to the bars. When I try to get this information through the program interface, it only gives me part of the data. For example, for trapezoidal loads, it only shows the maximum load value but doesn’t include the minimum value or the exact points along the bar where the load starts and ends. To make this clearer, I created a small model to test it. You can see what I mean by checking the automatically generated loads for load case 3, bar 10, in the load table. I’ve been in a similar situation while working on transport automation for FIFO airport transfers Perth, and making sure you pull complete and accurate data can really save time when scaling operations.

Re: (API) Extraction of Automatic Generated Loads into Excel

Stephane.kapetanovic — Sat, 23 Aug 2025 13:24:13 GMT

hi @mannyorton101

as explained to @esdraspo you must modify the existing program done by @Rafal.Gaweda. for traêzoidal loads you can refer to this topic (here)

The programs are provided as examples to demonstrate knowledge and good practices, but they are not specifically tailored for direct application in a particular use case.

Best Regards