BOMView.Export Method
Parent Object: BOMViewDescription
Method that saves the BOM as viewed in this BOM view to an external file.
Syntax
BOMView.Export( FileName As String, FileFormat As FileFormatEnum, [Options] As Variant )Parameters
| Name | Type | Description |
| FileName | String | Input string that specifies the file name to export the BOM to. |
| FileFormat | FileFormatEnum | Input FileFormatEnum that specifies the file format to save to. |
| Options | Variant | Optional input String or NameValueMap that specifies more options when the FileFormat is specified as kMicrosoftExcel, otherwise this is ignored. When a String is provided, it specifies the ‘Table Name’ for kMicrosoftExcel file format. This is the name of the Excel sheet. When a NameValueMap is provided, below options can be specified: Name = “TableName”. Value = String value that specifies the Excel sheet name. Name = “StartingCell”. Value = String value that specifies the starting cell. Name = “Template”. Value = String value that specifies the template file. Name = “ExportedColumns”. Value = String value that specifies semicolon separated column titles. Name = “AutoFitColumnWidth”. Value = Boolean value that specifies whether to auto fit the column width. Name = “ApplyCellFormatting”. Value = Boolean value that specifies whether to apply cell formatting or not. Name = “ForceCellToText”. Value = Boolean value that specifies whether to force cell to text or not. This is forced to be True when the ApplyCellFormatting is set to True. This is an optional argument whose default value is null. |
Samples
| Name | Description |
| Exporting the assembly BOM | This sample demonstrates exporting the Assembly BOM to an external file. |