NPOI v2.3.0 根据行列坐标判断属于哪一个合并单元格
来不及解释了,赶紧上码:》
private static CellRangeAddress GetMergedRegion(ISheet sheet,int rowNum,int colNum,out int index)
{
index = -1;
var b = false;
CellRangeAddress region = null;
for (int i = 0; i < sheet.NumMergedRegions; i++)
{
region = sheet.GetMergedRegion(i);
if (region.FirstRow <= rowNum && rowNum <= region.LastRow && region.FirstColumn <= colNum && colNum <= region.LastColumn) b = true;
if (b)
{
index = i;
break;
}
}
return b ? region : null;
}