insert rectangles with baricentri coordinates from excel

[Sandra_ME30]

lorenzo1988 17.12.15 10:36

Good morning to all,
I've just been in the forum and I have a question to do.
My situation is as follows: I have a hundred rectangles, of different sizes, to be inserted inside a autocad file in precise coordinates. of these rectangles are known the coordinates of the center of gravity.
then I would have an excel starting file with the first two columns coordinates (x;y) and then the rectangle data (b;h).
I checked on the site and I feel like I didn't find similar situations.
how do you recommend proceeding in this case?
use autocad 2015.
Thank you and wish you a good day.
I hope that lorenzo1988 read this post and rewrites on the forum.
I can't send him a pm
Sandra

 

[Sandra_ME30]

gp. 17.12.15 17:23

try this way:

- in excel sets the point as a decimal separator
- in a cell of a free column write rectangle- in the right cell write =concatena(a1-(c1/2);",";b1-(d1/2)- in the right cell write =concatena(a1+(c1/2);",";b1+(d1/2)- select the three cells and recopy below
- select everything and ctrl+c
- in command line autocad ctrl+v (set first osnap=nes)


Annex 42675

 

[Sandra_ME30]

lorenzo1988 17.12.15 23:02

Thank you very much for the answer!! tomorrow I'll try to have some fun with this great advice you gave me!
I was going to get there this afternoon... but I imagined it from a more complex point of view!! Good evening

 

[anfaloni]

gp. 17.12.15 17:23


try this way:

- in excel sets the point as a decimal separator
- in a cell of a free column write rectangle- in the right cell write =concatena(a1-(c1/2);",";b1-(d1/2)- in the right cell write =concatena(a1+(c1/2);",";b1+(d1/2)- select the three cells and recopy below
- select everything and ctrl+c
- in command line autocad ctrl+v (set first osnap=nes)


Annex 42675

Excuse me if I come in... I'm curious. baricentric coordinates are related to model space. we put the rectangles already drawn and that the positions are available as xyz coordinates on a excel. We put that he is working on the layout space where I have a window with perspective view of the various rectangles. is it possible to define from the layout space a tag, b with line that goes to inidate the respective rectangle? a sort of intelligent ballpointing
I don't know if I explained well... according to you can?

 

[Lollman]

I also find myself in the same situation as my eponymous, only that in addition to having to insert rectangles I should also treat them (solid paint) with different colors (red green yellow etc etc.).
I thought I'd add some columns to the excel table but I can't find how to select the rectangle you just created.

 

[GP.]

u (ultimo)

 

[Lollman]

Good morning gp.! thanks to the advice, but in the end I solved the problem with "cartage" and then "z" inserting the coordinates from me wanted.
Now point to the next step: insert the text! I ag an additional column with commando "testom", then 2 columns for the insert coordinates...but then I don't find the way to make it write the word in another cell.
ideas? I hope I've been clear.

 

[Lollman]

Does anyone have any ideas?

 

[GP.]

I don't know how to glue it to a command line.

if you just want to continue with this method "counternature" try to paste the cell with this instruction:
=concatena("(command ""_mtext"""""";cella1;"""""""";cella2;""""""""";cella3;""""""""""""""")where:
cell1 = cell name containing the coordinate 1
cell2 = cell name containing the coordinate 2
cell3 = cell name containing text string