Is it possible to export the BOM to an Pre-defined Excel format which consists of header and footer ?

Epilogue:

1) Various sub assemblies are built based to achieve DFA.(Design for Assembly)

2) Based on these Sub assemblies BOM Shop builds the sub assmblies.

3) I would like to Export the BOM to Excel file from the tabs in the Vault View  as per the pre-defined format with Headers,Footers, Logo, Page Number Etc.

Any help on this front would be highly apprieciated.