Results 1 to 6 of 6

Thread: Importing excel into AutoCAD 2006 & 2005

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    100 Club MikeM4OSU's Avatar
    Join Date
    2004-02
    Location
    Tulsa, Oklahoma
    Posts
    195
    Login to Give a bone
    0

    Default Importing excel into AutoCAD 2006 & 2005

    I am now trying to work on some of the things that I learned at AU. I am trying to import an excel spreadsheet into AutoCAD 2006 I have set up excel (office 2000) like the class at AU2004 had suggested in the Ups and Downs of Tables in AutoCAD 2005 class. I cannot get the cells to come over as they look in excel. All the widths and heights come in the same across the whole table, and any cells that I have merged in excel do not come into Acad table merged. Confused to the max. Any advise would be appreciated greatly.

    Thanks

  2. #2
    The Silent Type RobertB's Avatar
    Join Date
    2000-01
    Location
    Seattle WA USA
    Posts
    5,859
    Login to Give a bone
    0

    Default Re: Importing excel into AutoCAD 2006 & 2005

    A posted sample of your spreadsheet would help us help you.

  3. #3
    100 Club MikeM4OSU's Avatar
    Join Date
    2004-02
    Location
    Tulsa, Oklahoma
    Posts
    195
    Login to Give a bone
    0

    Default Re: Importing excel into AutoCAD 2006 & 2005

    Ok, here is a sample excel file of a panel schedule that I would like to import into a AutoCAD 2006 drawing. I am using Excel-Office 2000 and AutoCAD 2006. I have discovered that importing from Excel-Office 2003 works better, but we do not have Excel-Office 2003 on our cad machines. I will need to find some time to test further on the engineer's machine when he is not using it. Any help with the Excel-Office 2000 version would be greatly appreciated.
    Attached Files Attached Files

  4. #4
    The Silent Type RobertB's Avatar
    Join Date
    2000-01
    Location
    Seattle WA USA
    Posts
    5,859
    Login to Give a bone
    0

    Default Re: Importing excel into AutoCAD 2006 & 2005

    Well, you answered your own question. That was what I ws going to test. There were some improvements in Excel XP & 2003 in regards to AutoCAD interoperablity.

  5. #5
    Active Member amy.stuart's Avatar
    Join Date
    2004-05
    Location
    nebraska
    Posts
    88
    Login to Give a bone
    0

    Default Re: Importing excel into AutoCAD 2006 & 2005

    okay kind of the same topic so i will see if i can get help here... But we are coming from Excel 2003 into 2006 AutoCAD. Does AutoCAD 2006 read excel formulas?

    I am having a hard time reading the formulas. AutoCAD just reads out the formula the way it is written and not actually formulating it.

    Thanks.

  6. #6
    Active Member amy.stuart's Avatar
    Join Date
    2004-05
    Location
    nebraska
    Posts
    88
    Login to Give a bone
    0

    Default Re: Importing excel into AutoCAD 2006 & 2005

    Quote Originally Posted by amy.stuart
    okay kind of the same topic so i will see if i can get help here... But we are coming from Excel 2003 into 2006 AutoCAD. Does AutoCAD 2006 read excel formulas?

    I am having a hard time reading the formulas. AutoCAD just reads out the formula the way it is written and not actually formulating it.

    Thanks.

    Okay we found the answer... It has to be a simplified formula. We had one that AutoCAD just couldn't read... Had too many "if'''s in there.

Similar Threads

  1. Excel with ABS 2005 or 2006
    By josh.107083 in forum AMEP General
    Replies: 3
    Last Post: 2006-05-17, 01:46 PM
  2. Importing Excel 97 to Autocad 2005
    By eddieb99 in forum AutoCAD General
    Replies: 3
    Last Post: 2005-11-01, 11:35 PM
  3. Importing MD 2005 2D fastener library parts into AutoCAD 2005
    By garyp.97584 in forum AutoCAD General
    Replies: 2
    Last Post: 2005-10-18, 09:43 PM
  4. Importing Excel Spreedsheets to AutoCAD 2005?
    By stephen.coff in forum AutoCAD General
    Replies: 2
    Last Post: 2005-08-29, 12:23 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
  •