Jump to content
gjeffrey

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

Recommended Posts

gjeffrey

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.

Share this post


Link to post
Share on other sites
gjeffrey

i am using AutoCAD 2017 for Mac and not AutoCAD 2016

Share this post


Link to post
Share on other sites
BIGAL

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/showthread.php?101914-Adding-Multiple-Numbers-to-Drawing-without-typing-them-in

Share this post


Link to post
Share on other sites
gjeffrey

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.

Share this post


Link to post
Share on other sites
gjeffrey

i updated to autocad 2018 from 2017. i can no longer copy and paste more than 1 excel spreadsheet x,y,z data point into the spline function at a time. before i updated to 2018, i could copy and paste ~20 x,y,z points at a time. does someone have any thoughts on why i can only copy and paste 1 x,y,z point at a time into the spline function after my updating of autocad 2018.

Share this post


Link to post
Share on other sites
BIGAL

Is the 1st paste working fully, sounds like its getting stuck expecting more, press esc a couple of times before next paste. You could join 20 splines into one column or paste to notepad or mac equivalent, you just need 1 blank line between each spline start, the blank line is like press enter to end command. Then save as a script file .scr, use script to run.

Share this post


Link to post
Share on other sites
gjeffrey

just a reminder i'm now using autocad 2018 for Mac of which i upgraded from autocad 2017 for mac.

 

when i 'command-v' to paste the column of x,y,z points it only puts the second to the last x,y,z point on the stack of last commands and the last x,y,z point on the command line. when i hit 'enter' it gives me an 'unknown' command error. as in my previous posts, after your help, i was able to copy and paste around 20 x,y,z points with which all the points where listed in the command line stack. when i was finished i just hit enter to close.

Share this post


Link to post
Share on other sites
gjeffrey

the last post may have appeared to state i can now copy more than one x,y,z point into the spline function at a time.

 

it still doesn't copy any more points after i tried your post BIGA on march 31st.

Share this post


Link to post
Share on other sites
BIGAL

Just did a check https://www.autodesk.com/shortcuts/autocad-for-mac#S-U

 

And script is supported so as I suggested make a script file with multiple spline entry's you should just need 1 blank line bewteen for them to work.

 

line
0,0
1,0
1,1
0,1
c

line
10,10
20,10
20,20
10,20
c

line 
...........

Share this post


Link to post
Share on other sites
gjeffrey

copying and pasting into AutoCad for Mac from Excel for the Mac does not work. in order for you to copy and paste excel data points into AutoCad for a Mac, you need to copy and paste the excel data points into 'numbers' for the Mac.

 

then, you can copy and paste data from 'numbers' into AutoCad for the Mac.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×