Autodesk Robot Structural Analysis
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Import Nodes from a Spreadshee t??
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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.
Re: Import Nodes from a Spreadshee t??
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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
Re: Import Nodes from a Spreadshee t??
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
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
Support Specialist
Product Support
Autodesk, Inc.
Re: Import Nodes from a Spreadshee t??
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
thank you both for your replys,
for some reason i cant get that video to work. am i being stupid?
thanks
Re: Import Nodes from a Spreadshee t??
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Direct link to video: http://screencast.com/t/kfqh59S4s
If not working in one browser try another.
Regards,

Pawel Pulak
Support Specialist
Product Support
Autodesk, Inc.
Re: Import Nodes from a Spreadshee t??
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
thank you!!
