SXSSFWorkbook使用课件完整版.pdfVIP

SXSSFWorkbook使使⽤⽤ // 1.导⼊excel模板 String targetPath = rs.getSession().getServletContext() .getRealPath(/excelModel/ + fileNa e + .xlsx); // 2.创建⼀个workbook，对应⼀个Excel⽂件 File fi = new File(targetPath); FileInputStrea is = new FileInputStrea (fi); XSSFWorkbook wb = new XSSFWorkbook(is); int lastRow Nu =wb.getSheetAt(0).getLastRow Nu (); if(fileNa e.contains(横向明细)){ wb.getSheetAt(0).getRow (3).getCell(0).setCellValue(分配期号：+hx xFpqh); } SXSSFWorkbook sxssfWorkbook = new SXSSFWorkbook(wb,1000); Sheet sheet = sxssfWorkbook.getSheetAt(0); // 开始填写查找出 的数据 w riteExcel(list, sheet ，lastRow Nu ); // 下载 tkDow nload2(sheetNa e, sxssfWorkbook, res); 2 public static void w riteExcel(List? list, Sheet sheet, int lastRow Nu ) throws IOException, IllegalArgu entException, IllegalAccessException { Row row ; for (int i = 0; i list.size(); i++) { row = sheet.createRow ((int) i + lastRow Nu + 1); row .createCell(0).setCellValue(i + 1); Object tj b = list.get(i); Class class1 = (Class) tj b.getClass(); Field[] fs = class1.getDeclaredFields(); for (int j = 1; j fs.length; j ++) { Field f = fs[j]; f.setAccessible(true); Object v = f.get(tj b); String type = f.getType().toString(); if (v == null || v.toString() == ) { row .createCell(j).setCellValue(); } else { if (type.endsWith(Double) || type.endsWith(double)) { row .createCell(j).setCellValue( Double.parseDouble(v.toString())); } else if (type.endsWith(Integer) || type.endsWith(int)) { row .createCell(j).setCellValue( Double.parseDouble(v.toString())); } else if (type.endsWith(String)) { row .createCell(j).setCellValue(v.toString()); } } } } } 3 public static void tkDow nload2(String sheetNa e, SXSSFWorkbook wb, HttpServletResponse res) throws IOException { String f