View Full Version : Inserting blocks with coordinates from Excell
29th Dec 2010, 04:28 pm
I'm pretty confident that this can be done as I've done it before but I'm suffering from a mental block (to many mine pies!).
I have a list of a hundred or so points with x and y coordinates. I want to insert these into AutoCAD without putting each on as a single point.
I think it was done by setting the pdmode and pdsize then another command?
Any help would be very appricated.
29th Dec 2010, 04:37 pm
Are you using a txt or csv file by any chance?
29th Dec 2010, 04:38 pm
None of the above, I just have the coordinates listed in an excel spreadsheet.
29th Dec 2010, 05:29 pm
What symbol do you want to use to represent each point?
29th Dec 2010, 05:35 pm
The answer you were searching for was right here under both ours noses: Michael's Corner. Click on the link below. Scroll down to the section called The Odd Spot. Michael explains how to get coordinates from Excel into AutoCAD.
30th Dec 2010, 08:58 am
Thats excellent, I knew I'd seen it before!
Many thanks once again,
30th Dec 2010, 12:11 pm
You're entirely welcomed Mark. :)
30th Dec 2010, 01:19 pm
I changed the script file to 'point' and its point a point in at each location I needed. Saved hours!
Happy new year,
4th Jan 2011, 03:33 am
Easier still if you just want a point trying to remember its another post here copy the x,y of all the points in one go from excel
In autocad "point" then paste all should appear in one go.
This works for line & pline etc as well
Powered by vBulletin™ Version 4.1.2 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.