Excel导出demo

/**
 * 导出Excel
 *
 * @param sheetName sheet名称
 * @param title     标题
 * @param values    内容
 * @param wb        HSSFWorkbook对象
 * @return
 */
public static HSSFWorkbook getHSSFWorkbook(String sheetName, String[] title, String[][] values, HSSFWorkbook wb) {
    // 第一步，创建一个HSSFWorkbook，对应一个Excel文件
    if (wb == null) {
        wb = new HSSFWorkbook();
    }
    // 第二步，在workbook中添加一个sheet,对应Excel文件中的sheet
    HSSFSheet sheet = wb.createSheet(sheetName);
    // 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制
    HSSFRow row = sheet.createRow(0);
    // 第四步，创建单元格，并设置值表头 设置表头居中
    HSSFCellStyle style = wb.createCellStyle();
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式
    //声明列对象
    HSSFCell cell;
    //创建标题
    for (int i = 0; i < title.length; i++) {
        cell = row.createCell(i);
        cell.setCellValue(title[i]);
        cell.setCellStyle(style);
    }
    //创建内容
    if (null != values) {
        for (int i = 0; i < values.length; i++) {
            row = sheet.createRow(i + 1);
            for (int j = 0; j < values[i].length; j++) {
                //将内容按顺序赋给对应的列对象
                row.createCell(j).setCellValue(values[i][j]);
            }
        }
    }
    return wb;
}

/**
 * @Function PC工单列表导出
 * @author   chenqu
 * @Date     2019/8/19 10:24
 * @param
 * @return
 */
 @ApiOperation("PC工单列表导出")
 @RequestMapping(value = "/excel/workListDetailsVo", method = RequestMethod.POST)
 @ApiImplicitParams({
         @ApiImplicitParam(name = "token", value = "令牌", required = true, dataType = "String", paramType = "Header"),
         @ApiImplicitParam(name = "WorkListDetailsVo", value = "工单列表", dataType = "workListDetailsVo", paramType = "Body")
 })
 public void dervieExcelWorkListDetailsVo(
         @NotEmpty(message = Constants.TOKEN + "can't be empty")
         @RequestHeader String token, @RequestBody WorkListDetailsVo workListDetailsVo,HttpServletResponse response) throws IOException {
     final String[] REPORT_EXCEL_COLUMN = {
             "状态", "创建时间", "对象类型", "所属产线|站台", "设备编码", "机台号", "故障描述"};
      String fileName="设备维护工单管理报表.xlsx";
     HSSFWorkbook wb = null;
     try{
         List<WorkListDetailsVo> list = workListService.dervieExcelWorkListDetailsVo(workListDetailsVo, token);
         String[][] str = new String[list.size()][REPORT_EXCEL_COLUMN.length];
         for (int i = 0; i< list.size(); i++){
             WorkListDetailsVo worklist=list.get(i);
             str[i][0] = worklist.getWorkListStatusName();
             str[i][1] = worklist.getFormatDate();
             str[i][2] = worklist.getObjectType();
             str[i][3] = worklist.getTemplateDevGroupName();
             str[i][4] = worklist.getDeviceMId();
             str[i][5] = worklist.getMachineNo();
             str[i][6] = worklist.getProblemDescription();
         }
         wb= ExcelUtil.getHSSFWorkbook("设备维护工单管理报表", REPORT_EXCEL_COLUMN, str, null);
        // 这里必须用ISO8859-1重新编码，否则文件名里面的中文无法解析，会以下划线代替
          fileName=new String(fileName.getBytes(),"ISO8859-1");
         response.setContentType("application/vnd.ms-excel");
         response.setHeader("Content-Disposition", "attachment;filename="+ fileName);
         response.addHeader("Pargam", "no-cache");
         response.addHeader("Cache-Control", "no-cache");
         ServletOutputStream outputStream = response.getOutputStream();
         wb.write(outputStream);
         outputStream.flush();
         outputStream.close();
     }catch (Exception e){
         log.error(" XSSFWorkbook write excel error: ", e);
         throw new WorkListBaseException(Code.SYSTEM_ERROR.value(), "服务器内部出现错误");

     }
}