Merge the same values using in EPPLUS

Question

I need to merge the dynamically when my first column values are same in EXCEL Generation using EPPLUS. My column data was change when employees joining and termination. So, I want to konw How to dynamically merge if the columns are same values and I need to Highlight the each Total row only with backgroud color.

Am a beginner this was my first time I am using the EPPLUS. I don't know how to attach the sample excel file in this page.

I attached sample Excel file in this link https://www.c-sharpcorner.com/forums/merge-the-same-values-using-in-epplus.

Please help me to get resolved.

https://stackoverflow.com/questions/6172488/merge-cells-using-epplus — EzLo, Mar 27 '18 at 13:46

score 1 · Accepted Answer · answered Mar 27 '18 at 13:53

You can follow this example to merge:

using (ExcelPackage excel = new ExcelPackage(new FileInfo(filePath)))
{
    ExcelWorksheet worksheet = excel.Workbook.Worksheets[1];

    for (int currentRow = worksheet.Dimension.Start.Row; currentRow <= worksheet.Dimension.End.Row; currentRow++)
    {
        string firstCellValue = worksheet.Cells[currentRow, 1].Value == null || worksheet.Cells[currentRow, 1].Value.ToString() == "" ? null : worksheet.Cells[currentRow, 1].Value.ToString();
        string secondCellValue = worksheet.Cells[currentRow, 2].Value == null || worksheet.Cells[currentRow, 2].Value.ToString() == "" ? null : worksheet.Cells[currentRow, 2].Value.ToString();

        if (firstCellValue == secondCellValue)
        {
            worksheet.Cells[currentRow, 1, currentRow, 2].Merge = true;
        }
    }

    // Save file
}

my requirement is quite similar but I want to check for columns for same value — Prashant Pimpale, Oct 08 '18 at 13:44

Merge the same values using in EPPLUS

1 Answers1