【POI合并单元格】

Shorey_

已于 2023-03-21 14:00:25 修改

阅读量768

点赞数 1

文章标签： java 开发语言

于 2023-03-21 13:59:57 首次发布

本文链接：https://blog.csdn.net/qq_44004245/article/details/129687162

版权

POI合并单元格

 public void writeTableDataWithMergeCell(PoiTableHeader header,List<?> dataList){

        HSSFCellStyle cellStyle=(HSSFCellStyle)header.getWorkbook().createCellStyle();
        cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); // 下边框
        cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);// 左边框
        cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);// 上边框
        cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);// 右边框
        // 设置所有单元格文字上下居中
        cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        int mergeCellsBegin = 1;
        int mergeCellsEnd = 1;
        int mergeCellCols=9;
        int startRow=header.getMaxRowSpan();
        List<FieldColumn> fieldColumns = header.getFieldColumns();
        int colsSize = fieldColumns.size();
        String tempVar ="";//当前前9列的值
        String preTempVar ="";//上次前9列的值
        for(int i=0;i<dataList.size();i++){
            preTempVar = tempVar;
            tempVar = "";
            Object obj=dataList.get(i);
            Row row=header.getSheet().createRow(startRow+i);
            for(int j=0;j< colsSize; j++){
                FieldColumn fieldColumn= fieldColumns.get(j);
                Cell cell=row.createCell(j);
                String field=fieldColumn.getField();
                Object val =BeanUtil.getFieldValueFromObject(obj, field);
                if(val!=null){
                    if (j < mergeCellCols){
                        tempVar += val.toString();
                    }
                    cell.setCellValue(val.toString());
                }
                cell.setCellStyle(cellStyle);
            }
            //如果 当前值!=上次值  B=当前行 E=当前行
            if (!tempVar.equals(preTempVar)){
                if (mergeCellsEnd>mergeCellsBegin){
                    System.err.println("合并"+mergeCellsBegin+","+mergeCellsEnd);
                    merge(header,mergeCellsBegin,mergeCellsEnd,mergeCellCols);
                }
                mergeCellsBegin = startRow+i;
                mergeCellsEnd = startRow+i;
            }
            //如果 当前值==上次值  B=B     E=当前行
            if (tempVar.equals(preTempVar)){
//                mergeCellsBegin = startRow+i;
                for (int n=0;n<mergeCellCols;n++){
                    row.getCell(n).setCellType(CELL_TYPE_BLANK    );
                }
                mergeCellsEnd = startRow+i;
            }
            System.err.println("B:"+mergeCellsBegin+"  E:"+mergeCellsEnd);
        }

    }

    private void merge(PoiTableHeader header, int mergeCellsBegin, int mergeCellsEnd, int mergeCellCols) {
        for (int j = 0; j < mergeCellCols; j++) {
            CellRangeAddress region = new CellRangeAddress(mergeCellsBegin, mergeCellsEnd, j, j);
            header.getSheet().addMergedRegion(region);
        }
    }