Visual LISP, AutoLISP and General Customization
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel Co-Ords

1 REPLY 1
Reply
Message 1 of 2
Anonymous
123 Views, 1 Reply

Excel Co-Ords

Hi This is my first post and I'm Very New to AutoCAD

I'm an engineer and need to turn an AutoCAD drawing into an excel spreadsheet

what I need is to lift the Co-Ords from the centre of Circles and turn them into a spreadsheet which looks like this
P10 2064.800 2001.050
P11 2065.700 1999.475
P12 2063.900 1999.475
P13 2072.000 2001.050
P14 2072.900 1999.475
P15 2071.100 1999.475


Where P15 is the Name of the point and the first Co-Ord is Easting and the Second the Northing

i need to do about 5000of these so doing them by hand is tiring and dangerous as i'm bound to miss type one

It would also be hand to do the same but the other way around, so i can constuct an Asbuilt drawing from an excel spreadsheet

Thanks in advance I hope someone can help

I can Email copies of drawings or Spreadsheets if need be


Neil
1 REPLY 1
Message 2 of 2
Anonymous
in reply to: Anonymous

Hi,


use the LISP file attached, just load it using APPLOAD command en run it
using function COORDINATES.

It writes the coordinates of your circles into and comma-delimited file you
can open in Excel.

P1,X,Y
...

greetings



"NWhite" wrote in message
news:f12d2b8.-1@WebX.maYIadrTaRb...
Hi This is my first post and I'm Very New to AutoCAD
I'm an engineer and need to turn an AutoCAD drawing into an excel
spreadsheet
what I need is to lift the Co-Ords from the centre of Circles and turn them
into a spreadsheet which looks like this
P10 2064.800 2001.050
P11 2065.700 1999.475
P12 2063.900 1999.475
P13 2072.000 2001.050
P14 2072.900 1999.475
P15 2071.100 1999.475
Where P15 is the Name of the point and the first Co-Ord is Easting and the
Second the Northing
need to do about 5000of these so doing them by hand is tiring and dangerous
as i'm bound to miss type one
It would also be hand to do the same but the other way around, so i can
constuct an Asbuilt drawing from an excel spreadsheet
Thanks in advance I hope someone can help
I can Email copies of drawings or Spreadsheets if need be
Neil

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Forma Design Contest


Autodesk Design & Make Report