# Thread: Lisp: coordinates of points to excel sheet (+point number)

1. ## Lisp: coordinates of points to excel sheet (+point number)

Registered forum members do not see this ad.

Hello,
As a rocky acad 2009 (civil) user the Lisp command is new to me and a big challenge.
My job asks me to find the coordinates of points. The image has like 200 points, and I know more images like this are coming. Sofar I managed to match the picture with the drawing (correlate - match) and rotate the drawing (dview twist) so I can read the numbers of the points without getting a headache.
Now I have to look up the coordinates of each point. Of course I can go with the cursor the the point, write down the XY coordinates on a paper, scan it in and send it to the office. Pretty much of a job! There must be a easier way. Is Lisp a solution?
That would be: right click on the point, have the possibillity to fill in the point number; and the XYcoordinates, with the point number, are written to an excel sheet.

I googled a bit but as far I could find people use the other way around only: excel coordinates to a drawing.

Who knows a Lisp what can do this, or can someone help me out how to write a lisp like this?

Thanks,
Jan

2. the points are in a DWG right?

I'd use Data Extraction for this (under Tools). Explore it a bit, I think it's pretty self-explanatory but if any troubles, please come back.

The problem I see is how to match the coordinates with the points. Do the Points have some kind of identification number attached to them, or are they just points?

I have a lisp which prints out coordinates as MText of points that I have, I have to select all the points though. hmm....might have one that prints all coordinates of all points in one go, if your're interested?

3. From the Civil 3D menu...
Points > Import/Export Points > Export Points

If the points are plain autocad points and not Civil 3D points you'll need to convert them first.
Points > Utilities > Convert from Autocad Points

4. >janwillem89 Try it
If something will be not clear, I shall try to comment later.
In the text in the basic comment in Russian. It is possible to take advantage Online translator: http://www.online-translator.com/Def...px?prmtlang=en

Export of coordinates of the specified points, the chosen objects: points, blocks, polylines, splines in a text file or Excel.
Text file — txt, or csv.
A rounding off of coordinates according to current adjustments of a command _UNITS (LUPREC system variable)

3 commands Are certain
COOR - export of coordinates
COORN-export of coordinates with numbering. Numbers of points are drawn by the text on the current layer, the current style, current height (TEXTSIZE)
COORT-export of coordinates with numbering where number considers the text nearest to a point
New version see post #12

5. Could anyone please add a command to draw each POINT as well when using COORN. Thanks you

6. ...And making numbers can be like 5, 10, 15...
Thanks

7. ## Drawing lines from a file of coordinates

Originally Posted by VVA
>...
3 commands Are certain
COOR - export of coordinates
COORN-export of coordinates with numbering. Numbers of points are drawn by the text on the current layer, the current style, current height (TEXTSIZE)
COORT-export of coordinates with numbering where number considers the text nearest to a point
Thank to command COORN, I can make a file of coordinates. After changing Z value, I am finding a LISP to draw lines/Pline back in CAD with points & ID marks beside.
Any help is greatly appreciated.

8. Originally Posted by Phiphi
Could anyone please add a command to draw each POINT as well when using COORN. Thanks you
Originally Posted by Phiphi
...And making numbers can be like 5, 10, 15...
Thanks
Try it. Add new command CoorNP-Coordinates + Numbers + Points. Draw points with current value of PDMODE and PDSIZE.
Add to command CoorN and CoorNP Increment of number
New version see post #12

9. Originally Posted by VVA
Try it. Add new command CoorNP-Coordinates + Numbers + Points. Draw points with current value of PDMODE and PDSIZE.
Add to command CoorN and CoorNP Increment of number
Thank a lot, VVA.
Can you please reset Numbers at middle & perpendicular to Points/Pline.
Text height can be changed as well.
Cheers, PP.

10. Registered forum members do not see this ad.

VVA your awesome! that works a bloody treat!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts