Why would you not format using the dialog boxes or design mode within qlikview? Is this a special need for additional formatting?
Also I would suggest having a module within excel to run the formatting you want after it has exported. QlikView from what I heard is eventually doing away with VB, but that might just be hearsay
Excel Marco Code - Record type VB
.HorizontalAlignment = xlCenter
.Font.Italic = True
.Font.Bold = True
.EntireColumn.ColumnWidth = 15