How Can I Converte the geometrical data and attribute of a Block to excel?

[James7s]

Hi all,

I am currently trying to make my AutoCad more powerful as a tool of Engineer but not Draftmen (My boss never thing about it, I could only get a standard AutoCAD, not AutoCAD-EMP).

I want to make it a tool for myself to analysis the building system, with excel (and VBA)

 

The first tool I wanted to create is an underground drainage capacity analysis tool. But I meet the first difficulty, how can I automatically transfer the information inside CAD drawing to the excel?

 

Say, There is a drainage system with 2 manhole and 1 pipe,

the Manhole have 3 attribute : Name, Model, Level, (and the X-Y coordination),

I Create a Block with attribute "Name ; Model ; Level".

and then I insert the Blocks and place it in correct location inside the Layout Plan.

 

Then I have no idea, how can I create some script to "Scan" all Block inside the drawing and make an excel file with data like:

Block-Serial, X-Coor, Y-Coor, Rotated Angle, Name, Model, Level....

 

Could any one give me some idea to start my plan?

[ReMark]

Have you looked at DataExtraction?

[Mike_Taylor]

The Attibute extraction tool work like a charm (the DataExtraction ReMark has mentioned may be built up this, but I am using LT and cannot use it). You can export the Attribnute information based on attribute name, as well as block postion. You can then take the exported txt file and import into excel very quickly.

[James7s]

Opps~!!!!! That Exactly what I am looking for~!!!!!!! Thx a lot~!!!

 

I could then process on writing the excel file to analysis the data~