Anyone know how to export the feature tree to excel?
Anyone know how to export the feature tree to excel?
Thanks Deepak, but my IT group will not allow for the import of Macros. Do you know what the step are inside the Macro or how I can look at them?
Pro Engineer it was as simple as clicking on the Setting button on the top of the Feature Tree and Save Model Tree as a .csv file...
I've attached the macro here. This macro simply copies the feature tree of the active document directly to the clipboard. After that you can simply copy that to a text file, Word file OR Excel File as required.
To run the macro, extract the attached file, go to Tools > Macro > Run and browse to extracted file. After that you'll get a prompt that data has been copy to clipboard.
Please use at own risk and try on sample files first.
Macro works but gives you a completely indented BOM. It even gives you all the mates, planes, etc. Need to learn more about VBA to get what I want.
For the Solidworks guru's, it would be nice to have the ability to input the BOM data into Solidworks that has this information http://www.quick-teck.co.uk/component/Quick-teck%20BOM%20template_1.1.xls . Creating the spreadsheet inside the tool that you can than export out would be helpful.
There is macro that can import excel file into SW as general table but not as BOM. Will that work for you?
And for this macro what changes you need? Can you list them out as someone may be fix/update the macro for you.
Will this Macro work with 2012? If not, is there a way to export the tree in SW2012?
Feature tree you mean? Yes the macro should work with 2012. Have you tried using it?
Were you able to get the macro running. Once you run the macro please check for a pop-up window which might have gone away from screen. Try pressing Alt+Tab to get to that window.
Was able to get the macro to work, thank you. Need to learn VBA to have it spit out information that I do not need to edit quite so much.
You can use the Assembly Visualization tool.
Go to Tools/Assembly Visualization
You can then set any column data you want or don't want and save it to an excel file by clicking the arrow at the top left and clicking "save as".
It can be saved as excel, text, csv or pdf.
Japheth,
Thank you. This is what I wanted out of the tool.
Jack
You can use the Assembly Visualization tool.
Go to Tools/Assembly Visualization
You can then set any column data you want or don't want and save it to an excel file by clicking the arrow at the top left and clicking "save as".
It can be saved as excel, text, csv or pdf.