I am trying to generate a CAD BoM / nested feature tree in Excel for a large collection of files.
The output that Treehouse produces on Export to Excel (Treehouse Export to Excel List Structure and 2017 What's New in SOLIDWORKS - Treehouse Improvements) is exactly what I am trying to replicate, except that Treehouse does not seem to be scriptable. (Please correct me if I am wrong. Scripting Treehouse would be the quickest fix.)
I found several close solutions, but each has some problems I am not sure how to overcome:
- 2018 SOLIDWORKS API Help - Traverse Assembly at Component and Feature Levels Using Recursion Example (VBA) - too much detail and does not capture that properties that Treehouse does.
- https://forum.solidworks.com/thread/81044 - the attached macro (Feature_Tree_to_Clipboard.zip) works great, but again too much detail and does not capture the properties that Treehouse does.
- http://cadhero.com/uncategorized/export-solidworks-bom-to-excel-with-thumbnail-preview-solidworks-macro/ - can only handle assembly files that are built from part files only and does not capture the properties that Treehouse does.
Could you please help me bridge this?