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;

score 66 · Accepted Answer · edited Mar 03 '15 at 21:35

66

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.

edited Mar 03 '15 at 21:35

Simple Sandman

900
3
11
34

answered Dec 08 '14 at 15:06

davidahines

3,976
16
53
87

How to merge the cells on the condition? – Prashant Pimpale Oct 08 '18 at 13:57

score 8 · Answer 2 · answered Jan 15 '16 at 09:54

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;

How to Horizontalalign Center merged cells in EPPlus

2 Answers2