Data extraction from ACAD attributes to excel in tabular format using LISP

[Anonymous]

Hello team,

We currently have drawing with Electrical Zones as attributes of a block which has the device name as another attribute on the drawing.

We need to extract all the zones created in the ACAD sheet to Excel as well as the device it is on.

There are around hundreds of Electrical Zone we need to extract, so looking for a sample lisp program to extract the Electrical Zone Name and device name attributes to excel.

[dbroad]

Must you use LISP?  The dataextraction command is quite effective and maintains a link which can be updated.

[dennis · Accepted solution]

Check out Lee Mac's Global Extractor at:

http://lee-mac.com/macatt.html

That will get you well along the way for a start.

And others:

http://www.lee-mac.com/attributefunctions.html

[Anonymous]

Thank you! By any chance do you have any useful links to format the way to edit in excel

[Anonymous]

Thankyou!

[dennis]

You could write it out a simple text file, comma-delimiter and instead of the ending TXT, use CSV.  Then Excel will open it in columns.

Again from Lee Mac:

http://www.lee-mac.com/writecsv.html