$sheet -> Range("F1:S1") -> {HorizontalAlignment} = "xlCenter"; $sheet -> Range("F1:S1") -> {VerticalAlignment} = "xlCenter";