Java 导出多级表头

左手的ㄟ右手 2022-12-17 10:56 224阅读 0赞

需要引入的 maven

<dependency>
        <groupId>cn.afterturn</groupId>
        <artifactId>easypoi-base</artifactId>
        <version>3.0.3</version>
    </dependency>
    <dependency>
        <groupId>cn.afterturn</groupId>
        <artifactId>easypoi-web</artifactId>
        <version>3.0.3</version> </dependency>
    <dependency>
        <groupId>cn.afterturn</groupId>
        <artifactId>easypoi-annotation</artifactId>
        <version>3.0.3</version>
    </dependency>

代码片段

// 一级表头
    String[] testHeader = {"合并1","合并1","合并2","合并2"};
    
    // 二级表头
    String[] testHeaders = {"测试1","测试2","测试3","测试4"};
    
    /**
     * 导出xls文件(合并单元格)
     * @param list
     * @param fileName
     */
    void easyPoi(List<String> list,String fileName, HttpServletResponse response) throws Exception{
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet(fileName);//创建一个sheet
    
        //设置单元格风格，居中对齐.
        HSSFCellStyle cs = wb.createCellStyle();
        cs.setAlignment(HSSFCellStyle.ALIGN_CENTER);
    
        cs.setBorderBottom(HSSFCellStyle.BORDER_THIN); //下边框
        cs.setBorderLeft(HSSFCellStyle.BORDER_THIN);//左边框
        cs.setBorderTop(HSSFCellStyle.BORDER_THIN);//上边框
        cs.setBorderRight(HSSFCellStyle.BORDER_THIN);//右边框
    
        //设置字体:
        HSSFFont font = wb.createFont();
        font.setFontName("黑体");
        font.setFontHeightInPoints((short) 12);//设置字体大小
        font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//粗体显示
    
        cs.setFont(font);//要用到的字体格式
    
        //创建第一行
        HSSFRow row = sheet.createRow((short) 0);
        HSSFCell cell ;
    
        for (int i = 0; i < testHeader.length; i++) {//设置表头-标题
            cell = row.createCell(i);
            cell.setCellValue(testHeader[i]);
            cell.setCellStyle(cs);
            sheet.autoSizeColumn(i);//自动设宽
        }
    
        //设置合并的标题头(注意：横向合并的时候，标题头单元格必须长度和内容单元格一致否则合并时会把其他标题头单元格内容挤掉)
        sheet.addMergedRegion(new CellRangeAddress(0,0,1,2));//横向：合并第一行的第1列到第2列
        sheet.addMergedRegion(new CellRangeAddress(0,0,3,4));//横向：合并第一行的第3列到第4列
    
        //设置对应的合并单元格标题
        row = sheet.createRow(1);
        for (int j = 0; j <testHeaders.length; j++) {
            cell = row.createCell((short)j);
            cell.setCellStyle(cs);
            cell.setCellValue(testHeaders[j]);
            sheet.autoSizeColumn(j);//自动设宽
        }
    
        //设置列值-内容  这个正式使用，测试我就写死了
        /*for (int i = 0; i < list.size(); i++) {
            row = sheet.createRow(i + 2);
            row.createCell(0).setCellValue(list.get("test"));
            row.createCell(1).setCellValue(list.get("test"));
            row.createCell(2).setCellValue(list.get("test"));
        }*/
    
        // 测试使用
        row.createCell(0).setCellValue("1");
        row.createCell(1).setCellValue("2");
        row.createCell(2).setCellValue("3");
        row.createCell(2).setCellValue("4");
    
        try {
            //页面弹出下载或保存
            response.setContentType("application/x-download");
            response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName + ".xls", "utf-8"));
            response.setCharacterEncoding("utf-8");
            OutputStream os=response.getOutputStream();
            wb.write(os);
            os.close();
        } catch (Exception e) {
            System.out.println("文件输出失败!");
            e.printStackTrace();
        }
    }