Guest nodavilp Posted January 2, 2007 Share Posted January 2, 2007 Hello! How do I transfer coordinates from excel 2003 to autocad 2004 ? thanx btw Happy New Year Quote Link to comment Share on other sites More sharing options...
CarlB Posted January 2, 2007 Share Posted January 2, 2007 What do you want to do with the coordinates, put them in a table, or draw something based on the coordinates? Quote Link to comment Share on other sites More sharing options...
Guest nodavilp Posted January 2, 2007 Share Posted January 2, 2007 I need to draw a map,somthing like cadastre map....so yes i want to draw,connect them,etc... Quote Link to comment Share on other sites More sharing options...
CarlB Posted January 3, 2007 Share Posted January 3, 2007 If the coordinates are in some logical order in Excel then you can draw something (e.g. lines, polylines, or points) by using a script, or by pasting the coordinates into AutoCAD's command line after starting a command. As an example, if you have coordinates with x&y values in separate colums, in another column write a formula to combine them in the format "x,y". To connect thes coordinates with a polyline, start ye polyline command, and when prompted for a point copy the entire column of "x,y" values, then paste into AutoCAD, and the PL will be drawn through the points. Quote Link to comment Share on other sites More sharing options...
rick_belial Posted November 15, 2007 Share Posted November 15, 2007 Further to this is it possible to attribute plotted point with a name and an other detail such as a weight? Quote Link to comment Share on other sites More sharing options...
specialforces27 Posted November 20, 2007 Share Posted November 20, 2007 How did you combine two columns of data into "x,y" output in a new column?? Quote Link to comment Share on other sites More sharing options...
CarlB Posted November 20, 2007 Share Posted November 20, 2007 How did you combine two columns of data into "x,y" output in a new column?? Formula in Column C: =A1&","&B1 or =concatenate(A1,",",B1) Quote Link to comment Share on other sites More sharing options...
specialforces27 Posted November 20, 2007 Share Posted November 20, 2007 ahh, worked like a charm. Thanks! Quote Link to comment Share on other sites More sharing options...
sagarika89 Posted September 4, 2012 Share Posted September 4, 2012 just wanted a help....i want the x,y,z co-ordinates visible in autocad along with the point location....any help z appreciated.... Quote Link to comment Share on other sites More sharing options...
MSasu Posted September 4, 2012 Share Posted September 4, 2012 Then do a second script to draw those labels: _TEXT _J [color=black]_M _non[/color] [i][color=blue]X,Y,Z[/color][/i] 5.0 0.0 [i][color=blue]X,Y,Z[/color][/i] There should be one line for each label; adjust the alignment (currently Middle) and height (currently 5.0) for your needs. Quote Link to comment Share on other sites More sharing options...
afrazawan Posted September 4, 2012 Share Posted September 4, 2012 how can i make script like this please Quote Link to comment Share on other sites More sharing options...
MSasu Posted September 4, 2012 Share Posted September 4, 2012 Please check this tutorial on script matter. Quote Link to comment Share on other sites More sharing options...
sagarika89 Posted September 4, 2012 Share Posted September 4, 2012 sorry couldnt get it.....can u please tell me 1ce again clearly??? Quote Link to comment Share on other sites More sharing options...
sagarika89 Posted September 4, 2012 Share Posted September 4, 2012 actually....i want it using concatenate.....from excel itself to autocad Quote Link to comment Share on other sites More sharing options...
MSasu Posted September 4, 2012 Share Posted September 4, 2012 Use the features of Excel (or a spreadsheet tool of your choice) to edit the points into a script to draw the polyline and also add the labels. Check on the help of that tool for formulas to build strings (concatenation). Your script should look something like: _PLINE 110.0,120.0 210.0,220.0 310.0,330.0 _TEXT _J _M 110.0,120.0 5.0 0.0 "110.0, 120.0" _TEXT _J _M 210.0,220.0 5.0 0.0 "210.0, 220.0" _TEXT _J _M 310.0,320.0 5.0 0.0 "310.0, 320.0" _ZOOM _E Just don't forget to save it as an ASCII file (simple text) - for more information check the tutorial recommended above. You cannot run it directly from Excel, should use the SCRIPT command inside AutoCAD. 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.