Excel导出模板(单头和序号列)

Love The Way You Lie 2022-05-16 06:55 179阅读 0赞

##  新增了单头 和序号列 ##

![70][]

使用POI的样式的时候一定要注意

ztCell.setCellStyle(cellStyle);   不然样式不起作用

需要了解相关的传入参数  请参考我的其他播客

public static XSSFWorkbook excelExport(String title, List resultList, Map<String, String> linkedHashMap) throws Exception {
            XSSFWorkbook workbook = new XSSFWorkbook();
    
            CellRangeAddress region1 = new CellRangeAddress(0, 0,0,linkedHashMap.size()-1);
            XSSFCellStyle cellStyle = workbook.createCellStyle();
            cellStyle.setAlignment(XSSFCellStyle.ALIGN_CENTER); // 居中
            XSSFFont font = workbook.createFont();
            font.setFontHeightInPoints((short) 22);
            cellStyle.setFont(font);// 添加字体样式
           //新建sheet
            XSSFSheet sheet = workbook.createSheet("sheet1");
            sheet.addMergedRegion(region1);
            //设置行宽，列高
            sheet.setDefaultColumnWidth(20);
            sheet.setDefaultRowHeightInPoints(20);
            //循环标题行和数据行
            for (int k = 0; k <= resultList.size()+1; k++) {
                XSSFRow row = sheet.createRow(k);
                if(k == 0){
                    Cell ztCell= row.createCell(0);
                    ztCell.setCellValue(title);
                    ztCell.setCellStyle(cellStyle);
    
                }else if (k == 1) {
                    int i = 0;
                    for (Map.Entry<String, String> entry : linkedHashMap.entrySet()) {
                        row.createCell(i).setCellValue(entry.getKey());
                        i++;
                    }
                } else {
                    //给数据列赋值
                    int j = 0;
                    Object resultVo = resultList.get(k - 2);
                    Method[] m = resultVo.getClass().getMethods();
                    for (Map.Entry<String, String> entry : linkedHashMap.entrySet()) {
                        String result = null;
                        String methodName = "get" + toUpperCaseFirstChar(entry.getValue());
                        if(j==0){
                            row.createCell(0).setCellValue(k-1);
                        }else {
                            for (int i = 0; i < m.length; i++) {
                                if (methodName.equals(m[i].getName())) {
                                    Object ob = m[i].invoke(resultVo);
                                    if (!StringUtils.isEmpty(ob)) {
                                        result = String.valueOf(m[i].invoke(resultVo));
                                    }
                                    break;
                                }
                            }
                            if (result != null) {
                                row.createCell(j).setCellValue(result);
                            }
                        }
                        j++;
                    }
                }
            }
    
            return workbook;
        }

[70]: /images/20220516/1b6efa2ee6774369939f9c39dbebb38e.png