[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 Table of Lines and Text to Excel
Tip# 4276 By Juan Villarreal On 24-Mar-2014
3.333335
Rated By 3 users Downloaded : 73337
Categories : Tables, Export
Software type : AutoCAD 2014
Rename File To : TableExport/,TableExport/Original.dwg,TableExport/TE_TableExport.lsp
Move table object data into Excel for easy editing.

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.

 

Average Rating:
3.333335


User comments
Comment by nakarmi,dks
Posted on 2015-09-08 04:15:16
Hi Juan, first of thank you for the lisp routine however i found that it doesn't work for all the schedules. In some files the text are deleted in autocad whereas on other drawings the border lines are not exported. i've attached the schedule in which i've tried exporting. Can you help me out here, i would really appreciate your effort. :) Regards