poi 3.11版本,最多65536条

来源：互联网发布：php .net哪个好编辑：程序博客网时间：2024/06/18 14:02

需求:点击按钮,下载user数据表中的所有数据到excel中

1.pom坐标

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

2.controller代码(下载excel)

String filename=new String("客户表.xlsx".getBytes(),"ISO-8859-1");   response.setHeader("Content-Disposition", "attachment;filename="+filename);   ServletOutputStream sos = response.getOutputStream();   HSSFWorkbook book=new HSSFWorkbook();   HSSFSheet sheet = book.createSheet();   Workbook wb = new SXSSFWorkbook(100);   HSSFRow titlerow = sheet.createRow(0);   //设置标题   titlerow.createCell(0).setCellValue("编号");   titlerow.createCell(1).setCellValue("公司名称");   titlerow.createCell(2).setCellValue("姓名");   titlerow.createCell(3).setCellValue("部门");   titlerow.createCell(4).setCellValue("email");   titlerow.createCell(5).setCellValue("邮政编码");   titlerow.createCell(6).setCellValue("地址");   titlerow.createCell(7).setCellValue("次行业");   List<User> list = $userService().getAll();   for(int i=0;i<list.size();i++){      User user = list.get(i);      HSSFRow datarow = sheet.createRow(i+1);      datarow.createCell(0).setCellValue(user.getId());      datarow.createCell(1).setCellValue(user.getCompanyName());      datarow.createCell(2).setCellValue(user.getName());      datarow.createCell(3).setCellValue(user.getDept());      datarow.createCell(4).setCellValue(user.getEmaill());      datarow.createCell(5).setCellValue(user.getPostalcode());      datarow.createCell(6).setCellValue(user.getAddress());      datarow.createCell(7).setCellValue(user.getSecondIndustry());   }   book.write(sos);} catch(Exception e){   e.printStackTrace();}

3.前端写一个界面,点击访问此类即可

0 0