Circles from excel to autocad

[Anonymous]

I have many x,y and radius values on excel file however I can't export them to autocad.

Is there any shortcut to do all in once?

Thank you 

[Anonymous]

Hi

I have a bundle of coordinates which are donuts' centre, the inside radius and outside radius are different for each donut.  Is it possible to import donut without filling colour?

[Alfred.NESWADBA]

Hi,

>> Is it possible to import donut without filling colour?

A donut is filled, in AutoCAD there does not exist an option for donut filled or not filled.

Even FILLMODE 0 (which would disable all fillings of filled objects like hatch, TTF text) would not look like you want.

If you draw 2 circles instead, it would look like a none filled donut, but that's 2 separated objects. Not sure if that fits to your workflow.

- alfred -

[Anonymous]

1. combine the Easting and Northing values in excel sheet using the command CONCATENATE

 =CONCATENATE(Easting,",",Northing) 

2. Create a circle in AutoCAD blank sheet using the command "CIRCLE"

3. Copy the CONCATENATE cells from excel

4. in AutoCAD select the Circel created, type the command -> "CO"->then press enter -> then select the centre of the Circle -> then put the cursor on command line and press "CTRL+V"->press ESCAPE.

[Anonymous]

Dear All

I have a similar issue - for 28,000 circles that I need drawn. On excel, I have a serial number, an Easting and Northing position, a circle radius and a descriptor of each type (in this case, trees), arranged on an excel file

I am hoping to find a Lisp that allows me to insert a circle at each of the UTM positions, and draw it to the correct size, and add the corresponding serial and type label to the circle. 

Does anybody know how to do this? It really doesn't seem beyond the realm of AutoCAD's capabilities, just mine.

Thanking you in anticipation

Jason Turner

[Alfred.NESWADBA]

Hi,

>> Does anybody know how to do this? 

Why not following the above suggestions, building up a formula that either inserts a block (with a circle, using XY for coordinate and scale for radius) or creating a circle ... direct in Excel and then copy & paste the finished formulas into AutoCAD?

- alfred -

[Anonymous]

Thank you. That would possibly work, if I had any idea how to do that.

Regards,

Jason Turner

[Alfred.NESWADBA]

Hi,

>> if I had any idea how to do that.

This thread has a solution marked, post 5, that is what you need to do, a step-by-step description.

- alfred -

[Anonymous]

Thank you. I'll try that.

Regards,

Jason

[szecsiviktor]

Amazing solution. 

Do you maybe know a way to use this method but instead of x,y coordinates I want te circle to plot on a specific geolocation (lat/long) I have the coordinate system and map and everytnig set up already, but the only way I manage to insert anything using longs and lats is dropping position markers. I would like to be able to get circles drawn automatically at specific locations with specific radius/diameter as I have a big amount of lats/longs/distance=radius data in excel. This solution is almost exactly what I need just longs and lats instead of x and y coordinates.

[Pointdump]

Hi Viktor,
Vanilla AutoCAD doesn't understand Latitudes and Longitudes. Use Civil 3D or Map 3D instead.
Dave

[dbroad]

You would need to convert from latitute to northing and longitude to easting or something like that first.  You would also need to choose the datum.  The suggestion to use Civil3d or Map might be best.

[szecsiviktor]

Thank you both @dbroad and @Pointdump !

[Pointdump]

Viktor,
Do you have Civil 3D or Map 3D?
If you have just Vanilla AutoCAD and this is a one only, post your lats/longs and I'll transform them to UTM or whatever coordinate system you'd like.
Dave