Excel Spreadsheet

[JKinzenbaw]

I have a number of Excel spreadsheets with northing and easting coordinates in the first 2 columns. In the 3rd column I have a station # (these spreadsheats are location and names for GPS monuments). Is there away to use the northing and easting to place a point in my drawing and have the point # automatically label the corresponding point.

[architech]

I believe CarlB answered this ....


CarlB [said ...]

You can do a litle manipulation of the data in Excel and avoid the need for lisp or VBA. For dispay of the station # I suggest you create a simple block, using a point and one attribute. This block will be inserted at each x,y coordinate, and the attribute will be the sta #. All the information for placing the point and sta# can be entered (pasted in one operation) into AutoCAD's command line. Now in Excel write a formula to concatenate info in the syntax needed for AutoCAD. the syntax will be something like:

-insert blockname xcoord,ycoord 1 1 0 Sta#

Cut and paste this column of data (commands) into AutoCAD's text window and you should be on your way.

:mrgreen: