[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.
AutoCAD Excel Interface
Tip# 2107 By Q.J. Chen On 01-Apr-2006
4
Rated By 2 users Downloaded : 4206
Categories : Export, OLE Files
Software type : AutoCAD
Rename File To : Tip2107: acad table to excel.lsp
Transfer text information stored in a grid layout (table) into an Excel worksheet by just locating the corners of the table.

AutoCAD Excel Interface (Tip #2107) comes from Q.J. Chen of China and is the perfect answer for a topic that appeared just recently in the Hot Tip Harry forum. The purpose of this utility is to transfer text information stored in a grid layout (table) into an Excel worksheet by just locating the corners of the table. Load the LISP code and type B2E to activate the function. It will request two points representing the corners of the table (upper left and lower right). The rest is automatic. The text inside the grid is selected and sent to an Excel worksheet. This function works best when Excel is already open and running before starting the command. An animated GIF shows the operation of the function set included with the download file for this tip. The animated GIF is very interesting to watch because it shows the Chinese versions of AutoCAD and Excel. Harry picked this one as the top tip of the month right away!

 

 

Average Rating:
4


User comments