/// <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);
}
