You could change the default template for Excel so when you create a new workbook, thus the template you are describing is used instead of a blank one...but this would be a hassel for every other time when you want a blank template when creating a new Excel workbook.
IMHO, I like to approach this issue a different way. Create an Excel workbook with all the fonts, column widths, headers, footers, graphics, etc. In this workbook embed VBA code to pull the desired information out of EPDM. (Perhaps an Excel button tell the VBA when to start, or simply on the open even, the macro asks what assembly it should display the BOM of.)
This gives you a lot of flexibility of what the BOM will look like, and you don't have to format the worksheet everytime.
Thanks for the pointer Jeff !
I am also experimenting with the XML Format of the BOM for an selected assembly. Shall let u know once i figure it out.