java Excel表格导出

1.使用alibaba的easyexcel导出；导入easyexcel包

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.1.1</version>
        </dependency>

代码如下：

 //封装头部信息
 List<List<String>> head = new ArrayList<>();
 head.add(Arrays.asList("名称"));
 head.add(Arrays.asList("年龄"));
 //设置导出文件名称 
 StringBuilder filename = new StringBuilder();
 filename.append("user_");
 filename.append(DateUtil.getDate("yyyyMMdd"));
 //设置sheet名称
 String sheetName="信息";
 try {
      ExcelWriter excelWriter = 
      EasyExcel.write(response.getOutputStream()).registerWriteHandler(
      new LongestMatchColumnWidthStyleStrategy()).build();
      response.setContentType("application/vnd.ms-excel");
      response.setCharacterEncoding("utf-8");
      response.setHeader("Content-disposition", "attachment;filename=" + filename + 
      ".xlsx");
      WriteSheet writeSheet = EasyExcel.writerSheet(0, sheetName).head(head).build();
      //查询user信息，需要导出内容
      User user=new User();   
      data.add(user.getName());
      data.add(user.getAge());
      excelWriter.write(datas, writeSheet);
       excelWriter.finish();
      } catch (Exception e) {
        ExportExcel.createFailResponse(response, e);
        }
  }