Excel 导出(PIO)

 /**
   * Excel 导出
   * 数据库读取导出Excel
   */
    @Test
    public void ExcelTest4() throws Exception {

        List<User> users = userMapper.selectList(null);
        Workbook workbook = new SXSSFWorkbook(); //加速版
        Sheet sheet = workbook.createSheet("user表格");
        Row titleRow  = sheet.createRow(0);
        titleRow .createCell(0).setCellValue("序号");
        titleRow .createCell(1).setCellValue("名字");
        titleRow .createCell(2).setCellValue("年龄");
        titleRow .createCell(3).setCellValue("邮箱");
        titleRow .createCell(4).setCellValue("创建时间");
        titleRow .createCell(5).setCellValue("修改时间");
        titleRow .createCell(6).setCellValue("删除标志");
        titleRow .createCell(7).setCellValue("号码");
        int cell = 1;
        for (User user : users) {
            Row row  = sheet.createRow(cell);//从第二行开始保存数据
            row.createCell(0).setCellValue(cell);
            row.createCell(1).setCellValue(user.getId());
            row.createCell(2).setCellValue(user.getName());
            row.createCell(3).setCellValue(user.getEmail());
            row.createCell(4).setCellValue(user.getCreateTime());
            row.createCell(5).setCellValue(user.getUpdateTime());
            row.createCell(6).setCellValue(user.getDeleted());
            row.createCell(7).setCellValue(user.getNo());
            cell++;
        }

        String fileName = "user.xlsx";
        String PATH = "D://";
        FileOutputStream outputStream = new FileOutputStream(PATH + fileName);
        workbook.write(outputStream);
        outputStream.close();
        //清除临时文件
        ((SXSSFWorkbook) workbook).dispose();
    }
}