Export / import reactions table to Excel

[Konrad.O]

A copy of the archived "Export / import reactions table to Excel" topic:

http://forums.autodesk.com/t5/robot-structural-analysis/api-for-exporting-reactions-to-excel/td-p/53... 

[Anonymous]

 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.

[StefanoPasquini6790]

Very useful and friendly.

Great job, thank you

[Rafal.Gaweda]

Nice.
Added to our list

[StefanoPasquini6790]

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:

However, this is a very nice tool.

Greetings

[Anonymous]

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]

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)

[AhmedZA]

this is a very useful tool

thanks Mohammed

[Mohammed_Ata]

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,

[Anonymous]

Please see the modified version https://forums.autodesk.com/t5/robot-structural-analysis-forum/addin-for-exporting-reactions-to-exce...