/// <summary> /// sheet中添加合并区域 /// </summary> /// <param name="sheet"></param> /// <param name="regionInfo"></param> public static void AddMergedRegion(this ISheet sheet, MergedRegionInfo regionInfo) { var region = new CellRangeAddress(regionInfo.FirstRow, regionInfo.LastRow, regionInfo.FirstCol, regionInfo.LastCol); sheet.AddMergedRegion(region); }
/// <summary> /// 添加合并区域 /// </summary> /// <param name="sheet"></param> /// <param name="regionInfo"></param> public static void AddMergedRegion(this ISheet sheet, MergedRegionInfo regionInfo) { var region = new CellRangeAddress( regionInfo.Range.StartLocation.RowIndex, regionInfo.Range.EndLocation.RowIndex, regionInfo.Range.StartLocation.ColumnIndex, regionInfo.Range.EndLocation.ColumnIndex); sheet.AddMergedRegion(region); }
/// sheet中添加合并区域 /// <param name="sheet"></param> /// <param name="regionInfo"></param> public static void AddMergedRegion(this ISheet sheet, MergedRegionInfo regionInfo) { var region = new CellRangeAddress(regionInfo.FirstRow,regionInfo.LastRow,regionInfo.FirstCol,regionInfo.LastCol); sheet.AddMergedRegion(region); }