import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.util.CellRangeAddress;
public class ExcelHelper {
public void merge(Sheet sheet, int startRow, int mergeRow, int i){
String startText = sheet.getRow(startRow).getCell(mergeRow).toString();
while(sheet.getRow(i)!=null&&sheet.getRow(i).getCell(mergeRow)!=null){
if(sheet.getRow(i).getCell(mergeRow)!=null
&&!sheet.getRow(i).getCell(mergeRow).toString().equals(startText)){
//合并单元格
sheet.addMergedRegion(new CellRangeAddress(startRow,i-1,mergeRow,mergeRow));
startText = sheet.getRow(i).getCell(mergeRow).getStringCellValue();
startRow = i;
}
i++;
}
//尾部处理
if(startRow!=i){
sheet.addMergedRegion(new CellRangeAddress(startRow,i-1,mergeRow,mergeRow));
}
}
public void mergeByParent(Sheet sheet, int startRow, int mergeRow,int mergeParentRow,int i){
String startText = sheet.getRow(startRow).getCell(mergeRow).toString();
String startParentText = sheet.getRow(startRow).getCell(mergeParentRow).toString();
while(sheet.getRow(i)!=null&&sheet.getRow(i).getCell(mergeRow)!=null){
if(sheet.getRow(i).getCell(mergeRow)==null
||!sheet.getRow(i).getCell(mergeRow).toString().equals(startText)
||!sheet.getRow(i).getCell(mergeParentRow).toString().equals(startParentText)){
if(i!=startRow){
//合并单元格
sheet.addMergedRegion(new CellRangeAddress(startRow,i-1,mergeRow,mergeRow));
}
startText = sheet.getRow(i).getCell(mergeRow).getStringCellValue();
startParentText = sheet.getRow(i).getCell(mergeParentRow).getStringCellValue();
startRow = i;
}
i++;
}
//尾部处理
if(startRow!=i){
sheet.addMergedRegion(new CellRangeAddress(startRow,i-1,mergeRow,mergeRow));
}
}
}