Discussion Groups

Robot Structural Analysis

Reply
Distinguished Contributor
mateaus
Posts: 117
Registered: ‎10-10-2011
Accepted Solution

Export results ARSA via API

831 Views, 41 Replies
01-16-2012 07:27 AM

Hi,

 

I would like to export the results of efforts with VBA in excel files like in the video attached.

 

Can you help me ?

 

Export result

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 4,978
Registered: ‎04-26-2010

Re: Export results ARSA

01-16-2012 08:01 AM in reply to: mateaus

Upload the mentioned movie



Rafal Gaweda
Please use plain text.
Distinguished Contributor
mateaus
Posts: 117
Registered: ‎10-10-2011

Re: Export results ARSA

01-17-2012 12:36 AM in reply to: Rafal.Gaweda

It's on the link

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 4,978
Registered: ‎04-26-2010

Re: Export results ARSA

01-17-2012 01:23 AM in reply to: mateaus

Thanks.

Not possible to save csv from table by API. So you have to import these results to Excel then save xls file(s).



Rafal Gaweda
Please use plain text.
Distinguished Contributor
mateaus
Posts: 117
Registered: ‎10-10-2011

Re: Export results ARSA

01-17-2012 02:03 AM in reply to: Rafal.Gaweda

Ok, but is there a way to export results by API ?

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 4,978
Registered: ‎04-26-2010

Re: Export results ARSA

01-17-2012 02:19 AM in reply to: mateaus

Ok, but is there a way to export results by API ?


Yes, of course.

I will write you sample code.



Rafal Gaweda
Please use plain text.
Distinguished Contributor
mateaus
Posts: 117
Registered: ‎10-10-2011

Re: Export results ARSA

01-17-2012 10:24 AM in reply to: Rafal.Gaweda

Hi,

 

Could you send me an example to have list of efforts (Fx Fz My) with API VBA ?

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 4,978
Registered: ‎04-26-2010

Re: Export results ARSA

01-18-2012 05:31 AM in reply to: mateaus

xls file with example of table with internal forces attached.



Rafal Gaweda
Please use plain text.
Distinguished Contributor
mateaus
Posts: 117
Registered: ‎10-10-2011

Re: Export results ARSA

01-18-2012 06:27 AM in reply to: Rafal.Gaweda

Ok thank you,

 

I try it and it works but we have to select the bars before in the model. I will search by myself how to make it automaticaly and if I don't succeed I'll ask you one more time.

 

Just an Question. It's slow, do I need a lot of RAM to turn it faster ?

 

My System :

 

Windows XP Professionnel 2002 SP3

Intel(R) Xeon(R) CPU

W3505 @ 2.53GHz

2.53 GHz, 2.99 Go de RAM

 

Carte Graphique :

 

NVIDIA Quadro FX 580

Please use plain text.
Product Support
Rafal.Gaweda
Posts: 4,978
Registered: ‎04-26-2010

Re: Export results ARSA

01-18-2012 07:10 AM in reply to: mateaus

 

 I will search by myself how to make it automaticaly 

 

What do you mean by that ? 

 

Just an Question. It's slow, do I need a lot of RAM to turn it faster ?

 

No, it does not depend on RAM.

I will check the code to accelerate it - if possible.



Rafal Gaweda
Please use plain text.