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. Fantasia Painter Free Download For Windows 7.

Issue: You have a Microsoft Excel file with point data X, Y, Z; and you want to import this information into Autodesk® AutoCAD® Civil 3D®. Solution: Create a.csv file from Excel file if necessary. See Also: How to filter point data when importing points in Civil 3D. Products: AutoCAD Civil 3D. Sep 11, 1997 LTspiral.xlsx - example of 2D spiral calculated in Excel, XY polyline ready to paste into AutoCAD LT: 15519: 9.3.2015: MakeMore (Kent Cooper) - create similar.

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,'_',C 1,'_') 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.

A1 and B1 are the cells where the cords are, separated by a comma. Again a space (read: Enter) Enter the text height (only if you don’t use a fixed height text style) fallowed by a space. Enter the rotation angle -zero is for horizontal, but you may enter any legal value, and again a space Enter the address of the text to be placed on the screen: C1 A final space will terminate the command. Once you get the first line, select D1, click and hold the black dot in the right down corner and drag it down to apply the function to all the lines.

Click the column head D (right the letter D) and all the column should be selected. Press CTRL+C, open Notepad and paste the text. Add an extra CR and save the file as Anyname.SCR Drag this file in AutoCAD’s drawing area. Of, and I would disable the snap before that.

An other approach could be to place in the drawing blocks containing a point and an attribute. The way is similar, just use the 'Insert' command instead of 'Text' and provide the answers as AutoCAD expects them.

Import 3D Points from Excel (AutoLISP Solutions) 1 Apr, 2003 By: Create AutoCAD polylines from point data stored in spreadsheets. Two readers want to import Excel spreadsheet data into AutoCAD. David Rodrigues wants to bring a DOS text file saved from an Excel spreadsheet into AutoCAD. John Kuenzle of Waukesha, Wisconsin, needs to create 3D polylines from x,y,z coordinates stored in an Excel spreadsheet. IMPORT-3D-POLY.LSP takes a set of x,y,z coordinates from a comma-delimited text file and creates a 3D polyline.

A comma-delimited text file is a file type you can save directly from an Excel spreadsheet. Figure 1 shows a sample Excel spreadsheet, and figure 2 shows the corresponding comma-delimited text file. The result of running IMPORT-3D-POLY.LSP appears in figure 3. More than a thousand 3D points went into creating this 3D polyline in the form of a helical coil. Polyline created in AutoCAD from imported spreadsheet data. HOW TO USE IMPORT-3D-POLY.LSP.

Save the file in AutoCAD's Support directory. Use the Appload facility by selecting Tools / Load Application, and then use the browser to select the file.

From the AutoCAD tools menu, choose Load Applications, or enter Appload at the AutoCAD Command prompt. In the Load/Unload Applications dialog box, select the IMPORT-3D-POLY.LSP file from the support directory where you installed it, then click Close. After you load the program, AutoCAD prompts you to enter PL3 to start. Import-3d-poly.lsp displays this 3D Points File dialog box.

IMPORT-3D-POLY.LSP displays the 3D Points File dialog box shown in figure 4, where you can locate the text file that contains the required points. No further user interaction is required. The 3D polyline is drawn on the current layer. PROGRAMMING NOTES IMPORT-3D-POLY.LSP starts with my error handler and system variable management functions, after which the function (poly3d) is used to call (get-plist) and (make-3dpolyline). (get-plist) uses the standard (getfiled) function to display the 3D Points File dialog box, and skips over the first line of the text file because it is assumed there is a header in the file.

A (while) loop reads subsequent lines from the file by calling (get-pt) for each line of text. The (get-pt) function parses a text string and returns a list of x, y, and z coordinates converted to real numbers.