Anonymous
1951 Views, 6 Replies
07-01-2016
08:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
07-01-2016
08:33 AM
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:
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.