Use Excel form to help draw AutoCAD concentric circles

In a technical forum to see a friend mentioned such a question: how quickly in AutoCAD to draw multiple concentric circles? To this question Netizen's answer is various, has the reply to say with the deviation command, has the answer with the array ... Of course, there are friends. Presents a more practical VBA solution and AutoLisp solution.

I think that the use of VBA or AutoLisp as a solution is of course a very good way, but since the landlord raised such a problem, presumably on the AutoCAD VBA and AutoLisp function, want to learn in a short time and understand the two programming skills must be difficult. Recall that I have seen a friend once wrote that can use Excel to help draw points in AutoCAD, the author can not help but think of the use of Excel tables as AutoCAD Auxiliary drawing tools to try.

First of all, of course, open a blank Excel table, in the A1 cell input in AutoCAD to create the circle of the shortcut command "C", in the B1 cell input we want to draw the circle center, where we use "0,0" as the center, then in the third column C1 cell of course input is the first circle radius, Here we have the minimum circle radius of 1, so that the first row of cells is completed, the following figure:

Fill in the radius of the circle

At this time I dare not judge this method is feasible, try first: Select A1B1C1 three cells, copy, switch to AutoCAD, click on the command line with the mouse, when the cursor flashing in the command line, press CTRL + V paste Clipboard content to the command line, Then look at the AutoCAD drawing window has drawn a circle, obviously this method is feasible.

The following work is in Excel to continue to enter the drawing command, but also like just as the keyboard to knock in? Of course, Excel is a batch processing expert, we only need to fill in the A2b2c2 cell in the second round of data, You can use the Fill function of Excel to pull down to line tenth to complete all the data:

Complete all the data

At this time we select A1:c10 area in Excel again, press CTRL + C to copy the area, switch to AutoCAD, click the command line with the mouse, press CTRL + V paste Clipboard content to the command line, so the AutoCAD in concentric circle drawing process is completed, it is noteworthy that, If we do not use the mouse to click the command line before pasting the focus of AutoCAD to the command line, paste the result may be the form of the table pasted into the plot area. If you draw more concentric circles, the difference in the process is simply pulling the padding into more rows in Excel.

As we can see from the above example, if we have more than a regular number of simple command input, you can first through the help of Excel data processing, and then use the Clipboard instead of us for "command input", not only the command to draw a circle can do so, there are many commands to use a similar method, Interested friends might as well try.