distinct materials excel

[tonygancio]

Hello everyone, after a few years I returned to inventor and I would need some help_o. I would like to export a separate material from 3d to excell.
library files that are assiemi or parts I put the purchased property, while to the parts that make up a collection of purchased I put hidden so that they do not go out on the list.
now I would like to be able to create my excell file with logo and layout and I would like to set it as the default export file, can you do it?
I would also like to be able to separate by category the library files - sheet - and all the rest maybe carrying behind a column called type (purchase - sheet - other)
look lumi from numerous experts, thanks 1000!
Niche

 

[Matteo Cappelli dis.CAD]

Hi.
great the fact that you're back among us!
for export from separate material you can use the icon at the top to the leftbut in this way I do not feel that you can use an excel model file.
if instead, use the command saves from the bom of table 2d,
you can use a template model where you can saveas to the type you may add a custom iproperties "type" and apply the following formula on the value:
♪<document name="" subtype="">clearly then from the set of together you can copy and create iproperties type and its value to all parts and assemblies</document>Good job