import org.apache.poi.hssf.util.CellRangeAddress; //导入依赖的package包/类
@SuppressWarnings("deprecation")
>>>>>>> fe2012a7f8558d8df36b789847bdc41c788d6eaf
	public static void createMergedRegionIfNotPresent(XSSFSheet sheet,int firstRow, int lastRow, int firstCol, int lastCol){
		String message="XSSFSheet must not be null!";
		Objects.requireNonNull(sheet, () -> message);
		sheet.addMergedRegion(new CellRangeAddress(firstRow,  lastRow,  firstCol,  lastCol)); 
	}
 

import org.apache.poi.hssf.util.CellRangeAddress; //导入依赖的package包/类
/**
 * 合并单元格（行合并），合并规则：内容相同则合并
 * 
 * @param sheet	       合并的sheet
 * @param colindex      合并列索引
 * @return
 */
@SuppressWarnings("deprecation")
public static HSSFSheet rowSpan(HSSFSheet sheet, int colindex, int contentBeginIndex) {
	// 总行数
	int rowNum = sheet.getLastRowNum();
	HSSFRow row = sheet.getRow(1);
	// 正文内容应该从第二行开始,第一行为表头的标题
	int startRow = contentBeginIndex;
	String startValue = "";
	for (int i = contentBeginIndex; i <= rowNum; i++) {
		row = sheet.getRow(i);
		String value = row.getCell(colindex).getRichStringCellValue().getString();
		if (i == contentBeginIndex) {
			startValue = value;
			continue;
		}
		if (StrUtil.isNotBlank(startValue) && StrUtil.isNotBlank(value) && startValue.equals(value)) {
			if (i == rowNum) 
				sheet.addMergedRegion(new CellRangeAddress(startRow, i , colindex, colindex));
			else
				continue;
		} else {
			if((i-1)>startRow)
				sheet.addMergedRegion(new CellRangeAddress(startRow, i - 1, colindex, colindex));
			startRow = i;
		}
		startValue=value;
	}
	return sheet;
}
 

import org.apache.poi.hssf.util.CellRangeAddress; //导入依赖的package包/类
@SuppressWarnings("deprecation")
public static void createMergedRegionIfNotPresent(XSSFSheet sheet,int firstRow, int lastRow, int firstCol, int lastCol){
	String message="XSSFSheet must not be null!";
	Objects.requireNonNull(sheet, () -> message);
	sheet.addMergedRegion(new CellRangeAddress(firstRow,  lastRow,  firstCol,  lastCol)); 
}