EPPlus 合并單元格
/// <summary> /// 合并單元格 /// </summary> /// <param name="sheet"></param> /// <param name="col">要合并的列索引</param> private void MergeCell(ExcelWorksheet sheet, int col) { int fromRow = ROWSTARTINDEX + 1; int fromCol = col; int toRow = ROWSTARTINDEX + 1; int toCol = col; string v = sheet.Cells[ROWSTARTINDEX + 1, col].Value.ToString(); for (int i = ROWSTARTINDEX + 1; i < sheet.Cells.Rows; i++) { var vNext = sheet.Cells[i + 1, col].Value?.ToString(); if (v != vNext) { v = vNext; toRow = i; sheet.Cells[fromRow, fromCol, toRow, toCol].Merge = true; sheet.Cells[fromRow, fromCol, toRow, toCol].Style.VerticalAlignment = ExcelVerticalAlignment.Center; fromRow = i + 1; } if (vNext == null) { break; } } }
Newd
版權聲明
作者:扶我起來我還要敲
地址:http://www.rzrgm.cn/Newd/p/12936790.html
? Newd 尊重知識產權,引用請注出處
廣告位
(虛位以待,如有需要請私信)
浙公網安備 33010602011771號