Hello,
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?
Yes Treehouse doesn't have macro
You could modify any of the above macros to export the properties you need