Juan Villarreal is back this month with a very nice routine. Years ago, before there were table objects in AutoCAD, we made tables with lines and text. Often it would be much easier to edit that data in a spreadsheet than in AutoCAD. Juan's routine allows you to take those old collections of lines and text and export them to Microsoft Excel. Once the data is in Excel, you can easily import it back into AutoCAD as a table using data links.
Start by loading the LISP file, run the command TE, and then select the objects. The routine will evaluate the data and perform the export, opening Excel and writing the data with no further input from the user. Horizontal and vertical merged cells are even supported! Juan has supplied a sample drawing containing some "exploded" tables for demonstration use. |