Results 1 to 5 of 5

Thread: Excel and Datalink formatting

  1. #1
    Member
    Join Date
    2006-12
    Location
    Seattle
    Posts
    31
    Login to Give a bone
    0

    Default Excel and Datalink formatting

    Maybe someone here can help me with a problem I am having.

    I want autocad to use the cell formatting from excel so that everytime a schedule is inserted, I don't have to make modifications. I have attatched an example of an excel file that has some cells with borders and some without. When I bring it into autocad, all of the cells show up and print. Am I missing something here cause xell 2 cad makes this VERY simple and I was hoping that autodesk had replaced my need for xell 2 cad.
    Attached Files Attached Files

  2. #2
    Certified AUGI Addict jaberwok's Avatar
    Join Date
    2000-12
    Location
    0,0,0 The Origin
    Posts
    8,570
    Login to Give a bone
    0

    Default Re: Excel and Datalink formatting

    Hi. Search these forums for "excel table formatting".
    There is a lot of information there including a link to an ATP course.
    John B

    "You can't convince a believer of anything; for their belief is not based on evidence, it's based on a deep-seated need to believe." - Carl Sagan

  3. #3
    Member
    Join Date
    2006-12
    Location
    Seattle
    Posts
    31
    Login to Give a bone
    0

    Default Re: Excel and Datalink formatting

    That's why I posted and gave an example. None of the info from the forums have solved my problem. If you download the file I posted and try to link it into acad, you will see all of the cells even though in excell they are not displayed. Now this is not the only format of a schedule, I have diffuser schedules, boiler schedules, Ac schedules that are all differant formats. And I should not have to create a table style for each individual table. I think that Autodesk has once again delivered a half-baked product.

  4. #4
    Member
    Join Date
    2006-12
    Location
    Seattle
    Posts
    31
    Login to Give a bone
    0

    Default Re: Excel and Datalink formatting

    TO be more specific, I have a schedule with cells that have borders displayed and some cells have the borders turned off. When I data link, all of the borders get turned on.

  5. #5
    Member ablanchard's Avatar
    Join Date
    2002-12
    Posts
    27
    Login to Give a bone
    0

    Default Re: Excel and Datalink formatting

    If this has not been answered already. Create a simple table with the borders for Title, Header and Data turned off. Data Link your excel file to that table. The drawing looks like there are borders but they don't print.

Similar Threads

  1. Datalink formatting
    By sblackburn in forum AutoCAD General
    Replies: 6
    Last Post: 2016-03-23, 07:29 PM
  2. 2014: Excel Datalink cell text format
    By dkennard in forum AutoCAD General
    Replies: 0
    Last Post: 2015-02-06, 03:08 AM
  3. 2015: DATALINK Command - Excel Datalink without Dialog Box
    By ddowdy in forum AutoCAD General
    Replies: 0
    Last Post: 2014-12-13, 02:39 PM
  4. 2012: I cannot datalink excel table
    By Macieto in forum AutoCAD General
    Replies: 2
    Last Post: 2011-12-22, 12:05 PM
  5. Replies: 1
    Last Post: 2009-06-16, 09:39 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
  •