CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.
Please abide by the
rules of this forum.
How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
Author |
Topic Search Topic Options
|
Peadaregan
Newbie
Joined: 23.Oct.2009
Location: United Kingdom
Status: Offline
Points: 1
|
Topic: Copy multiple coordinates from Excell into CAD Posted: 23.Oct.2009 at 13:11 |
Hello,
I would like to copy approx. 200 Easting and Northing Coordinates that are in Excell (in two columns) into CAD.
I was hoping these Coordinates would appear as points.
Don't fancy copy and pasting individually!
Any ideas?
|
|
miki1
Newbie
Joined: 22.Oct.2009
Location: Bosnia Hercegovina
Status: Offline
Points: 6
|
Posted: 23.Oct.2009 at 17:20 |
find IMPORTXYZ.lsp on web. after, tools>load application>find lsp>browse for excel file, choose type of inserted points (node, block, circle) and THIS IT!
|
Milan Tesanovic
|
|
CarlB
Senior Member
Joined: 16.Oct.2009
Location: United States
Status: Offline
Points: 321
|
Posted: 23.Oct.2009 at 19:40 |
A quick way to do it, to just create unlabeled points, is to use the AutoCAD "point" command, then paste in the coordinates.
Point coordinates should have x & y values in separate columns in Excel, adjacent rows.
Type MULTIPLE then POINT on the command line.
When prompted for point location, copy & paste range of values from Excel.
Voila!
|
|
miki1
Newbie
Joined: 22.Oct.2009
Location: Bosnia Hercegovina
Status: Offline
Points: 6
|
Posted: 24.Oct.2009 at 12:33 |
Maybe, you think adjacent columns? I try your solution but don`t work on my AutoCAD 2010.For now, better solution is IMPORTXYZ lisp.
|
Milan Tesanovic
|
|
CarlB
Senior Member
Joined: 16.Oct.2009
Location: United States
Status: Offline
Points: 321
|
Posted: 24.Oct.2009 at 21:13 |
For copying data, yes x & y data should be in columns, all adjacent,as in:
x1 y1 x2 y2 x3 y3 etc...
this method comes in handy for drawing lines & polylines from Excel coordinates
And for someone using LT version, they wouldn't be able to use the lisp option.
Edited by CarlB - 24.Oct.2009 at 21:14
|
|
bmshutts
Newbie
Joined: 12.Nov.2009
Location: United States
Status: Offline
Points: 5
|
Posted: 12.Nov.2009 at 15:13 |
in the third collum of EXEL type this =CONCATENATE(A1,",",B1) Then hit enter. Copy down that collum. In CAD hit the point command and copy the new list of points COMMA FORMAT to the command line in CAD. Zoom to extents and you got em.
|
|
miki1
Newbie
Joined: 22.Oct.2009
Location: Bosnia Hercegovina
Status: Offline
Points: 6
|
Posted: 13.Nov.2009 at 15:36 |
CONCATENATE command in Excel is a solution!Just that column from Excel taked with Ctrl+C and pasted in AutoCAD 2010 (MULTIPLE>POINT>Ctrl+V). Well done!! Question is, is that work with Z koordinate?
|
Milan Tesanovic
|
|
bmshutts
Newbie
Joined: 12.Nov.2009
Location: United States
Status: Offline
Points: 5
|
Posted: 13.Nov.2009 at 16:38 |
for the z coordinate to be added =CONCATENATE(A1,",",B1,",",C1)
drag down copy values to another collum. copy these values into the COMMAND LINE after Point enter
|
|
miki1
Newbie
Joined: 22.Oct.2009
Location: Bosnia Hercegovina
Status: Offline
Points: 6
|
Posted: 14.Nov.2009 at 10:53 |
Thanks a lot ! I`ll never use ImportXYZ.lsp anymore. Best regards!
|
Milan Tesanovic
|
|