Export structured BOM to existing excel template

[Anonymous]

After a few hours of searching I have came across various threads/blogs which are close to what I need, but they are all missing at least one important aspect. I will post them here for reference:

Export parts list from a drawing file: @Curtis_Waguespack

http://inventortrenches.blogspot.co.uk/2011/06/ilogic-export-parts-list-with-options.html

Compiles a list of all parts/assemblies and their respective total quantities: @pball

https://forums.autodesk.com/t5/inventor-customization/vba-counting-quantity-of-parts-in-assemblies/m...

Exports a drawing part list from an assembly file: @HermJan.Otterman

https://forums.autodesk.com/t5/inventor-customization/ilogic-to-export-bom-from-assembly-to-an-excel...

In a nutshell... I would like to open and assembly file, run an iLogic rule that exports a structured BOM showing all levels to an existing excel template (see attached). Columns A to D would come from Inventor. I've knocked up some formulas in columns E & F to get the overall quantities of any sub-parts.

Any suggestions on where to take this next would be hugely appreciated!

[Tranquill]

I'm looking for this as well, did you get it working?

[A.Acheson]

To clarify is it the BOM you want exported or the Partslist? Both will have a different technique and if they require post processing later that can give lots of different results.

The BOM export will leave in the units of measure this will likely need removal in your excel sheet either during the rule depending on the export method or after the rule using VBA macro in excel.

The Partslist you can strip the units of measure before export.

From what I have read you can use the partslist to feed data into an existing template(not sure if it will remove  For the BOM if you use the bulk export method it will create an excel sheet everytime, a temporary workbook would be needed and then copy the data to your template.

Using the BOM extract Row by Row you can target an existing template.

You want columns As below?

Item,Partnumber,Description,Qty