This is just guess, I am not sure it works or not!!
You can create a excel template first with required formatting...then
copy the template to the output excel file location before copying the data or as first of the job in copying the data..
MohammedU
Microsoft SQL Server MVP