When I export a BOM from a SolidWorks assembly drawing I would like to use a specific template in Excel that I have created and formatted to my liking. Is there a way to do that?
EDITED BY MODERATOR: Moved to the Bill of Materials space. Please post to the appropriate space when one exists.
You can't insert both types of BOMs into a drawing file. You can only have one or the other.
Bah!! You are correct. *sigh* Well, it was a shot.
Hi Dusty:
If you're not opposed to using 3rd party tools, check out Bommer (https://www.getbommer.com). Bommer runs as an add-in in SOLIDWORKS to let you quickly edit and export your BOM; it supports exporting your BOM to an Excel template formatted any way you would like.
Jesse
Full disclosure: I am the co-founder/developer of Bommer.
I don't know.....there might be.
In case there isn't, there may be another way.
You should be able to insert an excel based BOM using whatever template you want. You could even insert a regular BOM, then do an excel based BOM and then export it. Then delete the excel based from the drawing.