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
Solved! Go to Solution.
Solved by Pawel.Pulak. Go to Solution.
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
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,
thank you both for your replys,
for some reason i cant get that video to work. am i being stupid?
thanks
Direct link to video: http://screencast.com/t/kfqh59S4s
If not working in one browser try another.
Regards,
Can't find what you're looking for? Ask the community or share your knowledge.