Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
JelteDeJong
in reply to: theo.bot

I tried a couple of things. but could not get it to work with an object collection. But if you throw in a string you can set 1 option the table name. it works like this.

Dim doc As AssemblyDocument = ThisDoc.Document

Dim bom As BOM = doc.ComponentDefinition.BOM
Dim bomView As BOMView = bom.BOMViews.Item("structured")

Dim file = "D:\folder\file.xlsx"

bomView.Export(file, FileFormatEnum.kMicrosoftExcelFormat, "This_will_become_the_sheet_name")

 I guess that this is not what you are looking for.  But this makes me expect that it's not possible to set more options.

Jelte de Jong
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature


Blog: hjalte.nl - github.com