Once you have everything in excel, you can format the sheet.
For e.g.
Export to Excel from GridView in C#[
^] demonstrates formatting an excel file being imported.
Next,you can use something like
wSheet.get_Range("B3", "B3").HorizontalAlignment = Constants.xlCenter;
to format the column data to center.