Save as Bom in special Excel Temp

Hi everyone

How can i export BOM to this template.

Now i have to save as bom , then start to change border, bolt the header , filter the top row, freez top row , change the color of header ,.....

When a part change , I have to repeat the above .

I am wondering is there any macro to save BOM like attached excel file?

Tanks

SolidworksAssemblies