I have about 30 points in an excel/text file consisting of Eastings/Northings/Comments, is it possible to import these automatically as points into a CAD File?
Im currently doing it manually.
Yes it is possible to what you need. Just one question though.....
What's a Easting or Northing? I presume that these are surveyors coordinates - is that correct?
To create ACADPOINTS in a drawing from a list of coordinates is really quite simple. If you email a copy of the excel file so I see what kind of info it is and how it's all layed out, I'll take a look at it and write a bit of code or program to help you. Please also write a more detailed description of exactly what you want and what everything does or needs to do..
They are surveyors coordinates but i wont be allowed to send you the file (Confidentalty Agreement) but its 30 line of basically
Comment Easting (m) Northing (m)
1 562 632.3 361 553.2
2 562 597.3 362 020.2
but i would like to be able to import them all as points or symbols into a dwg file.
Since LT doesn't handle lisp you are limited to using a script. However a script may work just fine. If the point you want to create is a standard point entity and not a symbol with attributes, the following approach will work. A symbol with attributes could be accomplished similarily.
First delete the column with comment/point number. Save the excel file to csv format. You'll then have a text file with N & E separated by commas. At the top oif the file, type in AutoCAD commands to start the point function:
Multiple
point
E1,N1
E2,N
etc. etc
Save the file with a .scr file extension. Execute this file by typing SCRIPT within AutoCAD. After it runs you'll need to hit Escape to stop the multiple point command.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.