Skip to main content
D
DennisRehmer12-Amethyst
12-Amethyst
October 30, 2013
Question

export BOM to excel format

  • October 30, 2013
  • 3 replies
  • 3318 views

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.

3 replies

M
MartinHanak24-Ruby III
24-Ruby III
October 31, 2013

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

D
DennisRehmer12-AmethystAuthor
12-Amethyst
November 6, 2013

Thank you for your suggestion.

H
HugoBarosa1-Visitor
1-Visitor
October 31, 2013

Hi!

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

You can open csv with excel, openofice, libreofice etc

D
DennisRehmer12-AmethystAuthor
12-Amethyst
November 6, 2013

Thank you for your help on this.

D
dschenken1-Visitor
1-Visitor
November 6, 2013

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.

D
DennisRehmer12-AmethystAuthor
12-Amethyst
November 6, 2013

Thanks for the suggestion.

Terms & ConditionsCookie settingsAccessibility statement