Results 1 to 5 of 5

Thread: import text and data from excel into autocad

  1. #1
    Member
    Join Date
    2007-02
    Posts
    29
    0 Did you find this post helpful? Yes

    Question import text and data from excel into autocad

    I'd like to enhance my use of AutoCAD at work and automate some of the repetitive tasks I currently do. I was looking for some help / product advice for setting up a template that could prompt me for a certain amount of input and / or directly grab info from an excel document?

    First of all, I would like to automatically reference / import customer info (name, address, phone number, APN, etc.) from an excel document in the same folder as my CAD file.
    From that same excel document, I'd like to reference design related parameters such as the type and quantity of equipment.

    Currently, I have all that info in an excel documents, salesforce, and elsewhere, but am manually entering it into my CAD file double clicking various blocks and MTEXT fields.
    I'd like to setup a cad template with links that pick up certain text and numerical data from specific excel fields.

    Example: Let's say a project is going to use 24 Sharp 170 Solar Panels
    So lets say I have an excel document that contains basic project information and looks like this.
    1
    A 24
    B 2
    C 12
    D SHARP 170
    D JANE DOE
    E 1234 KESTREL STREET
    F SAN JOSE, CA 95014
    G 408-234-9876

    In my CAD file, I currently need to manually enter this information into various locations using mtext and within certain defined blocks

    For instance, while the customer name and address are referenced onto every sheet from the title block (which is actually an xref to a separate title block DWG) I also have another block on the first page that contains the customer information name, address, phone, etc.

    is it possible to setup a template so that every spot within the CAD file where the customer name (for example) should go could be filled from a cell in my excel document (D1 in my above example)?

    The first three numbers in my example are:
    A1 - number of panels
    B1 - number of strings
    C1 - number of panels per string

    Similar to the customer info, I would like to plug this "2 strings of 12 sharp 170" project data into those places in my CAD file where I am currently entering it manually.
    There are blocks in the cad file that I would want to populate from specific fields within the excel document. I'd also like to drop those numbers into an mtext project description on the first sheet.

    Further automating my CAD environment, I'd like to be able to trigger a number of actions from either being prompted for user input, or "seeing" the trigger data in the excel document
    For instance, based on D1, Sharp 170, I would like to be able to automatically pick a "sharp 170" block from my library and drop that into the model space. I would like to automatically turn on a "Sharp 170" layer in my template which would make visible my sharp 170 data sheets which are referenced jpegs on that layer..

    I'm currently working with AutoCAD 2004, but management is considering an upgrade to AutoCAD 2008 LT. Is this a good or bad move considering my hopes of automating a lot of the data entry? I would consider built in autodesk functionality, an addon program, a plugin, or any other way of improving my productivity and minimizing the repetitive mindless double click / data entry. I was hired to be a "system designer" not a data entry clerk!

    What options would you recommend I look into to setup this type of AutoCAD to excel linking and possibly help me build an interactive template that could prompt for input and set up some things I've mentioned based on my input? I saw dotsoft has xl2cad and autocell and CadTool makes Office2CAD but neither seems like it would do quite what I'm after here.

    thanks in advance for any help you can offer..

    Cheers,
    Ethan

  2. #2
    Certified AUGI Addict rkmcswain's Avatar
    Join Date
    2004-09
    Location
    Houston
    Posts
    7,988
    0 Did you find this post helpful? Yes

    Default Re: import text and data from excel into autocad

    Are you using R2006 or later?
    If so, would you consider using Sheet Set Manager to store your project infomation rather than (or in addition to) Excel?

  3. #3
    All AUGI, all the time Avatart's Avatar
    Join Date
    2004-06
    Location
    here, watcha gonna do?
    Posts
    926
    0 Did you find this post helpful? Yes

    Default Re: import text and data from excel into autocad

    Going from full version 2004 to 2008LT would probably be a backward step for you. 2008 full version will do all of what you are after. You may be able to demonstrate to your management that shelling out for the full version actually represents a cost saving, as you will be automating all these tasks.

    You can link Excel data to Attributes via VBA and/or Visual Lisp, I do have some code, but it is better you get it from the original author, do a search for: "CADALYST 06/05 Tip2038: GETCELLS.lsp Get Excel Data (c) Jeff Sanders".
    ^^ Ceci n'est pas une post ^^


  4. #4
    Woo! Hoo! my 1st post
    Join Date
    2003-06
    Posts
    1
    0 Did you find this post helpful? Yes

    Default Re: import text and data from excel into autocad

    Quote Originally Posted by Avatart View Post
    Going from full version 2004 to 2008LT would probably be a backward step for you. 2008 full version will do all of what you are after. You may be able to demonstrate to your management that shelling out for the full version actually represents a cost saving, as you will be automating all these tasks.

    You can link Excel data to Attributes via VBA and/or Visual Lisp, I do have some code, but it is better you get it from the original author, do a search for: "CADALYST 06/05 Tip2038: GETCELLS.lsp Get Excel Data (c) Jeff Sanders".
    Search where, please?

    We/I have ACADE 2009 and would be EXTREMELY interested in how to import input/output (I/O) addresses into ACADE from Excel.

    Thanks in advance for some additional information!
    scj

  5. #5
    Certified AUGI Addict rkmcswain's Avatar
    Join Date
    2004-09
    Location
    Houston
    Posts
    7,988
    0 Did you find this post helpful? Yes

    Default Re: import text and data from excel into autocad

    Quote Originally Posted by sheldon_johnston View Post
    Search where, please?
    http://cadtips.cadalyst.com/

    Specifically... http://cadtips.cadalyst.com/node/tip...words=getcells

Similar Threads

  1. How to import excel table to autocad
    By mandy in forum AutoCAD General
    Replies: 5
    Last Post: 2008-10-31, 06:32 PM
  2. Import data from MS Excel into a drawing
    By Jack Cheong in forum AutoCAD General
    Replies: 6
    Last Post: 2006-10-18, 04:58 PM
  3. Export and Import to Excel and AutoCAD
    By avinash00002002 in forum AutoLISP
    Replies: 3
    Last Post: 2006-10-18, 12:04 PM
  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, 05:06 PM
  5. 8.1/N - Import Excel room data to Schedules - O
    By dbaldacchino in forum Revit Architecture - Wish List
    Replies: 1
    Last Post: 2006-01-19, 06:02 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
  •