Topic: XLS to autocad to draw

[MSTG007]

Does anyone know how to get a xls with N,E,ELEV in different colums to draw the point in autocad?

I have a xls section corner....

[CarlB]

Sure-

In Excel, type a formula in a new colum to string together x,y,z values.  In Cell D1 that would be '=B1&","&A1&","&C1'. Copy the formula down for all points.  Should give you point data in proper format.

Then in AutoCAD type "multiple" "point", then copy the point data from column D, all in one shot, and paste into AutoCAD's command line.  Then terminate point command with an "esc".  You should now have all your points in the drawing.

HTH!

[Scott]

I have a lisp to do this.  You just have to add a couple of columns to your excel file.  The first is the point number, then northing, easting, elevation and point code.  Save the file as a tab or comma delimitted text file and run the lisp inside autocad.  Shoot me an email if you would like a copy of it.  Take the spaces out of the email address.  I don't need anymore spam.

s m urrison@cox.net

[MSTG007]

Ill give it a try tomorrow... I have a excel list with the N,E,ELEV of Section corners.. I want to get it to a dwg format... is there a way that it can take that info to a block?

[diarmuid]

howdy,

firstly, dowload rapiddxf2.0 which you can get on cadalog.com under the freeware section, if not let me know and i'll try to post the prog.

if you follow the programme it will explain how to turn the excel spread sheet into a cad drawing.  (you can export to dxf, which you can import into dwg.)

hth

[Gliderider]

This should help-

http://usa.autodesk.com/adsk/servlet/ps/item?siteID=123112&id=2878966&linkID=2475323