Export BOM to Excel

[ptc-4413000]

Hello,

I'm trying to write VB code which will fetch BOM (bill of material) from ProE and export in to Excel

I've started with the following:

Dim model As pfcls.IpfcModel

Dim export_instructions As pfcls.IpfcBOMExportInstructions

export_instructions = New CCpfcBOMExportInstructions

I would appreciate any help on this. Where to start, what to read, etc...

Thanks in advance!

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

[bgramman]

Simplified Logic offers a tool that will create BOM in MS Excel based on a Pro E assembly.

http://simplifiedlogic.com/nitro-bom/

[PedroNeves]

Hello

I created a format(.frm) with a table to creat my own BOM

this table gets the parameters from the parts, and creat a BOM from the assembly and simplify rep e chose.

then just select the entire table, and chose save table as .CSV

Then you can import the .CSV file to Excel

[bschmidt-2]

Hi,

I assume you have solved this a long time ago. But if some other poor guy is finding this ancient post.

With the following .NET-Code you can get the BOM as txt-File

	// Create export-Instructions for BOM
	CCpfcBOMExportInstructions bomExportCreate = new CCpfcBOMExportInstructions();
	IpfcBOMExportInstructions exportInstr = bomExportCreate.Create();
	IpfcExportInstructions temp = (IpfcExportInstructions)exportInstr;

	//export to file
	this.model.Export(fileName, temp);

Best Regards,

Benjamin