Results 1 to 9 of 9

Thread: Bring Excel data in AutoCAD drawings

  1. #1
    Member
    Join Date
    2005-11
    Posts
    13
    Login to Give a bone
    0

    Default Bring Excel data in AutoCAD drawings

    Hello!
    I am currently creating electrical wiring diagrams. I take all the information from certain columns in Excel and retype the info. in the AutoCAD drawing. A coworker has seen someone (in the past) have the info. in Excel automatically appear in the AutoCAD drawings, after some basic wire diagrams were created I am sure. So, I am trying to find anyone who may know how to do this or what steps to take. This would speed up drafting immensely!

    Thanks for your help!
    Amanda

  2. #2
    Member
    Join Date
    2005-11
    Posts
    13
    Login to Give a bone
    0

    Default Re: Bring Excel data in AutoCAD drawings

    Also, it may be similar to ddatte to change info. in a titleblock, but I did not set that up so I am not sure how that works.

  3. #3
    The Silent Type Mike.Perry's Avatar
    Join Date
    2000-11
    Posts
    13,656
    Login to Give a bone
    0

    Default Re: Bring Excel data in AutoCAD drawings

    Hi Amanda

    Please note I have *moved* this thread from the AutoCAD Fields forum to this one, as I feel this particular forum is a more appropriate place for such a topic.

    Thanks, Mike

    Forum Manager

  4. #4
    The Silent Type Mike.Perry's Avatar
    Join Date
    2000-11
    Posts
    13,656
    Login to Give a bone
    0

    Default Re: Bring Excel data in AutoCAD drawings

    Hi

    For starters, take a look at the links offered in THIS post...

    Depending on exactly what you want to do with the data from Excel once it is in AutoCAD, you could also look at OLE and AutoCAD Tables.

    Have a good one, Mike

  5. #5
    100 Club charlie.bauer341340's Avatar
    Join Date
    2002-05
    Location
    Here, because I'm not all there
    Posts
    141
    Login to Give a bone
    0

    Default Re: Bring Excel data in AutoCAD drawings

    If you want to bring the Excel spread sheet directly into AutoCAD the same way it appears in Excel there are several 3rd party programs that do a very good job of this, but once it is in AutoCAD you can do nothing with it. If this is what you want the one I use is AutoXLS

  6. #6
    Administrator rkmcswain's Avatar
    Join Date
    2004-09
    Location
    Earth
    Posts
    9,805
    Login to Give a bone
    0

    Default Re: Bring Excel data in AutoCAD drawings

    Quote Originally Posted by cosnobum02
    Hello!
    I am currently creating electrical wiring diagrams. I take all the information from certain columns in Excel and retype the info. in the AutoCAD drawing. A coworker has seen someone (in the past) have the info. in Excel automatically appear in the AutoCAD drawings, after some basic wire diagrams were created I am sure. So, I am trying to find anyone who may know how to do this or what steps to take. This would speed up drafting immensely!

    Thanks for your help!
    Amanda
    Are you talking about importing Excel tables into AutoCAD? If so, take a look at XL2CAD.

    If that is not what you are talking about, then you might have a look at AutoCELL.
    R.K. McSwain | CAD Panacea |

  7. #7
    Member
    Join Date
    2005-11
    Posts
    13
    Login to Give a bone
    0

    Default Re: Bring Excel data in AutoCAD drawings

    I don't want to import the excel table as is, I want to have info. from the Excel table appear in certain locations in the CAD dwg.

  8. #8
    All AUGI, all the time Avatart's Avatar
    Join Date
    2004-06
    Location
    Upsidedown in dreamtown
    Posts
    928
    Login to Give a bone
    0

    Default Re: Bring Excel data in AutoCAD drawings

    Quote Originally Posted by cosnobum02
    I don't want to import the excel table as is, I want to have info. from the Excel table appear in certain locations in the CAD dwg.
    This is something that want to do too, have some sort of simple linking device that allows you to live link to a cell in a spreadsheet as a Field in text, for example.

  9. #9
    Member
    Join Date
    2005-11
    Posts
    13
    Login to Give a bone
    0

    Default Re: Bring Excel data in AutoCAD drawings

    OK, I've got items to link. Now, I just need to edit the text somehow to match and print correctly, and hide the box that shows behind the text.

Similar Threads

  1. Replies: 3
    Last Post: 2014-06-09, 01:12 AM
  2. Bring data to Excel from AutoCAD
    By cparvez in forum Dot Net API
    Replies: 1
    Last Post: 2014-05-27, 08:46 PM
  3. Replies: 2
    Last Post: 2007-04-12, 11:40 AM
  4. Export/Import Text, Attribute data, tags etc from drawings and Excel
    By Subramanyam.Perivenkata in forum AutoLISP
    Replies: 3
    Last Post: 2006-03-23, 06:06 PM
  5. Bring AutoCAD DText into Excel
    By bzrqmy in forum AutoCAD General
    Replies: 3
    Last Post: 2005-12-08, 06:09 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
  •