- // 得到一个sheet中有多少个合并单元格
- int sheetMergeCount = sheet.NumMergedRegions;
- for (var i = 0; i < sheetMergeCount; i++)
- {
- // 获取合并后的单元格
- var range = sheet.GetMergedRegion(i);
- sheet.IsMergedRegion(range);
- var cellValue = sheet.GetRow(range.FirstRow).GetValue(range.FirstColumn).FormatUtf8String();
- for (var mRowIndex = range.FirstRow; mRowIndex <= range.LastRow; mRowIndex++)
- {
- for (var mColumnIndex = range.FirstColumn; mColumnIndex <= range.LastColumn; mColumnIndex++)
- {
- table.Rows[mRowIndex][mColumnIndex] = cellValue;
- }
- }
- }