Discussion Groups

Robot Structural Analysis

Reply
Valued Contributor
AndyWalker
Posts: 72
Registered: ‎12-01-2008
Accepted Solution

Import Nodes from a Spreadsheet??

165 Views, 5 Replies
09-11-2012 06:55 AM

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

Please use plain text.
Active Contributor
rsousa_
Posts: 35
Registered: ‎05-23-2012

Re: Import Nodes from a Spreadsheet??

09-11-2012 07:12 AM 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

Please use plain text.
Product Support
pp2008
Posts: 492
Registered: ‎06-23-2008

Re: Import Nodes from a Spreadsheet??

09-11-2012 07:13 AM 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
Please use plain text.
Valued Contributor
AndyWalker
Posts: 72
Registered: ‎12-01-2008

Re: Import Nodes from a Spreadsheet??

09-11-2012 07:34 AM in reply to: pp2008

thank you both for your replys,

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

 

thanks

Please use plain text.
Product Support
pp2008
Posts: 492
Registered: ‎06-23-2008

Re: Import Nodes from a Spreadsheet??

09-11-2012 07:37 AM in reply to: AndyWalker

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

 

If not working in one browser try another.

 

Regards,

 



Pawel Pulak
Please use plain text.
Valued Contributor
AndyWalker
Posts: 72
Registered: ‎12-01-2008

Re: Import Nodes from a Spreadsheet??

09-11-2012 07:38 AM in reply to: pp2008

thank you!!

Please use plain text.