Forum Discussion
Link Autocad Polylines or Aligned Dimension to Excel Table
Hi guys, I need to count a list of autocad aligned dimension by orientations and to cut the time I wish to link from Exctract DATA the lenght of aligned dimensions in Azimut angles order from North to South. Do you know any easy way to accomplish this lists in an updtable way into Excel?
1 Reply
- NikolinoDEGold Contributor
I'm not familiar with AutoCAD...but with the help of the AI I found the following solution for you, maybe it will help you with your project.
You can use the "Data Extraction" tool in AutoCAD to extract the data from the aligned dimensions and create an Excel table that is linked to the AutoCAD drawing.
Here are the steps:
In AutoCAD, select the "Data Extraction" tool from the "Output" tab.
In the "Data Extraction" dialog box, select the "Create a new data extraction" option.
In the "Select objects" section, select the aligned dimensions you want to extract data from.
In the "Data" section, select the properties you want to extract, such as "Length" and "Angle".
In the "Destination" section, select "Excel" as the destination format.
Choose the Excel template that you want to use, or create a new one.
Click "Next" to review your settings, then click "Finish" to extract the data and create the Excel table.
Once you have the Excel table, you can sort it by the "Angle" column to order the data from North to South. You can also update the table automatically by using the "Update" button in the "Data Extraction" tool.
If you want to link the AutoCAD polylines to the Excel table as well, you can use the "Data Link" tool in AutoCAD to create a live link between the drawing and the Excel file. Then, any changes you make to the drawing or the Excel table will be updated automatically in both places.