topic Extract Square dimensions to Excel in AutoCAD for Mac Forum

Extract Square dimensions to Excel

Anonymous — Sun, 09 Aug 2020 16:41:59 GMT

Hallo

I am often drawing multiple squares and rectangles in Autocad (Mac-version) that I need for cutting lists. I am looking for a simple and fast way to extract the names and dimensions of several squares to an Excel Sheet. I have been trying with -ATTEXT but it does not seem possible to output the dimensions. If you have a good technique I would appreciate it a lot.

Best, Anja

Input

Preferred output

Re: Extract Square dimensions to Excel

maxim_k — Mon, 10 Aug 2020 04:00:57 GMT

Welcome to Autodesk Forums!

Hi Anja,

Here one of the ways, which will work on Mac:

- create a pair of blocks - one Dynamic block with rectangle and another one block with attributes.

- the Dynamic block should contain two parameters "Distance1" and "Distance2" in X and Y directions, you apply stretch action to them in order to be able to change width and height of rectangle

- the attributes in second block will include: the name of rectangle and two attributes with default values as FIELDs. These FIELDs should read "Distance1" and "Distance2" properties of rectangle Dynamic block. You can also assign "Invisible" property to these FIELD attributes, if you don't want to see them in the drawing.

- now you have to copy this pair of blocks together in order to get new rectangles, change rectangles dimensions.

Finally you can use -ATTEXT command to create CSV file, which you can open in Excel.

I attached a drawing with sample pair of blocks and an attribute extraction template file - test.txt

Try how it works. Be sure to copy both rectangle and block with attributes in order to get the correct result.

Re: Extract Square dimensions to Excel

Anonymous — Mon, 10 Aug 2020 16:26:11 GMT

Hi Maxim

Thank you very much your example, it works perfectly and is exactly what I need!

I have been trying to do it myself following your instructions and example but don't manage to do this:

and maybe this (although it might be self explanatory when I get the above step right):

- now you have to copy this pair of blocks together in order to get new rectangles, change rectangles dimensions.

Can you elaborate more on that? I don't seem to find any use full examples online.

Thank you, Anja

Re: Extract Square dimensions to Excel

maxim_k — Mon, 10 Aug 2020 20:09:34 GMT

Anja,

@Anonymous wrote:

Hi Maxim

Thank you very much your example, it works perfectly and is exactly what I need!

I have been trying to do it myself following your instructions and example but don't manage to do this:

- the attributes in second block will include: the name of rectangle and two attributes with default values as FIELDs. These FIELDs should read "Distance1" and "Distance2" properties of rectangle Dynamic block.

and maybe this (although it might be self explanatory when I get the above step right):

- now you have to copy this pair of blocks together in order to get new rectangles, change rectangles dimensions.

Can you elaborate more on that? I don't seem to find any use full examples online.

Thank you, Anja

Please look at the attached screencast. It should answer your questions.