How to Horizontalalign Center merged cells in EPPlus

Question

I am having an issue getting a range of merged cells to horizontal align centered. The alignment stays as left. Here's my code.

ws.Cells[lStartColumn + lStartRow].Value = gPortfolioName + " - " + lTypeOfPortfolioPerf + " Performance Update"; ws.Cells[lStartColumn + lStartRow + ":" + lEndColumn + lEndRow].Merge = true; ws.Cells[lStartColumn + lStartRow + ":" + lEndColumn + lEndRow].Style.HorizontalAlignment = ExcelHorizontalAlignment.CenterContinuous; ws.Cells[lStartColumn + lStartRow + ":" + lEndColumn + lEndRow].Style.Font.Size = 14; ws.Cells[lStartColumn + lStartRow + ":" + lEndColumn + lEndRow].Style.Font.Color.SetColor(bgTitleColor); ws.Cells[lStartColumn + lStartRow + ":" + lEndColumn + lEndRow].Style.Font.Bold = true; 

Answer 1

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.

Answer 2

Center align merged cells

 // ws.Cells[Rowstart, ColStart, RowEnd, ColEnd]    ws.Cells[1, 1].Value = "BILL OF MATERIALS";   ws.Cells[1, 1, 1, 7].Merge = true; //Merge columns start and end range   ws.Cells[1, 1, 1, 7].Style.Font.Bold = true; //Font should be bold   ws.Cells[1, 1, 1, 7].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; // Alignment is center   ws.Cells[1, 1, 1, 7].Style.Font.Size = 25;