export BOM to excel format

[DennisRehmer]

To all,

We are using WF4.0, and I was wondering if there is a way to easily export a BOM into an Excel format.

I would like to include in this things like the part number, description, quantity and maybe other pertinent information. If you do the Pro/E Info > BOM it is in a text format and does not have any information other than the part number and the quantity normally.

Dennis

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.

[MartinHanak]

Dennis,

you can specify user defined contents of textual BOM using special format file and bom_format config.pro option. Try to look into PTC Help.

Martin Hanak

[DennisRehmer]

Thank you for your suggestion.

[HugoBarosa]

Hi!

You can select a table in drw file ans save as *csv file.

You can open csv with excel, openofice, libreofice etc

[DennisRehmer]

Thank you for your help on this.

[dschenken]

I set the model tree to display the parts and content of interest, then save the tree (not the tree config) to a text file. It gets saved in the start-in directory. Import the file as text and use fixed width to select the fields or create a macro to parse the lines.

It's necessary to expand groups and patterns; these become markers which can be helpful in determining where a component is used.

[DennisRehmer]

Thanks for the suggestion.