Skip to main content
M
mwick7-Bedrock
7-Bedrock
July 1, 2014
Solved

Export Model Tree to Excel in Creo Parametric 2.0

  • July 1, 2014
  • 3 replies
  • 14492 views

Hello,

I was wondering if there was an easy way to export the model tree from Creo Parametric 2.0 to MS Excel? I can get it to Save as a .txt file then open that in MS Excel, but unless all the levels are expanded it will not dispaly children of assemblies/weldments. I was wondering if someone has a mapkey or suggestion they could share.

Thanks in advance,

Mike


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.
Best answer by dschenken

The best way is with a Macro on the Excel side - The columns of output are variable width based on the contents. Levels of indenture in the first column are prefixed with spaces.

You need to set and save a tree.cfg file to make the rest easier - once you know the order of the titles, then you can get their positions from the file and use that to split each line into it's correct parts and assign any other factors. For example - taking the number of spaces that prefix an item to get the level of indenture or to skip processing Group or Pattern entries.

If you post a simple copy of your model tree text file I will write an example Macro. They are pretty easy. Make it a fake assembly.

3 replies

T
TomD.inPDX17-Peridot
17-Peridot
July 1, 2014

Would this help?

expand-all.png

M
mwick7-BedrockAuthor
7-Bedrock
July 1, 2014

To some degree it does, but it also expands the features under the part as well. I am looking to generate a Bill of Materials from the Model Tree. So I basically need the part number, title, rev, quantity, etc.

T
TomD.inPDX17-Peridot
17-Peridot
July 1, 2014

Right; you want to set up the tree and save the tree configuration to show these parameters. You can turn off the features for assemblies (tree filters). You can add columns for the parameters (tree columns).

Again, if you want to import these into Excel, plan the tree carefully as spaces in any field will get in the way. Maybe add these to the end.

S
23-Emerald III
StephenW23-Emerald III
23-Emerald III
July 1, 2014

The way I do it is by creating a repeat region BOM so I can add the parameters and make it recursive to the level I want and then export that to a text file.

It works for me but everyone's expectations are different.

D
dschenken1-VisitorAnswer
1-Visitor
July 1, 2014

The best way is with a Macro on the Excel side - The columns of output are variable width based on the contents. Levels of indenture in the first column are prefixed with spaces.

You need to set and save a tree.cfg file to make the rest easier - once you know the order of the titles, then you can get their positions from the file and use that to split each line into it's correct parts and assign any other factors. For example - taking the number of spaces that prefix an item to get the level of indenture or to skip processing Group or Pattern entries.

If you post a simple copy of your model tree text file I will write an example Macro. They are pretty easy. Make it a fake assembly.

Terms & ConditionsAccessibility statement