Skip to main content
P
ptc-44130001-Visitor
1-Visitor
January 18, 2012
Question

Export BOM to Excel

  • January 18, 2012
  • 3 replies
  • 4745 views

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.

3 replies

B
bgramman1-Visitor
1-Visitor
July 6, 2012

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

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

P
PedroNeves1-Visitor
1-Visitor
July 8, 2012

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

    B
    bschmidt-21-Visitor
    1-Visitor
    June 17, 2016

    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

    Terms & ConditionsAccessibility statement