[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.
Interface with Excel
Tip# 1980 By Jeffery Sanders On 01-Sep-2004
3
Rated By 1 users Downloaded : 866
Categories : OLE Files
Software type : AutoCAD
Rename File To : Tip1980: XL.ZIP
XL.ZIP provides a set of tools for interfacing AutoCAD drawings with Microsoft Excel.

Jeffery was not content to share just the block library manager. Interface with Excel (Tip #1980) provides a set of tools for interfacing AutoCAD drawings with Microsoft Excel. Visual LISP programmers interested in a nice set of examples that can be used right away as handy utilities should look at Jeffery s work. If you re just starting into the concepts of interfacing Excel with AutoCAD through Visual LISP, you can learn a great deal from these well-documented and consistently structured programs. One handy aspect of this set is the Replace Text option that searches
out text objects in the drawing that are cell names in a spreadsheet, such as A1 or B12. When found, the cell name label is changed to match the value in the current spreadsheet at the same location.

 

 

Average Rating:
3


User comments