Rectangles in excel to autocad
Accepted solution
Small alteration to your formula in Excel, add a space after the word rectangle before the closing quote and your second comma should also be a space (not a comma) this separates the first coordinate from the second. Now just copy that whole list in column K Ctrl+c in Autocad make sure the command line is active (the cursor should be blinking inside the command line) then press Ctrl+v, you might need to zoom extents, but you should have a row of rectangles drawn in Autocad.
Thank you. Is there a way to get them spread out against the x direction by the same amount. As well to have a layer or id number attached to them?
The coordinates are there in your Excel file, it is those numbers you would need to adjust (fairly easy with a formula I would have thought).
As for the label, sure just tag on a 'text' command into the Excel formula, just try out the chain of commands first in LT to see what you need to enter at the keyboard, the text position could just be again coordinates that you can work out in Excel. BUT you will find one problem when running the text command from a 'script' like this as AutoCAD LT has a hard time figuring out when you are trying to simulate the enter key at the end of the text because in this situation it reads a space as a literal space (and not as the enter key) so the text/ label has to be the very last item in the Excel cell, Autocad sees the 'end of the formula' as a return or enter but only as the equivalent of the enter key ending the text item so you need to place space before the word '#rectangle' (the '#' key represents a space here) starting on the second formula which is the same as pressing the enter key to end the previous text command. It's a bit difficult to explain but try it and see if you can work that out.
I haven't started the layer yet but I was looking more into my excel the rectangles don't come into the right size from the formula. The numbers that are in the formula are correct but when they get export to AutoCAD
Without looking too closely, the one thing that can cause problems is osnaps, this is dependant on your zoom level, but even using a script if the point you give in a script is somewhere close to an existing point then AutoCAD will still automatically snap to other geometry, you should turn off osnaps 'F3' before running a script, try that and see if it improves (and also turn off grid snaps).
I turn those off and it still a) doesn't put it at 0,0 b) doesn't make the dimension I am trying to make.
I can't work out from just an image what you are trying to achieve? When I run the script Autocad produces a row of rectangles that are wider than their height, which is exactly what the numbers in the Excel sheet tell me is the correct information. Are your formulas correct? Or do you expect a different result, which might mean your formulas need to be altered? Can you post a dwg file using the first few sets of coordinates shown in the Excel sheet but actually draw the rectangles manually so I can see how it should be appearing in AutoCAD.
The rectangles I have colored yellow in the attached file make sense with the values you have in columns D and E in Excel but the formulas used to create the values for X1, Y1, X2 and Y2 don't make any sense why do you need 250 in cell J6 followed by 550 in J7, it is these numbers that the script is using? Do you just need to correct the formulas to use the correct numbers?
What is also confusing is where do the red rectangles come from in your drawing (I changed the colors) what are they supposed to represent.
