Announcements

Starting in December, we will archive content from the community that is 10 years and older. This FAQ provides more information.

API for Exporting Reactions to Excel

Anonymous

API for Exporting Reactions to Excel

Anonymous
Not applicable

 As there's no implicit option in Robot to export reactions to Microsoft Excel (.xlsx format), only (.csv) format
this addin will export reactions to Excel

 

see the file in attachments.1.PNG

Reply
Accepted solutions (1)
4,260 Views
8 Replies
Replies (8)

StefanoPasquini6790
Advisor
Advisor
Very useful and friendly.

Great job, thank you

PasProStudio

www.pasquiniprogetti.eu

Structural + Detailing engineers
0 Likes

Rafal.Gaweda
Autodesk Support
Autodesk Support
Nice.
Added to our list


Rafal Gaweda
0 Likes

StefanoPasquini6790
Advisor
Advisor

Hi everyone,

 

there is some issue in the API. 

 

the columns of table don't show the correct value, to a little test it happen that in FX column I have "CQC" and all the values shift in the next column. To have a clearest focus on this topic show the image below:

 

reaction.JPG

 

However, this is a very nice tool.

 

Greetings


PasProStudio

www.pasquiniprogetti.eu

Structural + Detailing engineers

Anonymous
Not applicable

Thanks for the feedback.

a small change to fix such a problem (the name of the load combination contains "/" in it, please tell me if the problem still exists.

Rafal.Gaweda
Autodesk Support
Autodesk Support

Small macro doing that ,attached

(if it is not properly open in Excel, open VBA editor and play with changing separators characters, relevant code marked in macro)



Rafal Gaweda

AhmedZA
Advocate
Advocate
this is a very useful tool

thanks Mohammed
0 Likes

Mohammed_Ata
Collaborator
Collaborator

Dear, all

 

First of all, great thanks for efforts. 

 

How can i select one case and export its reactions to excel only ? The default is to export all cases! 

 

Regards,

0 Likes

Anonymous
Not applicable
Accepted solution