See the top rated post in this thread. Click here

Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: Excel Table to AutoCAD Table.

  1. #21
    Member
    Join Date
    2011-01
    Location
    Belgium
    Posts
    14
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    I copied a excel table to an autocad table.
    All OK but...
    The text in this table is Calibri, color: 0,0,0.
    I can only change this after going into each cell again. Somebody who knows how to do this in one time? (AutoCAD 2016)

    Thanks!
    text.jpg

  2. #22
    Member
    Join Date
    2011-01
    Location
    Belgium
    Posts
    14
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    Somebody who knows how I can change the text color from an imported table to "bylayer" in stead of "0,0,0"?
    I can do this cell by cell, but that takes a long time.
    text.jpg

  3. #23
    Certified AUGI Addict cadtag's Avatar
    Join Date
    2000-12
    Location
    Cairo - no, not Illinois
    Posts
    5,069
    Login to Give a bone
    2

    Default Re: Excel Table to AutoCAD Table.

    look for a lisp routing called StripMText. That should cover it for you

  4. #24
    Woo! Hoo! my 1st post
    Join Date
    2013-03
    Posts
    1
    Login to Give a bone
    0

    Default Re: Excel Table to AutoCAD Table.

    Greetings,
    I followed the steps and everything worked except the table that the info was paste in is made by lines and text, and every cell has a single line text. I guess there is a system variable that I have to change, so it uses a standard table instead?
    I'm using Acad 2014 and OpenOffice.

    Quote Originally Posted by Capt. Computer Crasher View Post
    Yes. Using AutoCAD 2006 or above.

    1) Open the Excel file and Highlight all cells you want for the table.
    2) Right-click and pick copy. Collapse Excel.
    3) Open the AutoCAD drawing you want the table in.
    4) At the Top AutoCAD menu under EDIT pick PASTE SPECIAL
    5) At the paste special window make paste is mark and
    pick AUTOCAD ENTITIES and hit OK
    6) Pick an insert point.

    Have your table style you want set to current when to insert the table or change it later.

Page 3 of 3 FirstFirst 123

Similar Threads

  1. Replies: 11
    Last Post: 2022-11-30, 03:18 PM
  2. 2014: Autocad table from Excel Data Link
    By sovby254640 in forum AutoCAD General
    Replies: 4
    Last Post: 2014-08-07, 11:19 PM
  3. Trouble with Excel Information to AutoCAD Table
    By CADdancer in forum AutoCAD Tables
    Replies: 2
    Last Post: 2010-09-08, 08:21 PM
  4. How to import excel table to autocad
    By mandy in forum AutoCAD General
    Replies: 5
    Last Post: 2008-10-31, 06:32 PM
  5. Need Help, Trying to use excel formulas in AutoCAD Table
    By ReachAndre in forum AutoCAD General
    Replies: 2
    Last Post: 2008-08-04, 02:45 PM

Posting Permissions

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