excel to autocad

[Guest nodavilp]

Hello!

 

How do I transfer coordinates from excel 2003 to autocad 2004 ?

 

thanx

 

btw Happy New Year

[CarlB]

What do you want to do with the coordinates, put them in a table, or draw something based on the coordinates?

[Guest nodavilp]

I need to draw a map,somthing like cadastre map....so yes i want to draw,connect them,etc...

[CarlB]

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.

[rick_belial]

Further to this is it possible to attribute plotted point with a name and an other detail such as a weight?

[specialforces27]

How did you combine two columns of data into "x,y" output in a new column??

[CarlB]

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)

[specialforces27]

ahh, worked like a charm. Thanks!

[sagarika89]

just wanted a help....i want the x,y,z co-ordinates visible in autocad along with the point location....any help z appreciated....

[MSasu]

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.

[afrazawan]

how can i make script like this please

[MSasu]

Please check this tutorial on script matter.

[sagarika89]

sorry couldnt get it.....can u please tell me 1ce again clearly???

[sagarika89]

actually....i want it using concatenate.....from excel itself to autocad

[MSasu]

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.