See the top rated post in this thread. Click here

Results 1 to 9 of 9

Thread: Link text in Autocad with an Excel spreadsheet

  1. #1
    Member
    Join Date
    2012-04
    Posts
    13
    0 Did you find this post helpful? Yes

    Default Link text in Autocad with an Excel spreadsheet

    I am trying to use either 'Datalink' or 'Fields' to do the following:

    In Autocad, place a piece of text on the drawing and have it go after an excel spreadsheet, and only pull the information from certain cells in excel.

    There might be several rows that have the certain text to go after the other cells. If I place 'B-01' in Autocad I would like to have it pull all information
    from all (3) rows that start with 'B-01'

    Example:
    A Column B Column C Column D Column
    B-01 5" PVC UG
    B-01 3" PVC UG
    B-01 4" PVC UG
    B-02 8" EMT Surface
    B-03 4" Cond Flush


    Any help would greatly be appreciated.

  2. #2
    Forum Manager, Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    4,908
    0 Did you find this post helpful? Yes

    Default Re: Link text in Autocad with an Excel spreadsheet

    Does it have to be separate text entities or can it be in a table? If the latter, you can create a datalink to the xls and then use the datalink to populate a table.
    C:> ED WORKING....

  3. #3
    Member
    Join Date
    2012-04
    Posts
    13
    0 Did you find this post helpful? Yes

    Default Re: Link text in Autocad with an Excel spreadsheet

    I am trying to have the text in Autocad search for a certain cell (could be multiple cells with the same ID) in a excel spreadsheet and then grab certain cells in that row. See example below:

    So if I have "B-01" in cad, I would want it to grap the first B-01 and then grab the info from Column B and Column C, but from all (3) rows. Hopefully this makes sense.

    Example:
    A Column B Column C Column D Column
    B-01 5" PVC UG
    B-01 3" PVC UG
    B-01 4" PVC UG
    B-02 8" EMT Surface
    B-03 4" Cond Flush

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

    Default Re: Link text in Autocad with an Excel spreadsheet

    Are you trying to use Excel to create your schedules for you?
    There's a nifty little program called spanner that plays rather nice with an excel file. Imports at an updatable block.
    Just a thought.
    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

  5. #5
    I could stop if I wanted to Norton_cad's Avatar
    Join Date
    2007-05
    Location
    Bardwell Valley, Sydney, Australia
    Posts
    487
    0 Did you find this post helpful? Yes

    Default Re: Link text in Autocad with an Excel spreadsheet

    in Acad from the view drop down menu select OLE.
    Ohm's Law - Electricity follows the path of least resistance.

    Regards,

    Mark Norton,

  6. #6
    Member jc3cadd's Avatar
    Join Date
    2009-04
    Location
    Redford.Michigan
    Posts
    13
    0 Did you find this post helpful? Yes

    Default Re: Link text in Autocad with an Excel spreadsheet

    Having similar problem trying to paste sections of an Excel Worksheet then output drawing as an Adobe PDF
    the following messages comes from up version 2004

    PDFX ISO="15930-1:2001" COMPLIANT="false">

    PDF/X Compliance Report

    1. Color

    [Violation] RGB colorspace was found on the following pages:
    Page 1, Occurrences: 18

    Violations: The total found in this section was 18.

    2. Summary

    Warnings: The total found in this document was 0.
    Violations: The total found in this document was 18.
    The number of color problems found in this document was 18.

    This document does not pass PDF/X-1a compliance checks.

    </PDFX>

    %%[ Warning: Did not pass PDF/X compliance tests. No PDF file produced.

    Any suggestions to create the PDF from Auto Cad version 2004 Thanks

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

    Default Re: Link text in Autocad with an Excel spreadsheet

    Just a thought, but wouldn't the easy fix be to print as a dwf or a plt and then convert in Adobe?
    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

  8. #8
    Member jc3cadd's Avatar
    Join Date
    2009-04
    Location
    Redford.Michigan
    Posts
    13
    1 Did you find this post helpful? Yes

    Default Re: Link text in Autocad with an Excel spreadsheet

    So simply print a plot file then open in Adobe?
    Adobe could not open the plt.file

  9. #9
    Certified AUGI Addict jaberwok's Avatar
    Join Date
    2000-12
    Location
    0,0,0 The Origin
    Posts
    8,332
    0 Did you find this post helpful? Yes

    Default Re: Link text in Autocad with an Excel spreadsheet

    If you know that there are 18 objects on page 1 that are in an unacceptable colour, why not try identifying them and changing their colour.
    Could it be that easy? Probably not.
    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

Similar Threads

  1. Link text in Autocad with an Excel spreadsheet
    By wiegmanroger433258 in forum AutoLISP
    Replies: 5
    Last Post: 2012-05-11, 04:36 AM
  2. Linking Excel spreadsheet to AutoCAD
    By dmcdonald.156724 in forum AutoCAD General
    Replies: 6
    Last Post: 2008-01-09, 10:37 PM
  3. Replies: 2
    Last Post: 2007-08-25, 02:35 AM
  4. Replies: 2
    Last Post: 2007-04-12, 11:40 AM
  5. Excel Spreadsheet and AutoCAD 2005
    By daveng in forum AutoCAD Customization
    Replies: 1
    Last Post: 2005-09-09, 04:05 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
  •