[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.
Tip 2239: Layer Table to Excel
Tip# 2239 By Pedro Ferreira On 01-Sep-2007
3.5
 Rated By 2 users Downloaded : 1083
Categories : Logs, File Data, Layer Tools, Layers
Software type : AutoCAD
Rename File To : Tip 2239: layers2xls.lsp
layers2xls.lsp creates a Microsoft Excel worksheet that contains a complete dump of the current drawing's layer table.

Tip 2239: Layer Table to Excel
Pedro Ferreira's Layer Table to Excel utility creates a Microsoft Excel worksheet that contains a complete dump of the current drawing's layer table. For this custom command to work, you must have Excel installed on your computer, and it should be up and running with a new, blank worksheet. Load the LISP file, then type L2X to activate. The rest is automatic. In the LISP code, Excel is connected and a new worksheet started. Visual LISP VLAX object access is used to retrieve the layer table details, and those details are written directly to the worksheet cells using Excel object access. This utility is a great example of how to connect object systems such as Excel to AutoCAD through Visual LISP.

 
 

Average Rating:
3.5


User comments