1 import java.io.FileOutputStream; 2 import java.util.ArrayList; 3 import java.util.List; 4 5 import org.apache.poi.hssf.usermodel.HSSFCell; 6 import org.apache.poi.hssf.usermodel.HSSFRow; 7 import org.apache.poi.hssf.usermodel.HSSFSheet; 8 import org.apache.poi.hssf.usermodel.HSSFWorkbook; 9 import org.poi.pojo.User; 10 11 /** 12 * POI导出excel Created by Ay on 2016/6/14. <dependency> 13 * <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> 14 * <version>3.14</version> </dependency> 15 */ 16 public class PoiToExcel { 17 18 public static void main(String[] args) { 19 20 List<String> arrayList = new ArrayList<String>(); 21 arrayList.add("编号"); 22 arrayList.add("姓名"); 23 arrayList.add("年龄"); 24 arrayList.add("性别"); 25 arrayList.add("手机号码"); 26 arrayList.add("居住地址"); 27 arrayList.add("工作地点"); 28 List<User> arrayList1 = new ArrayList<User>(); 29 30 for (int i = 0; i < 65535; i++) { 31 User user = new User(i, "梁家强", 23 + i, "男", 18888888888L, "甘肃平凉", "陕西西安"); 32 arrayList1.add(user); 33 } 34 35 // 新建excel报表 36 HSSFWorkbook excel = new HSSFWorkbook(); 37 // 添加一个sheet,名字叫"测试表" 38 for (int q = 0; q < 8; q++) { 39 HSSFSheet hssfSheet = excel.createSheet(q + ""); 40 HSSFRow hssfRow = hssfSheet.createRow(0); 41 for (int j = 0; j < arrayList.size(); j++) { 42 // 设置列宽 第一个参数是索引,从零开始 43 hssfSheet.setColumnWidth(j, 20 * 256); 44 // 创建列, 45 HSSFCell hssfCell = hssfRow.createCell(j); 46 // 往列里增加内容 47 hssfCell.setCellValue(arrayList.get(j)); 48 49 } 50 51 for (int i = 0; i < arrayList1.size(); i++) { 52 HSSFRow hssfRow1 = hssfSheet.createRow(i + 1); 53 54 for (int k = 0; k < arrayList.size(); k++) { 55 HSSFCell hssfCell1 = hssfRow1.createCell(k); 56 switch (k) { 57 case 0: 58 hssfCell1.setCellValue(arrayList1.get(i).getId()); 59 break; 60 case 1: 61 hssfCell1.setCellValue(arrayList1.get(i).getName()); 62 break; 63 case 2: 64 hssfCell1.setCellValue(arrayList1.get(i).getAge()); 65 break; 66 case 3: 67 hssfCell1.setCellValue(arrayList1.get(i).getSex()); 68 break; 69 case 4: 70 hssfCell1.setCellValue(arrayList1.get(i).getPhoneNum()); 71 break; 72 case 5: 73 hssfCell1.setCellValue(arrayList1.get(i).getHomeAddress()); 74 break; 75 case 6: 76 hssfCell1.setCellValue(arrayList1.get(i).getCompanyAddress()); 77 break; 78 } 79 80 } 81 82 } 83 84 } 85 86 // 往excel表格创建一行,excel的行号是从0开始的 87 88 // 设置行高 89 // hssfRow.setHeight((short) (20 * 50)); 90 91 FileOutputStream fout = null; 92 try { 93 // 用流将其写到D盘 94 fout = new FileOutputStream("F:/students.xls"); 95 excel.write(fout); 96 fout.close(); 97 } catch (Exception e) { 98 e.printStackTrace(); 99 } 100 101 } 102 }