Should be:
worksheet.Cells["A2:A4"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
But I think you should be doing it last, as some styling changes can affect your alignment. The order matters.
Should be:
worksheet.Cells["A2:A4"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
But I think you should be doing it last, as some styling changes can affect your alignment. The order matters.