[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 2234: AutoCAD Tables to Excel
Tip# 2234 By Douglas Barense On 01-Aug-2007
Rated By 3 users Downloaded : 4141
Categories : OLE Files, Object Data, Import, File Data, Export
Software type : AutoCAD
Rename File To : Tip 2234: BOM to CSV.lsp
Converts tables of AutoCAD text to a comma-delimited file for loading into Microsoft Excel and other spreadsheet programs.

Tip 2234: AutoCAD Tables to Excel
And finally, the top tip of the month is AutoCAD Tables to Excel by Doug Barnes. This utility quickly converts tables of text in an AutoCAD drawing to a comma-delimited file suitable for loading directly into Microsoft Excel and other spreadsheet programs. After loading the LISP code into AutoCAD, type Bom at the Command line. You will be prompted to locate corner points surrounding the table of text, and the rest is automatic. If text is found, the utility creates a file named BOM.CSV in the same folder as the drawing. This file is an ASCII text file in which each column is separated by a comma and each row appears as a new line -- perfect for importing into a spreadsheet. If you want to see how to sort data points and use filters, open the code to take a look under the hood in this function set. Great stuff, Doug!



Average Rating:

User comments

Log In