3.11 poi导出大量数据(最多导入65536条)

1pom文件

    <!-- POI-->

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.11</version>

</dependency>

2自己定义一个方法,需要request,response参数(我的是jsp开发,就不用写方法)

<%

String filename=new String("客户表.xls".getBytes(),"ISO-8859-1");
response.setHeader("Content-Disposition", "attachment;filename="+filename);
ServletOutputStream sos = response.getOutputStream();
HSSFWorkbook book=new HSSFWorkbook();