dhananjayr567 Posted June 18, 2015 Posted June 18, 2015 Dear Sir, I have a data x. y. z coordinate in *.xls format; want to plot in AutoCad as a point, & then genrate contours. please help how to do it. Regards Dhananjay. Quote
Commandobill Posted June 18, 2015 Posted June 18, 2015 Easiest way would to make a script. Take your excel file and change it to a .csv then change the extension to .scr open it as a text file and change it a little bit so it ends up looking like this: point 0,0,0 point 1,1,1 point 2,2,2 line 0,0,0 1,1,1 2,2,2 Quote
Commandobill Posted June 18, 2015 Posted June 18, 2015 Then of course typing "scr" at the command line and choosing it from your file location. Quote
Commandobill Posted June 18, 2015 Posted June 18, 2015 Also, I never used this, but Lee-Mac has a program for this as well. Here Quote
Lee Mac Posted June 18, 2015 Posted June 18, 2015 Also, I never used this, but Lee-Mac has a program for this as well. Here Thanks for the recommendation CB - the OP will need to save his XLS to a CSV first Quote
BIGAL Posted June 19, 2015 Posted June 19, 2015 (edited) Most important part guys Autocad can not create contours ! There is no option in plain Autocad. You do though have lots of choices, Autocad CIV3D bring in points as csv and then contour, use a 3rd party product, search here using "CONTOURS" pretty sure YMG3 can help with a contour routine. Found it http://www.cadtutor.net/forum/showthread.php?86040-lisp-to-generate-contour-from-xyz&highlight=contours Edited June 20, 2015 by BIGAL Quote
ymg3 Posted June 19, 2015 Posted June 19, 2015 Thank you for the recommendation BIGAL. dhanan, For getting the points Lee's program will do it for csv. Jeffrey Sanders has one for xls file IMPORTXYZ.html For contours, you will need first to triangulate your points, then generate the contours. Here is a link to the last revision of my program:TriangV6.4.0.lsp With it, once your point have been imported on screen, you issue command TIN and a DCL will appear to let you do the triangulation and contours. ymg Quote
smileforrest Posted September 25, 2015 Posted September 25, 2015 When i reach your link ,how can i download your lisp TriangV6.4.0.lsp ? thanks! Quote
Lee Mac Posted September 25, 2015 Posted September 25, 2015 When i reach your link ,how can i download your lisp TriangV6.4.0.lsp ?thanks! You will need membership at The Swamp in order to view & download attachments. Quote
ymg3 Posted September 25, 2015 Posted September 25, 2015 smileforrest, Latest published version would be Triang V0.6.5.1.lsp at TheSwamp. This version has depression contour processing added. As Lee stated, you need to register there in order to download. ymg Quote
smileforrest Posted September 26, 2015 Posted September 26, 2015 when I register I should answer " last name of the CEO of autodesk" ,can u or anyone else give a help? Here I can't get in google. Thanks a lot. Quote
ymg3 Posted September 26, 2015 Posted September 26, 2015 At the moment the CEO of Autodesk is Carl Bass Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.