Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
Anonymous
1951 Views, 6 Replies

Export BOM with options

I found this excellent blog which shows how you can export a parts list from an .idw file to a pre-existing XLS file

 

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

 

Is there a way to achieve a similar result with a BOM from a .iam file?

 

So far my iLogic code goes something like this

 

ThisBOM.Export("Structured", "fileName1", kMicrosoftExcelFormat)

Which produces this:

BOM example.JPG

 

I'd like to export this data to a fancy looking pre-existing XLS file that has an 'Extended Cost' column J with the formula =I2*D2 and a 'Total' cell underneath.