Get forces from Robot to Excel with C#

[Anonymous]

Hello everyone,
Can I get forces from Robot and write down to Excel by C# ?
I would not want to do it with VBA.

I would appreciate all tips in C#

[Rafal.Gaweda]

Hi @Anonymous 

Yes, you can.

[Anonymous]

Could You give me some help how to do it ? It's my first program in Robot.
I would like to get all Fx forces in bars. How can I find all bars on the model ? How can I get values of forces and forces coordinates ? 
Thank You for Your help 🙂

[Rafal.Gaweda]

Hi @Anonymous 

I would suggest starting from here:

https://forums.autodesk.com/t5/robot-structural-analysis-forum/useful-addins-for-robot-api/td-p/3899448

[Anonymous]

I managed to get forces and load cases from Robot but I have some problem with nodes.
I would like to get StartNode and EndNode of every bar but I obtain some different nodes that I don't want to get.
My code:
 

RobotSelection SelectionBars = robApp.Project.Structure.Selections.CreateFull(IRobotObjectType.I_OT_BAR);
IRobotCollection CollectionBars = (IRobotCollection)robApp.Project.Structure.Bars.GetMany(SelectionBars);

IRobotCollection NodeCol = (IRobotCollection)robApp.Project.Structure.Nodes.GetMany(SelectionBars);
RobotNode rNode;
for (int i = 1; i < NodeCol.Count; i++)
{
rNode = NodeCol.Get(i);
Console.WriteLine("rNode X: " + rNode.X);
Console.WriteLine("rNode Y: " + rNode.Y);
Console.WriteLine("rNode Z: " + rNode.Z);

}

I've tried to get StartNode and EndNode for every bar but I can't find a way how to do it.

[Rafal.Gaweda]

Hi

Node Collection should be created from Node Selection , not Bar Selection.

[Anonymous]

Thank You Rafal but I still haven't solved my problem. I would like to get nodes only for Objects of a model "Bars" but this way I get nodes for Objects of a model "Nodes". Not all nodes from "Nodes" are bars nodes.

Is there a way to get StartNode and EndNode only for bars?

[Rafal.Gaweda]

Hi @Anonymous 

You have to get them from bars loop.

Nothing automatic.