/// <summary> /// 获取sheet中指定区域包含合并区域的信息列表 /// </summary> /// <param name="sheet"></param> /// <param name="range"></param> /// <returns></returns> public static IList <MergedRegionInfo> GetMergedRegionInfos(this ISheet sheet, CellRange range) { var regionInfoList = new List <MergedRegionInfo>(); for (int i = 0; i < sheet.NumMergedRegions; i++) { var mergedRegion = sheet.GetMergedRegion(i); var regionRange = new CellRange(mergedRegion.FirstColumn, mergedRegion.FirstRow, mergedRegion.LastColumn, mergedRegion.LastRow); if (range.Include(regionRange)) { regionInfoList.Add(new MergedRegionInfo(i, regionRange)); } } return(regionInfoList); }
public static bool Include(this CellRange range, int startColumnIndex, int startRowIndex, int endColumnIndex, int endRowIndex) { return(range.Include(new CellRange(startColumnIndex, startRowIndex, endColumnIndex, endRowIndex))); }