Discussion Groups

Robot Structural Analysis

Reply
Distinguished Contributor
120 Posts
0 Kudos
Registered: ‎10-10-2011
Accepted Solution

Export results ARSA via API

902 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

Product Support
5,710 Posts
1,303 Kudos
Registered: ‎04-26-2010

Re: Export results ARSA

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

Upload the mentioned movie



Rafal Gaweda
Distinguished Contributor
120 Posts
0 Kudos
Registered: ‎10-10-2011

Re: Export results ARSA

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

It's on the link

Product Support
5,710 Posts
1,303 Kudos
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
Distinguished Contributor
120 Posts
0 Kudos
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 ?

Product Support
5,710 Posts
1,303 Kudos
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
Distinguished Contributor
120 Posts
0 Kudos
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 ?

Product Support
5,710 Posts
1,303 Kudos
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
Distinguished Contributor
120 Posts
0 Kudos
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

Product Support
5,710 Posts
1,303 Kudos
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