co-ords from autocad to excell? 1

[goaliehamy]

Hi m new to the forum but I have ben blundering my way around autocad for a few years. I am trying to gather the easting and northing co-ordinates of several items from autocad drawings and transfer them to excell where i can save them as a csv file for converting to my total station software. at present I can only using the I command pick the point then I have to hand write al the co-ords down and then re-enter them into excell. I do not know anything about the autolisp commands I have been reading about. Is there any way that I can do this quicker than at present

regards
Goaliehammy

 

[LHA]

You can put all the points on a new layer, isolate that layer, type LIST in command, select all points. You will get a text file, which you can Select, Copy and Paste. You will still have to edit, to remove all the other text. The X is E the Y is N, so you might (or might not, check how your data collector reads) have to reverse them or your data collector will read them 90d rotated. This part is best done with Excel. If you have elevations, they will appear as Z, and your data collector can also read them. I use Word, so I can Replace All with a comma. The comma is what the total station will need to differentiate N and E, a hard return will let it differntiate each point. See below, you probably want to end up with 3.3747,8.1001,0.0000.


Command: POINT
Current point modes: PDMODE=0 PDSIZE=0.0000
Specify a point:
Command: list

Select objects: Specify opposite corner: 1 found

Select objects:

POINT Layer: "0"
Space: Model space
Handle = 2f
at point, X= 8.1001 Y= 3.3747 Z= 0.0000

Engineering is the practice of the art of science - Steve

 

[goaliehamy]

Thanks LHA. This is a new command to me and I will play with it for a while to see if it is what im looking for. it sounds appropriate but ease of use for me will determine its value.

Once again thanks


once I was blind but now the forum lets me see

 

[IFRs]

Check to see if your version of AutoCAD supports the type of units you are needing. Then LIST may show you exactly what you are looking for.

 

[CarlB]

There are several lisp routines you can find on the web to automate writing coordinates of various entities to a text file. For example on this site you can find a few:

http://www.eng-tips.com/viewthread.cfm?qid=62090

http://www.eng-tips.com/viewthread.cfm?qid=33152

 

[chicopee]

Anbother thing that you can do is turn off all layers except the points which you need the coordinates; do a LIST command of all the points; then paste and copy to wordpad or excel the history of all the points that you did a listings; and then modify the content of wordpad or excel into a tabular format.

 

[ollylandandwater]

Is there a way of doing the opposite excel to autoCAD, i have recently been asked to produce drawings from my survey data, and at present, i input them one by one, this was ok for small details, however i am required to survey a large bund, and this will lead to a large number of points!

 

[CarlB]

You can copy data from Excel & paste into AutoCAD's command line. So start a command (say "multiple" "point") then paste a set of coordinates & they'll all be drawn in AutoCAD.