Results 1 to 2 of 2

Thread: Extracted attributes from AutoCAD into excel pre-formatted spread sheet

  1. #1
    Woo! Hoo! my 1st post
    Join Date
    2018-05
    Posts
    1
    Login to Give a bone
    0

    Default Extracted attributes from AutoCAD into excel pre-formatted spread sheet

    I have multiple drawings we copy drawing number, description and from each drawings, and standard part and its description from the BOM in each drawing. And then paste into Pre-formatted excel spread sheet.
    1. Drawing number first, description.
    2. Standard parts and its description from the BOM in each drawing.
    I’m looking for a way to extract attributes drawing file number and title and to be able to extract standard parts or selected parts and description from BOM in AutoCAD drawing file from mutable drawings into pre-formatted Excel Spread sheet?
    I am using AutoCAD mechanical 2018.
    Is there away to do this procedure?
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    All AUGI, all the time
    Join Date
    2003-07
    Posts
    561
    Login to Give a bone
    0

    Default Re: Extracted attributes from AutoCAD into excel pre-formatted spread sheet

    I have started looking at a custom dataextraction, it will allow pick blocks, pick which attributes to use, save a data file for future use. At the moment it exports to a table with options like count common blocks for qty.

    It currently can have same block name with attributes broken down into a tier level and counted. It groups common attributes at the monent it is limited to 2 deep block name and 1st attribute, future version may go deeper with the attributes.

    BLKA door1 Gold 24
    BLKA door1 Brass 12
    and so on

    Bad news I am working on it and will probably release it as a shareware style product due to the amount of work involved. I would be interested in testing with mechanical so may get back in touch.

Similar Threads

  1. Use extracted attribute table to modify block's attributes?
    By Neo_Richard_Blake in forum AutoCAD Tables
    Replies: 3
    Last Post: 2012-02-17, 07:59 PM
  2. use extracted attribute table to modify block's attributes
    By Neo_Richard_Blake in forum AutoCAD LT - General
    Replies: 7
    Last Post: 2011-06-29, 05:41 PM
  3. Reference Excel Spread sheet in a userform combobox
    By mikeosborne in forum VBA/COM Interop
    Replies: 3
    Last Post: 2009-04-30, 06:22 PM
  4. Attached Excel Spread Sheet causes multiple copies
    By Ms. Serene in forum AutoCAD Plotting
    Replies: 9
    Last Post: 2005-05-06, 12:43 AM

Posting Permissions

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