• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Autodesk Robot Structural Analysis

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

    Export results ARSA via API

    605 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
    Posts: 2,519
    Registered: ‎04-26-2010

    Re: Export results ARSA

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

    Upload the mentioned movie



    Rafal Gaweda
    Product Support
    Autodesk, Inc.
    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: RG_Adsk

    It's on the link

    Please use plain text.
    Product Support
    Posts: 2,519
    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
    Product Support
    Autodesk, Inc.
    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: RG_Adsk

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

    Please use plain text.
    Product Support
    Posts: 2,519
    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
    Product Support
    Autodesk, Inc.
    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: RG_Adsk

    Hi,

     

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

    Please use plain text.
    Product Support
    Posts: 2,519
    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
    Product Support
    Autodesk, Inc.
    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: RG_Adsk

    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
    Posts: 2,519
    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
    Product Support
    Autodesk, Inc.
    Please use plain text.