+ Reply to Thread
Results 1 to 6 of 6
  1. #1
    Super Member Organic's Avatar
    Discipline
    Civil
    Using
    Civil 3D 2013
    Join Date
    Feb 2009
    Posts
    1,641

    Default Copy from Excel to AutoCad table (without using a DataLink)

    Registered forum members do not see this ad.

    I have a table in Excel (well several tables actually) that I want to copy the contents from and insert into an AutoCad table. I don't want it as an OLE object (as I need to be able to edit it in AutoCad later if needed) and I don't want it as a datalink either, so what is the best way to do this?

    I was trying to just copy the cells although kept getting all cells ending up in each row/column. I believe it is possible somehow as I am sure I have done it multiple times before although can't work out how to do it now.

  2. #2
    Super Member mdbdesign's Avatar
    Computer Details
    mdbdesign's Computer Details
    Operating System:
    XP PRO
    Computer:
    Homemade
    Motherboard:
    GIGABYTE G31M-ES2L
    CPU:
    INTEL CORE 2-QUAD-Q6600@2.4GHz
    RAM:
    4 GB
    Graphics:
    NVIDIA GeForce 9800 gt 1gb
    Primary Storage:
    WESTERN DIGITAL 500GB
    Monitor:
    2 - 21" COMPACQ
    Discipline
    Mechanical
    mdbdesign's Discipline Details
    Occupation
    Designing Engineer in Engineering Department
    Discipline
    Mechanical
    Details
    Pressure tanks Oil processing & storage equip. Steel mill equip. Telecom towers & equip. Wind turbine towers Power plant structures etc.
    Using
    AutoCAD 2012
    Join Date
    Jan 2007
    Location
    Courtice, Ontario, Canada
    Posts
    749

    Default

    Try attached lisp routines:
    First "Drawexcel" will draw simple lines and text based on excel file and than COT will convert this table to Autocad table.
    Attached Files
    Marek

  3. #3
    Super Moderator SLW210's Avatar
    Computer Details
    SLW210's Computer Details
    Operating System:
    Windows 7 PRO
    Computer:
    IBM Lenovo
    Motherboard:
    ACPI x86
    CPU:
    Pentium(R) Dual-Core CPU E5500 @ 2.80GHz
    RAM:
    4 GB RAM
    Graphics:
    Nvidia Quadro 600 1GB
    Primary Storage:
    300 GB
    Secondary Storage:
    650GB
    Monitor:
    ThinkVision 22"
    Discipline
    Multi-disciplinary
    SLW210's Discipline Details
    Occupation
    Design Draftsman
    Discipline
    Multi-disciplinary
    Details
    Mostly do drafting related to manufacturing. From doing site layouts with proposed updates, additions and renovations to be budgeted and submitted for bid, to updating and changing existing drawings to reflect maintenance and repair/revision work done on site.
    Using
    AutoCAD 2011
    Join Date
    May 2007
    Location
    South Florida, USA
    Posts
    9,092

    Default

    I use Paste Special and select "AutoCAD Entities".
    “A narrow mind and a fat head invariably come on the same person” Zig Zigler



  4. #4
    Super Member mdbdesign's Avatar
    Computer Details
    mdbdesign's Computer Details
    Operating System:
    XP PRO
    Computer:
    Homemade
    Motherboard:
    GIGABYTE G31M-ES2L
    CPU:
    INTEL CORE 2-QUAD-Q6600@2.4GHz
    RAM:
    4 GB
    Graphics:
    NVIDIA GeForce 9800 gt 1gb
    Primary Storage:
    WESTERN DIGITAL 500GB
    Monitor:
    2 - 21" COMPACQ
    Discipline
    Mechanical
    mdbdesign's Discipline Details
    Occupation
    Designing Engineer in Engineering Department
    Discipline
    Mechanical
    Details
    Pressure tanks Oil processing & storage equip. Steel mill equip. Telecom towers & equip. Wind turbine towers Power plant structures etc.
    Using
    AutoCAD 2012
    Join Date
    Jan 2007
    Location
    Courtice, Ontario, Canada
    Posts
    749

    Default

    Quote Originally Posted by SLW210 View Post
    I use Paste Special and select "AutoCAD Entities".
    Learn something new again. Thank you.
    Marek

  5. #5
    Forum Deity BlackBox's Avatar
    Using
    Civil 3D 2011
    Join Date
    Nov 2009
    Posts
    3,932

    Default

    Quote Originally Posted by SLW210 View Post
    I use Paste Special and select "AutoCAD Entities".
    1+

    ... Been doing this since Land Desktop 2009
    "Potential has a shelf life." - Margaret Atwood

  6. #6
    Super Member Organic's Avatar
    Discipline
    Civil
    Using
    Civil 3D 2013
    Join Date
    Feb 2009
    Posts
    1,641

    Default

    Registered forum members do not see this ad.

    Quote Originally Posted by SLW210 View Post
    I use Paste Special and select "AutoCAD Entities".
    Thankyou, this is exactly what I was looking for

Similar Threads

  1. Copy Excel Table Into AutoCAD Drawing
    By Bill Tillman in forum AutoLISP, Visual LISP & DCL
    Replies: 0
    Last Post: 25th Feb 2012, 04:21 am
  2. Datalink/Table with Excel not looking correct
    By hagan8 in forum AutoCAD General
    Replies: 2
    Last Post: 16th May 2011, 03:56 pm
  3. Datalink with Excel
    By widget in forum AutoCAD General
    Replies: 1
    Last Post: 15th Nov 2008, 11:35 am
  4. Text in datalink table wont scale with the table??
    By CADsince07 in forum AutoCAD General
    Replies: 0
    Last Post: 3rd Sep 2008, 03:08 pm
  5. DATALINK in 2008 for linking to Excel
    By chulse in forum AutoCAD Drawing Management & Output
    Replies: 6
    Last Post: 13th Aug 2007, 04:49 pm

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