extract BOM data to Excel

Discussion in 'SolidWorks' started by Steve Reinisch, Nov 22, 2005.

  1. Is it possible to extract BOM attributes from assy or part files to an Excel
    spread sheet?

    Steve R
     
    Steve Reinisch, Nov 22, 2005
    #1
  2. to clarify, I would also like to maintain a link to th ebom in excel such
    that changes in th eBOM will be reflected in the spreadsheet.
     
    Steve Reinisch, Nov 22, 2005
    #2
  3. Hi Steve,

    Please take a look at our Gold Partner product ToolWorks BOM Manager.

    http://www.toolworks.info

    Using this add-on you are able to export BOM from an Assembly without
    creating the drawing. Also ToolWorks BOM Manager offers a command-feature
    that can be triggered from ourside of SolidWorks to keep your MS-Excel BOM's
    up-to-date.

    Best regards
    Jess G. Frandsen
     
    Jess G. Frandsen, Nov 27, 2005
    #3
  4. Steve Reinisch

    TOP Guest

    I have done this with a macro.In a nutshell the macro reads every
    single instance of every component, suppressed or not and then I use an
    awk script to determine the count of all the resolved and lightweight
    components. Then I read the resulting text file into Excel. It works
    because I name configurations with the part name.

    The reason I do it this way is that awk can plow through thousands of
    items much quicker than Excel can and requires a lot less programming.

    The VB program I use as a basis for all this is found in the Online
    Help for the SolidWorks API and then modified. It will read custom
    properties which I think you are asking for.
     
    TOP, Nov 27, 2005
    #4
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.