Suppose we have a list of points captured with GPS, or UTM coordinates that are in Excel and we want to draw them in AutoCAD.
In the case of users of Microstation, I explained it previously in this post, Importing from a .cvs file, adding some more points to make it more interesting.
To export from dwg to excel See this post.
1. Prepare the coordinate format
In the case of AutoCAD, although the most practical thing is to do it with the old versions of Softdesk8, or CivilCAD, let's see a perverse method of how to do it without recourse to a lisp or other applications.
These are the coordinates that you have in Excel, because the objective is to pass them in the format that the autoCAD command line accepts, which would be:
X coordinate, comma, y coordinate
Such as 431512,1597077
Well, to do this, we do in excel the following, in the following column we write the formula
= CONCATENATE (A2, »,», B2)
What we are doing is copying cell A2, then a comma, then cell B2. We do enter and copy the formula down. In case we have a coordinate in z, the same, after B2 we would make another comma and write C2.
2. Copy coordinates
This is how we have been.
- Select all the cells in column C, then copy to the clipboard (Ctrl + C)
3 Draw the points in AutoCAD
- Now in AutoCAD we write the command Point, (Draw / point / multiple point)
- Now paste what you have in the clipboard (Ctrl + V) on the command line
And ready, there are your points
In case you do not see the points very well, the format (point / format style)
What ... do you know another way to do it?
To draw the traverse, just use the plando in place of the command point, and it is going to draw.
Thanks to the information of jordi, there is a macro to do it practically ... read it in the comments of this post.