sjm Posted May 29, 2007 Share Posted May 29, 2007 Hi all, Hopefully someone can help me here, i'm a bit of a novice at all of this. I have an excel file containing xyz co-ordinates that i wish to import to AutoCAD (2005). I realise you can probably do this using the lisp function, but i don't know how they work, and wanted to know if there is an easier way. Any help is appreciated. Cheers, sjm Quote Link to comment Share on other sites More sharing options...
lpseifert Posted May 29, 2007 Share Posted May 29, 2007 If you want to draw a 3D polyline to connect the dots try this: In excel get your data in x,y,z format. This can be done by creating an equation to concatenate the data; e.g =A1&","&B1","&C1 where cells A1, B1 and C1 hold the x, y and z values. Highlight the new column and press Ctrl+C (copy). In autocad start the 3dpoly command, when it prompts you for a start point, paste the coordinates (Ctrl+V) at the command line. Quote Link to comment Share on other sites More sharing options...
sjm Posted May 29, 2007 Author Share Posted May 29, 2007 Thanks lpseifert, This would work but i don't want to draw a polyline and want to have the points only. [This survey data is to be then imported into another survey, and then contours plotted for all the points] Any other ideas ? Cheers sjm Quote Link to comment Share on other sites More sharing options...
fuccaro Posted May 29, 2007 Share Posted May 29, 2007 So enter MULTIPLE POINT in the command line and paste the coords as lpseifert says Quote Link to comment Share on other sites More sharing options...
sjm Posted May 29, 2007 Author Share Posted May 29, 2007 Thanks guys, points all successfully inserted sjm Quote Link to comment Share on other sites More sharing options...
Prime8 Posted August 19, 2009 Share Posted August 19, 2009 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. Quote Link to comment Share on other sites More sharing options...
miguelvarez Posted August 19, 2009 Share Posted August 19, 2009 Prime8, The following lisp tool does exactly what you are looking for. The author is Mario Torres, check out his web (3w dot construcGeek dot com), his always uploading useful stuff. It is in spanish, but i think is easy enough to use it even if you dont know spanish. however, if you have problems i can translate it Regards xLDes>en GoogleC xLDes in GoogleC edit: I add a sample excel template so you know how must be the format. [/ color] [/ color] Importar puntos de coordenadas v1.3.lsp Quote Link to comment Share on other sites More sharing options...
Prime8 Posted August 19, 2009 Share Posted August 19, 2009 I may need another explanation that is simpler and in english. Also, I have a spreadsheet of over 400 points. Quote Link to comment Share on other sites More sharing options...
eldon Posted August 20, 2009 Share Posted August 20, 2009 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. Quote Link to comment Share on other sites More sharing options...
fuccaro Posted August 21, 2009 Share Posted August 21, 2009 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. 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. Quote Link to comment Share on other sites More sharing options...
hector81 Posted May 24, 2010 Share Posted May 24, 2010 Hello, Thanks for the info. But, what do I type in the command line to invoke this lisp? Quote Link to comment Share on other sites More sharing options...
fuccaro Posted May 25, 2010 Share Posted May 25, 2010 Try ICE Also you will find HERE some basics about running Lisps. Welcome in the forum! Quote Link to comment Share on other sites More sharing options...
crushmaster Posted May 26, 2010 Share Posted May 26, 2010 Thank you,fuccaro,you write so cear,i learn the 'concatenate' command from your post!I cannot use Excel well! Quote Link to comment Share on other sites More sharing options...
MotoGirl Posted May 26, 2010 Share Posted May 26, 2010 Size is no problem. I have a lisp (not available for posting) which did 10,000 points in 29 seconds. to bad he's not running Civil 3d, it's built for doing what your trying to do, i made 30,000-40,000 points in an excel file (had to be formulated) then imported them into cad with the points command. worked like a breeze. but i've used a lisp like the one provided to do the same thing as well, this one is better then any i've seen out there though, thanks Quote Link to comment Share on other sites More sharing options...
JAC7707 Posted October 15, 2010 Share Posted October 15, 2010 Hello All, I am having the same problem that SJM was having, however, the MULTIPLE POINTS command seems to be invalid, I am using autocad civil 3d 2010 version. Any ideas as to why this is? Thanks, JAC7707 Quote Link to comment Share on other sites More sharing options...
Mohamad Posted January 2, 2012 Share Posted January 2, 2012 Hello miguelvarez, can u please tell me how to run this lisp (Importar puntos)? B.R Quote Link to comment Share on other sites More sharing options...
Organic Posted January 2, 2012 Share Posted January 2, 2012 Hello miguelvarez, can u please tell me how to run this lisp (Importar puntos)? B.R Load the lisp as described in the link above. Then use the command iCe to run the program. Quote Link to comment Share on other sites More sharing options...
gobinda_1977 Posted August 6, 2012 Share Posted August 6, 2012 dear sir, after upload i type command iCe that time error is coming(Se ha producido el error: bad argument type: variantp nil) please sir tell me the procedure for how i solve it. one more thing if u translate it to english , it will be very help full for me. i am waiting for ur reply. thanking u in anticipation. Gobinda Halder Doha,Qatar mail:gobinda_1977@rediffmail.com Quote Link to comment Share on other sites More sharing options...
Mefloump Posted August 8, 2012 Share Posted August 8, 2012 I frequently use this lisp routine to create ICT fixtures from a drill file. Beats inputting each point manually. http://www.lee-mac.com/ptmanager.html Quote Link to comment Share on other sites More sharing options...
sagarika Posted August 24, 2012 Share Posted August 24, 2012 will d above soln work....for generating points with text name Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.