Results 1 to 5 of 5

Thread: Linking AutoCAD Object data directly to Excel

  1. #1
    Active Member
    Join Date
    2004-12
    Posts
    80
    0 Did you find this post helpful? Yes

    Default Linking AutoCAD Object data directly to Excel

    Does anyone know of Cad software that links a rectangle or polygon to a spreadsheet such that when the area of the rectangle changes, the spreadsheet automatically updates with the new area?

    Thanks

  2. #2
    Wish List Manager BrenBren's Avatar
    Join Date
    2000-11
    Location
    150700
    Posts
    3,424
    0 Did you find this post helpful? Yes

    Default Re: Linking AutoCAD Object data directly to Excel

    Quote Originally Posted by Shizzjr
    Does anyone know of Cad software that links a rectangle or polygon to a spreadsheet such that when the area of the rectangle changes, the spreadsheet automatically updates with the new area?

    Thanks
    with AutoCAD 2008, you might be able to use fields and table to do this, but I am not 100% sure...

  3. #3
    Super Moderator david_peterson's Avatar
    Join Date
    2002-09
    Location
    Madison, WI
    Posts
    4,733
    0 Did you find this post helpful? Yes

    Default Re: Linking AutoCAD Object data directly to Excel

    Quote Originally Posted by Shizzjr
    Does anyone know of Cad software that links a rectangle or polygon to a spreadsheet such that when the area of the rectangle changes, the spreadsheet automatically updates with the new area?

    Thanks
    With both ACA/ADT & Revit you can create the schedule in the program that is linked to the space and will update automatically. I believe that you can export the schedule to Excel and I don't know if you can link it in real time.
    Dave Peterson

    Acad 2014 - Revit Structure 2013 & 2014 - Win 7 64 - i7-4770 4.5GHz 32GB Ram - Nvidia Geforce GTX 650
    "The more you know, the less you know, because the more you know you don't know". --M. Lin

  4. #4
    Active Member
    Join Date
    2006-02
    Location
    Croswell, Michigan
    Posts
    69
    0 Did you find this post helpful? Yes

    Default Re: Linking AutoCAD Object data directly to Excel

    You can copy excel information to your clipboard and then edit/paste special inside CAD, check link, then paste it. Although if you document increases in size, length or width then it will appear wrong inside CAD. At this point you'll have to copy and repaste again. If the document if final before you paste the first time, this will not be an issue.

    Have a Great Day
    William.Biskey

  5. #5
    I could stop if I wanted to
    Join Date
    2006-01
    Location
    Land of chocolate
    Posts
    228
    0 Did you find this post helpful? Yes

    Default Re: Linking AutoCAD Object data directly to Excel

    yes - my first guess would be fields and autocad tables as well - AC2008 has a few small extensions on tables, but think it should work in earlier versions as well - as long as you can insert a field into a table cell.

Similar Threads

  1. Linking data from excel to acad
    By csimpson468575 in forum AutoCAD General
    Replies: 1
    Last Post: 2012-02-21, 11:19 PM
  2. LINKING OBJECT DATA TO TABLES
    By knickers in forum AutoCAD Tables
    Replies: 3
    Last Post: 2009-08-10, 08:09 PM
  3. linking Excel to AutoCAD
    By domnita in forum AutoCAD General
    Replies: 10
    Last Post: 2006-05-16, 01:23 PM
  4. Linking AutoCAD Object Data Table to Access table
    By m.storey in forum AutoCAD Map 3D - General
    Replies: 0
    Last Post: 2006-05-02, 02:54 PM
  5. Linking Excel Sheet as OLE object
    By jmckiness in forum AutoCAD LT - General
    Replies: 5
    Last Post: 2005-08-25, 11:43 AM

Posting Permissions

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