Creating indented BOM for Excel

[longhorn97]

I need a quick way to create indented BOMs from Pro/E assemblies in Excel. I know I can copy and paste from Intralink's BOM report, but it is a flat BOM and it will take a long time to format everything correctly in Excel. Is anyone able to do this without additional software? If you are using a 3rd party software, which ones are best?

Thanks,
Chris

 

[jnoval]

You can save the BOM table from ProE to a txt file. Then open/import the txt-file into excel. If you do the import correct then you will have alle the colums correct.

 

[dhbigelow]

I am very bias on this, but it lets you go both ways between Excel and Pro/E.


http://www.nitromation.com/NitroBOM.shtml


Dave

 

[slashct]

I had created a special BOM in proengineer, it takes some time to get it right but you need to make the columns the same size or bigger than the longest text string that you will have in that column, in ProE it looks ugly, than when you save it as txt from the drawing it will make sure that it has the right size. WHen you bring it into excel it comes in clean and good. When making the title of the table you have to have the correct number of identations at the top. It is hard to explain, but it works great once you get it to work, just need to adjust the indentations to the number of levels you have.

 

[usfmechiebull]

Have you created your custom BOM format?? Do you mind sharing it with us ??


Thanks,