Results 1 to 4 of 4

Thread: Export/Import Text, Attribute data, tags etc from drawings and Excel

  1. #1
    Woo! Hoo! my 1st post
    Join Date
    2003-12
    Location
    India
    Posts
    1
    Login to Give a bone
    0

    Question Export/Import Text, Attribute data, tags etc from drawings and Excel

    Hi,
    I am looking for a Program which can export the general text, attribute data, tags etc from drawings to excel and back from excel to autocad drawings. The key things are I want to export the data from single or by selecting multiple drawings. after the data is exported, basically looking at one drawing data in one sheet i.e. 10 drawings data in 10 sheets of one single excel file. Then i will be doing some changes in the values and want to import back the changed values in the same fashion as Export. The export attribute function when selected from the Drop menu exports only in .txt fashion and when I use EATTEXT option it does not arrange in the order i want which is creating problems, and still after I change the values in .xls file and import back it does not work properly.

    Looking for a early response.


    Regards

  2. #2
    I could stop if I wanted to
    Join Date
    2002-02
    Location
    Kansas
    Posts
    487
    Login to Give a bone
    0

    Default Re: Export/Import Text, Attribute data, tags etc from drawings and Excel


  3. #3
    Member
    Join Date
    2006-02
    Posts
    13
    Login to Give a bone
    0

    Default Re: Export/Import Text, Attribute data, tags etc from drawings and Excel

    The thread "Atribute Extraction Routine" in this forum might get you started. The program listed there lets you select a list of blocks and a list of tags to extract info from.
    The "excell to Autocad" part I don't know how to do.

  4. #4
    I could stop if I wanted to Hammer.John.J's Avatar
    Join Date
    2015-09
    Location
    Springfield, MA
    Posts
    491
    Login to Give a bone
    0

    Default Re: Export/Import Text, Attribute data, tags etc from drawings and Excel

    the quickest way i have found to do this is with "paste special"
    copy the items you want from excel to the clipboard, and "paste special" in cad using %product as your method, it'll bring the grid text, everything in.

    however it is not dynamically updated and i don't believe there is a way to do that except with ole objects.

Similar Threads

  1. 2014: DB Attribute and Dimension Excel Export
    By Joe695170 in forum Dynamic Blocks - Technical
    Replies: 0
    Last Post: 2015-03-25, 05:51 PM
  2. Changing attribute tags in multiple drawings
    By caburke in forum AutoCAD General
    Replies: 5
    Last Post: 2012-05-01, 05:10 PM
  3. Help needed with Attribute extraction and import into MS Excel
    By Lee Buckmaster in forum Productstream - General
    Replies: 0
    Last Post: 2012-04-30, 08:23 PM
  4. import text and data from excel into autocad
    By elipman in forum AutoCAD General
    Replies: 4
    Last Post: 2008-12-22, 08:04 PM
  5. 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

Posting Permissions

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