field attributes and data extraction

[Anonymous]

Hi there, 

Need some help! I want to combine field attributes with data extraction. 

I currently have several fields connected to polylines that automatically give me areas.

Each polyline also has a MText with its name. 

So I have 2 Mtext:  One with "room number 4 " and another with area field (updated automatically).

What I want to do is to extract everything to an excel spreadsheet that could be updated automatically as well. 

Does anyone know how to do this?

TY!

[leothebuilder · Accepted solution]

You can use an autocad table and in a cell(s) insert a field that reflects the area of the polyline(s).

You could do the same for the room name.

If needed you can export the autocad table to excel

[BrianBenton]

Use the command DATAEXTRACTION. It will retrieve all data from any object in your file. Select the objects and the type of data you want to get. Then it will place it in a table in the AutoCAD file of in a CSV file. You can link the CSV file into AutoCAD as a table. 

Here is the Autodesk site about it.

[Anonymous]

Thank you for your help!

I didnt knew that it was possible to use field inside tables.. 🙂

[leothebuilder]

Yes, you can insert fields inside autocad table cells.

You can insert formulas inside table cells as well.

Autocad tables can be pretty powerfull, not like excel mind you.