Robot Structural Analysis Forum
Welcome to Autodesk’s Robot Structural Analysis Forums. Share your knowledge, ask questions, and explore popular Robot Structural Analysis topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Import Nodes from a Spreadsheet??

5 REPLIES 5
SOLVED
Reply
Message 1 of 6
AndyWalker
944 Views, 5 Replies

Import Nodes from a Spreadsheet??

Hello Everyone i hope you can help.

I was wondering is it possible (and if so how) to import nodes from a spreadsheet?
I have a spreadsheet with all the node coordinates and was hoping to use this to construct a steel frame.

Any help would be most gratefully recieved!

thanks
ANdy

5 REPLIES 5
Message 2 of 6
rsousa_
in reply to: AndyWalker

You should see this example_:

 

http://www.robobat.fr/n/ros/662/

 

The code should be like this (if you have a list of node coordinates in column A, B and C)


Dim Robot As Object
Set Robot = CreateObject("Robot.Application")

Dim nods As Object
' --- create nodes
Set nods = Robot.Project.Structure.Nodes
For i = 1 To n + 1
  nods.Create i, cells(i,1), cells(i,2), cells(i,3)
Next i
Set Robot = Nothing
End Sub


Hope this can help you!

Regards

Message 3 of 6
Pawel.Pulak
in reply to: AndyWalker

The simplest way is to use Copy&Paste on Edit tab of the table of nodes. As in this video.

 

---------------------------------------------
If this post answers your question please click "Accept as Solution". It will help everyone to find answer more quickly!

 

Regards,


Pawel Pulak
Technical Account Specialist
Message 4 of 6
AndyWalker
in reply to: Pawel.Pulak

thank you both for your replys,

for some reason i cant get that video to work. am i being stupid?

 

thanks

Message 5 of 6
Pawel.Pulak
in reply to: AndyWalker

Direct link to video: http://screencast.com/t/kfqh59S4s

 

If not working in one browser try another.

 

Regards,

 


Pawel Pulak
Technical Account Specialist
Message 6 of 6
AndyWalker
in reply to: Pawel.Pulak

thank you!!

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report