• Importing Points Into Autocad

Hello, I've gotten this all in but if I wanted to add a label, say point BC-09,BC-10,etc and have it show up in autocad next to the points I've entered into the display with the Multiple,Point command. I would prefer a similar copy and paste from excel command.Thanks in advance.The pasting from Excel is possible with one type of data only. If you want to write labels, you are dealing with two types of data. One type is the x,y,z position and the other type is the label text.Lisp will do that easily. Size is no problem. I have a lisp (not available for posting) which did 10,000 points in 29 seconds. A possible solution: draw the points and use a script to put the texts near them.

It is a poor approach since there is no connection between the points and the texts.Use Excel to generate a script file.Assuming X is stored in the column A, Y in B and the text in C, enter in D1 the formula:=concatenate('text',A1,',',B1,',2.5,',0,',C1,')Replace the underscores with spaces, I used underscores to clearly mark where to put spaces.Here are the explanations: First you instruct AutoCAD that you wish to start the TEXT command. Put a space after it –it will act like the Enter.

Importing Points Into Autocad

Name:ImportXYZDescription:ImportXYZ is a no fuss, groovy little, AutoCAD LISP routine, for importing coordinates (X,Y,Z, locations) from practically any type of file.