Merge cells using EPPlus?

Question

I use the EPPlus library to read / write Excel files: http://epplus.codeplex.com/

I try to just merge some cells when writing a document:

using (ExcelPackage pck = new ExcelPackage()) { //Create the worksheet ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Demo"); //Format the header for column 1-3 using (ExcelRange rng = ws.Cells["A1:C1"]) { bool merge = rng.Merge; } } 

There's a property called Merge that just returns true or false. I thought it might be a cell merge, but it is not.

Does anyone know how to do this?

Answer 1

You should use it as follows:

 ws.Cells["A1:C1"].Merge = true; 

instead:

 using (ExcelRange rng = ws.Cells["A1:C1"]) { bool merge = rng.Merge; } 

Answer 2

If you want to merge cells dynamically, you can also use:

worksheet.Cells[FromRow, FromColumn, ToRow, ToColumn].Merge = true;

All of these variables are integers.

Answer 3

You can create an extension method:

 public static void Merge(this ExcelRangeBase range) { ExcelCellAddress start = range.Start; ExcelCellAddress end = range.End; range.Worksheet.Cells[start.Row, start.Column, end.Row, end.Column].Merge = true; } 

You can use this as you could with interop:

 range.Merge();