+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Forum Newbie
    Using
    AutoCAD 2016
    Join Date
    Oct 2017
    Posts
    3

    Question importing excel spreadsheet x,y,z points into the spline function

    Registered forum members do not see this ad.

    i'm trying to learn how to import x,y,z points in excel into a spline function in order to not have to manually type the individual x,y,z point for 100's of x,y,z points in excel. i have been unable to find a meaningful and helpful solution so far in any of the forums thus far. any explains of this i found are vague and don't work.

  2. #2
    Forum Newbie
    Using
    AutoCAD 2016
    Join Date
    Oct 2017
    Posts
    3

    Default

    i am using AutoCAD 2017 for Mac and not AutoCAD 2016

  3. #3
    Super Moderator SLW210's Avatar
    Computer Details
    SLW210's Computer Details
    Operating System:
    Windows 7 PRO 64-bit
    Computer:
    IBM Lenovo
    Motherboard:
    ACPI x64
    CPU:
    Pentium(R) i5 4570 @ 3.2GHz
    RAM:
    8 GB RAM
    Graphics:
    Nvidia Quadro 600 1GB
    Primary Storage:
    300 GB
    Secondary Storage:
    650GB
    Monitor:
    2x ThinkVision 24"
    Discipline
    Multi-disciplinary
    SLW210's Discipline Details
    Occupation
    Design Draftsman
    Discipline
    Multi-disciplinary
    Details
    Mostly do drafting related to manufacturing. From doing site layouts with proposed updates, additions and renovations to be budgeted and submitted for bid, to updating and changing existing drawings to reflect maintenance and repair/revision work done on site.
    Using
    AutoCAD 2011
    Join Date
    May 2007
    Location
    South Florida, USA
    Posts
    11,798

    Default

    I have moved your thread to the AutoCAD 3D Modelling & Rendering Forum.
    “A narrow mind and a fat head invariably come on the same person” Zig Zigler



  4. #4
    Luminous Being
    Using
    Civil 3D 2016
    Join Date
    Dec 2005
    Location
    GEELONG AUSTRALIA
    Posts
    9,821

    Default

    It should be easy using the concatenate function in excel, I would expect you have X Y Z in seperate columns so you would type SPLINE in say D1, D2 would have =concatenate(a2,",",b2,",",c2) which would display x,y,z copy this down for all points, then just copy the D column to the Autocad command line.

    Scroll down in this post its near the bottom a screen grab example, http://www.cadtutor.net/forum/showth...typing-them-in
    A man who never made mistakes never made anything

  5. #5
    Forum Newbie
    Using
    AutoCAD 2016
    Join Date
    Oct 2017
    Posts
    3

    Default

    Registered forum members do not see this ad.

    thanks BIGAL!

    i can now copy and paste x,y,z points into the AutoCAD spline function. it works better with the 'control vertices' than the 'fit points' option. it worked well with up to ~20 x,y,z points when i was pasting them into the spline drawing function.

    for those who are Mac users, it is 'command-v' for pasting and not the Windows 'control-v' used in the examples on the forum. that was the main problem i had in getting the copy and paste of x,y,z data points into the drawing function to work.

Similar Threads

  1. Inserting Excel spreadsheet
    By Franny in forum AutoCAD Beginners' Area
    Replies: 3
    Last Post: 23rd May 2017, 03:28 pm
  2. Importing Excel spreadsheet in autocad 2010
    By caby33 in forum AutoCAD Drawing Management & Output
    Replies: 0
    Last Post: 23rd Aug 2011, 02:51 pm
  3. Control points of spline to excel
    By karayelh in forum AutoCAD General
    Replies: 0
    Last Post: 14th Oct 2007, 07:05 am
  4. Importing Excel Spreadsheet
    By CADken in forum AutoCAD Drawing Management & Output
    Replies: 4
    Last Post: 7th Jun 2007, 07:52 pm

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts