Loading

Merge the same values using in EPPLUS

Nova

Hi Frnds,

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. I attached the excel file for your reference. Am a beginner this is my first time I am using the EPPLUS.

Please help me to get resolved.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jayesh Agrawal8y ago
Please refer this article it will step by step how you can do export excel: https://www.c-sharpcorner.com/article/export-data-to-excel-file-in-asp-net-using-epplus/ For merge cell: worksheetObj.Cells["A1:B1"].Merge = true; You can dynamic set index of cell. Hope it will helpful for you.
+1