point to line

[Fuli129]

I have a point file with z values and i was wondering if anyone knows a way to automate a 3d polyline using the points?

 

[lpseifert]

If you want to draw a 3D polyline to connect the dots try this:
In excel get your data in x,y,z format. This can be done by creating an equation to concatenate the data; e.g =A1&","&B1","&C1 where cells A1, B1 and C1 hold the x, y and z values. Highlight the new column and press Ctrl+C (copy). In autocad start the 3dpoly command, when it prompts you for a start point, paste the coordinates (Ctrl+V) at the command line.

____________________
Acad2006, Terramodel

 

[Occupant]

Or in Excel: =CONCATENATE(ROUND(A2,5),","ROUND(B2,5),",ROUND(C2,5)) and then EDIT>FILL down until you have covered all your data assuming the original data starts at A2, B2, C2. Copy all that (not your original data) into the clipboard and then into a text editor; add _3dpoly at the first line and save as *.scr. In Autocad run the script file. Turn OSNAP off when you do.