[Search tip detail and code files using keywords, tip number, author name, etc ]
 
    For tip to function correctly, you must ensure that the downloaded file name matches the file name
    displayed in the Rename File To field. Please rename downloaded files when necessary.
Reading and Writing Data with Excel
Tip# 3041 By Perry Mason On 01-Dec-2008
4
Rated By 1 users Downloaded : 1257
Categories : File Data
Software type : AutoCAD 2008
Rename File To : attwnr.lsp
These LISP commands -- AttRead and AttWrite -- are attribute import and export utilities.

The LISP commands -- AttRead and AttWrite -- are attribute import and export utilities. AttWrite will create a comma-delimited file (CSV) that can be read and processed by Excel. The data extracted is for a single block instance. When it runs, you will be asked to pick the border or block for the extract. A CSV file is created that contains each attribute tag and value in a line. AttRead is the opposite. Select the block, and the tag/value file is read and the attribute values are changed based on the tag names. This simple routine is a great example of how you can pass data from drawings to other applications and get back other data.

 

Average Rating:
4


User comments