Merge cells using EPPlus? Merge cells using EPPlus? asp.net asp.net

Merge cells using EPPlus?


c# asp.net excel epplus

You have to use it like this:

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

instead of:

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

c# asp.net excel epplus

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

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

All these variables are integers.

c# asp.net excel epplus

You can create a 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 would via interop:

range.Merge();

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last