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 ( 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?