• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk Robot Structural Analysis

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

    Import Nodes from a Spreadsheet??

    93 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.
    Contributor
    Posts: 18
    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
    Posts: 345
    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
    Support Specialist
    Product Support
    Autodesk, Inc.

    Please use plain text.
    Valued Contributor
    Posts: 62
    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
    Posts: 345
    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
    Support Specialist
    Product Support
    Autodesk, Inc.

    Please use plain text.
    Valued Contributor
    Posts: 62
    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.