How to merge cell using closedxml with a dynamic column count?

Question

This is how to merge cell using ClosedXML based on the documentation.

worksheet.Range("B2:D3").Row(1).Merge();

My problem is my column count is dynamic, I can't set column letter value to merge because i will based the merging of cell on my gridview column count.

Anyone who can help me to merge cell using closedXML?

Cobnut

Please play fair and mark the question as answered if you're happy with the answer. – Weksler

Answer 1

I do it this way

int row = 1;
int col = 1;

worksheet.Range(worksheet.Cell(row, col++), worksheet.Cell(row, col++)).Merge();

Pollster

Answer 2

Build up the range as a variable based on your column count and pass the variable to the Range method. You don't need to HAVE to pass a hard coded value.

Weksler

Answer 3

Have you tried the code below?

 worksheet.Cell("A1").Value = "Title";
 var range = worksheet.Range("A1:F1");
 range.Merge().Style.Font.SetBold().Font.FontSize = 16;

It works for me.

Seadon

This is the same code as the question .Range("A1:F1") - maybe read the question? – Chloric

Yeah I don't believe this answer provides additional context over the original question. One answer suggestion could be the following, where X is the amount of cells to merge on the given row: worksheet.Range(worksheet.Cell(row, col), worksheet.Cell(row, col + X)).Merge(); – Trump