connect excel cells with object properties

[Sagacino]

Hello everyone I am new to the forum and I am at my first message. I wanted to ask you if there is a function/macro or something that allows you to connect the data of an excel table inserted in the drawing with the properties of objects.
I'll explain better.
is it possible to create a table excel whose data is linked to the properties (e.g. a line) of an object and that therefore the modification of such data consequently produces the modification of the associated object?
in other words I imagine having a cell of the excel table connected to the length of a line; is there something that if I change the value contained in the cell automatically changes the length of the drawn line?
Thank you all.

 

[User1]

Yes! you should create objects or graphic elements with the dimensions that interest you, after tools/extract attributes and with the wizard create the .xls file, include xrifs. Once you do everything, when you start the program, use xrifs to insert objects, xrif=outside references!

 

[Sagacino]

Thank you for the answer. However if you do not mind I would like you to explain a little better.xrif is an associated reference and can only be a dwg or image for which how do I associate an excel sheet?
Thank you.

 

[User1]

well, I will try to explain to you starting from the origins of the concept that is not difficult! Remember that in order to use a xrif, the file must be external to the file in here you are creating it, in short, you can save it on a pendrive or any folder in the pc. the passage to save an object to be used later as an external reference is: to create an object, mbloc keyboard syntax from the sending, select the object by giving it a name, saving it can be used as xrif ( xrif keyboard syntax). do not confuse you with the passage: draw-block-create, in this case create a block that forms part of the file in which you are creating it, you will not be able to use it with xrif. Once you do this, while you are drawing there will be the need to insert a block with external references, which at the time when you decide to change it (the object that is the xrif block), will receive the changes even in the design in which you inserted it. so while you are working, you want to inherit the block with external references, you will write the syntax: xrif and the window will open where you can decide one of the objects you created. Try it and then let me know!

 

[User1]

After doing this, you can extract the attributes of a file by passing: tools- extract attributes or extract data, creating with the guided steps an exel sheet. If you use the steps I told you before you should understand that an external reference can also be a sheet of exel. I suggest you do some tests otherwise you will not notice how these commands work! !

 

[Sagacino]

Thanks you were very kind now I try if I have problems I notice you!

 

[User1]

Let me know!

 

[GP.]

I wait, too, I'm curious. . .

 

[Giuseppe Mauro]

I think you're gonna have to wait a long time. . .

the question of sagacino does not correspond to the answer of tonyprog:smile:

sagacino would like to edit an excel file and would like the design to change accordingly

tony makes him create an excel by extracting attributes.

premitting that an entity (plline circle line that is) does not possess by itself attributes (which are not those withdrawable via lisp), I do not see an extraction attributes on a group of lines which excel file can ever produce.

and then this extraction is from autocad to excel, but not on the contrary
Imagine then change a cell excel, and go into autocad and find the modified design. . .

Of course you could, perhaps with a lisp (which I see beautiful complex) imagine a certain correlation, but I see it hard, it would be to replicate the acad dbase to make sure that at every opening the data of entities is taken from the excel file..

What do you think?

 

[Sagacino]

actually giuseppe is right I tried the procedure but as it says g. I create an excel file by extracting the data from the object and changing the table inserted in the drawing or excel file does not produce any change on the original design. It's true that I can connect an excel file to a drawing but the operation stops there...

 

[GP.]

What do you think?

just like you, from here my curiosity...:smile:

 

[zanluca]

Good morning guys, I'm also new to the forum and I have more or less the same doubt.
I'll explain my case: I have to find a way to create a file to draw boiserie, through the creation of blocks and attributes I have created a design that I can change to my liking according to the size required by the customer. from this design I have to pull out a distinct base by extracting the size from the drawing and the related formulas. e.g. the standard panel has a size of 900x900mm finished and in the table I have 2 fields (finished panel 900x900 and panel without leather coating 898x898, result from the fx formila) I would like to know if you can connect the quota to the table. so that if I change the blocks or add elements to the drawing you will also upgrade the table. Thank you.

 

[zanluca]

Good morning guys, I'm also new to the forum and I have more or less the same doubt.
I'll explain my case: I have to find a way to create a file to draw boiserie, through the creation of blocks and attributes I have created a design that I can change to my liking according to the size required by the customer. from this design I have to pull out a distinct base by extracting the size from the drawing and the related formulas. e.g. the standard panel has a size of 900x900mm finished and in the table I have 2 fields (finished panel 900x900 and panel without leather coating 898x898, result from the fx formila) I would like to know if you can connect the quota to the table. so that if I change the blocks or add elements to the drawing you will also upgrade the table. Thank you.