Plotting X, Y, Z & Contours

dhananjayr567 · 发表于 2022-7-5 18:34:59

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.

Commandobill · 发表于 2022-7-5 18:45:00

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

Commandobill · 发表于 2022-7-5 18:49:47

Then of course typing "scr" at the command line and choosing it from your file location.

Commandobill · 发表于 2022-7-5 18:52:41

Also, I never used this, but Lee-Mac has a program for this as well. Here

Lee Mac · 发表于 2022-7-5 18:56:46

Thanks for the recommendation CB - the OP will need to save his XLS to a CSV first

BIGAL · 发表于 2022-7-5 19:04:12

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

ymg3 · 发表于 2022-7-5 19:06:22

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

smileforrest · 发表于 2022-7-5 19:14:47

When i reach your link ,how can i download your lisp TriangV6.4.0.lsp ?
thanks!

Lee Mac · 发表于 2022-7-5 19:18:02

You will need membership at The Swamp in order to view & download attachments.

ymg3 · 发表于 2022-7-5 19:23:30

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

[编程交流] Plotting X, Y, Z & Contours

发表回复

精选推荐