+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Full Member
    Using
    AutoCAD 2005
    Join Date
    Sep 2007
    Posts
    54

    Default Convert multi-line MTEXT into CAD table with multiple cells

    Registered forum members do not see this ad.

    Is there a command or a .lsp that converts individual lines within a single MTEXT object into a CAD table with rows and columns? Unfortunately, Excel is not installed locally on my computer, so I cannot do a DATALINK. In Excel, I select and copy the cells to the clipboard. In AutoCAD, I PASTESPEC as text or unicode text. It appears as a single MTEXT.

    BLOCK LOT NUM AREA
    BLOCK 1 1 5770.67
    BLOCK 1 2 5300.01
    BLOCK 1 3 5336.69
    BLOCK 1 4 5280.00
    BLOCK 1 5 5280.00
    BLOCK 1 6 5280.00
    BLOCK 1 7 5280.00
    BLOCK 1 8 5280.00

    How do I convert this into a table in AutoCAD with cells and rows? I do not want to export back to Excel if I can avoid it.

    Thanks!

  2. #2
    Luminous Being
    Using
    Civil 3D 2016
    Join Date
    Dec 2005
    Location
    GEELONG AUSTRALIA
    Posts
    9,879

    Default

    Registered forum members do not see this ad.

    I posted a quick example of creating a table a few days ago the placement of the table values would be a read-line lisp to read the data file, breaking into columns look at www.Lee-mac.com I know he has a line read to a list (block 1 1 5770) which the example I posted uses.

    http://www.cadtutor.net/forum/showth...hp?92985-Table
    Last edited by BIGAL; 7th Jul 2015 at 11:01 am. Reason: link added
    A man who never made mistakes never made anything

Similar Threads

  1. Table Cells Appearing Outside of Table Borders
    By PaulS00 in forum AutoCAD 2D Drafting, Object Properties & Interface
    Replies: 1
    Last Post: 10th Jul 2014, 12:08 pm
  2. Convert Single line text to multi-line?
    By LKJR in forum AutoCAD 2D Drafting, Object Properties & Interface
    Replies: 13
    Last Post: 16th Jan 2013, 07:31 pm
  3. Link mtext to Excel cells
    By Organic in forum AutoCAD General
    Replies: 4
    Last Post: 8th Jan 2013, 02:36 am
  4. Formula SUM - cells in different Table
    By spasobn in forum AutoCAD 2D Drafting, Object Properties & Interface
    Replies: 14
    Last Post: 10th Sep 2010, 05:20 pm
  5. Can Lisp use mtext to make multi string mtext editor?
    By muck in forum AutoLISP, Visual LISP & DCL
    Replies: 1
    Last Post: 18th Dec 2006, 03:22 am

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts