[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.
Export Text from a Drawing to an Excel Spreadsheet
Tip# 3030 By Pedro Ferreira On 01-Dec-2008
2.5
Rated By 2 users Downloaded : 14552
Categories : Export
Software type : AutoCAD 2008
Rename File To : txt2xls.LSP
Export Text from a Drawing to an Excel Spreadsheet C:Txt2Xls is a LISP command for exporting text from a drawing to an Excel spreadsheet.

Export Text from a Drawing to an Excel Spreadsheet C:Txt2Xls is a LISP command for exporting text from a drawing to an Excel spreadsheet. This command will attempt to locate text in columns based on your selection criteria. Start by loading the LISP code and typing Txt2Xls at the Command line. The program first will attempt to link with the Excel application, which must exist on your computer. Next, the program will ask you to select text using two points to define a rectangular window. Only text objects will be selected inside this window. In the next step, the program asks you to select to sample text objects from the same column. These text objects will be used to determine a deviation factor for locating columns of text (that way your text does not have to be exactly lined up, just close). The rest is automatic as the text objects are extracted and written to a new workbook inside Excel. This program is very cool when it works, but make sure you have Excel installed. You might need to edit the code yourself for specific versions of Excel -- for help, visit Cadalyst’s Hot Tip Harry-Help Discussion Forum.

 

Average Rating:
2.5


User comments
Comment by O'Flaherty,Mike
Posted on 2010-01-08 10:36:44
Extremely fussy about the spacing of the text. If the rows and columns aren't perfectly aligned it messes up unless you manually change variables (and can still mess-up).