导出PDF

1.前端

/** * 导出消毒安全操作表 */ function exportTable() { var row = $('#archviesDisinfectionTask_selectMission_dg').datagrid('getSelected'); if(row){ window.open(basePath + "sterilize/exportPDF?batchSterilizer="+row.batchSterilizer); }else{ $.messager.alert('警告','请先选择要导出的记录','info'); } }

2.后端-制作表格

public void exportSecurityTableForPdf(String batchSterilizer,HttpServletResponse response) throws Exception{ //加载Excel文档 Workbook workbook = new Workbook(); Worksheet sheet = workbook.getWorksheets().get(0); //合并单元格范围A1到J1 sheet.getRange().get("A1:J1").merge(); sheet.getCellRange("A1").setText("消毒安全操作表"); sheet.getCellRange("A1").getCellStyle().getExcelFont().setSize(16); //设置加粗 sheet.getCellRange("A1").getCellStyle().getExcelFont().isBold(true); //水平居中 sheet.getCellRange("A1").getCellStyle().setHorizontalAlignment(HorizontalAlignType.Center); //自动换行 sheet.getCellRange("A1").getCellStyle().setWrapText(true); //设置行高 sheet.getCellRange("A1:J1").setRowHeight(25); //设置名称 sheet.getCellRange("A2").setText("日期"); // sheet.getCellRange("A2").getCellStyle().getExcelFont().setFontName("Comic Sans MS"); sheet.getCellRange("B2").setText("档案编号"); sheet.getCellRange("C2").setText("消毒开始时间(40分钟)"); sheet.getCellRange("D2").setText("消毒结束时间"); sheet.getCellRange("E2").setText("消毒浓度(0.2mg/m³)"); sheet.getCellRange("F2").setText("分解臭氧开始时间(20分钟)"); sheet.getCellRange("G2").setText("分解臭氧结束时间"); sheet.getCellRange("H2").setText("分解后臭氧浓度(oppm)"); sheet.getCellRange("I2").setText("操作员"); sheet.getCellRange("J2").setText("负责人"); List<InventoryCheckAccpet> listtList = inventoryCheckAccpetRepository.securityTable(batchSterilizer); SterilizeInformationRoom sterilizeInformationRoom = sterilizeInformationRoomRepository.securityTable(batchSterilizer); int i = 0; for ( i = 0; i < listtList.size(); i++) { LocalDateTime dateTime = listtList.get(i).getEnterSterilizerRoom(); if (dateTime==null) { sheet.getCellRange("A"+(i+3)+"").setText(""); }else { DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); String localTime = df.format(dateTime); sheet.getCellRange("A"+(i+3)+"").setText(localTime); } sheet.getCellRange("B"+(i+3)+"").setText(listtList.get(i).getArchivesChestNo()); if (sterilizeInformationRoom!=null) { sheet.getCellRange("C"+(i+3)+"").setText(sterilizeInformationRoom.getSterilizeBeginTime()+""); sheet.getCellRange("D"+(i+3)+"").setText(sterilizeInformationRoom.getSterilizeEndTime()+""); sheet.getCellRange("E"+(i+3)+"").setText(sterilizeInformationRoom.getConcentration()); sheet.getCellRange("F"+(i+3)+"").setText(sterilizeInformationRoom.getOzenBenginTime()+""); sheet.getCellRange("G"+(i+3)+"").setText(sterilizeInformationRoom.getOzenEndTime()+""); sheet.getCellRange("H"+(i+3)+"").setText(sterilizeInformationRoom.getAfterOzen()); sheet.getCellRange("I"+(i+3)+"").setText(sterilizeInformationRoom.getOperator()); sheet.getCellRange("J"+(i+3)+"").setText(sterilizeInformationRoom.getPrincipal()); } } i = i+2; //水平居中 sheet.getCellRange("A2:J"+i).getCellStyle().setHorizontalAlignment(HorizontalAlignType.Center); //自动换行 sheet.getCellRange("A2:J"+i).getCellStyle().setWrapText(true); //获取需要设置边框的单元格范围 CellRange cr = sheet.getCellRange(sheet.getFirstRow(), sheet.getFirstColumn(), sheet.getLastRow(), sheet.getLastColumn()); //设置边框样式 cr.getBorders().setLineStyle(LineStyleType.Thin); cr.getBorders().getByBordersLineType(BordersLineType.DiagonalDown).setLineStyle(LineStyleType.None); cr.getBorders().getByBordersLineType(BordersLineType.DiagonalUp).setLineStyle(LineStyleType.None); cr.getBorders().setColor(Color.BLACK); //将第四列的列宽设为20 String fileName = "消毒安全操作表("+batchSterilizer+").pdf"; //调用方法保存为PDF格式 workbook.saveToFile(fileName,FileFormat.PDF); //读取d盘的file1文件 // File file = new File("d:/ToPDF.pdf"); //读取指定路径下面的文件 InputStream in = new FileInputStream(fileName); //创建存放文件内容的数组 byte[] buff =new byte[1024]; //所读取的内容使用n来接收 int n; // 清空response response.reset(); // 设置response的Header response.setContentType("application/octet-stream"); response.setHeader("Content-disposition", "attachment;filename=" +java.net.URLEncoder.encode(fileName, "UTF-8")); response.flushBuffer(); //当没有读取完时,继续读取,循环 OutputStream ouputStream = new BufferedOutputStream(response.getOutputStream()); while((n=in.read(buff))!=-1){ //将字节数组的数据全部写入到输出流中 ouputStream.write(buff,0,n); } //强制将缓存区的数据进行输出 ouputStream.flush(); //关流 ouputStream.close(); in.close(); deleteFile(fileName); } /** * 删除文件 * * @param pathname * @return * @throws IOException */ public static boolean deleteFile(String pathname){ boolean result = false; File file = new File(pathname); System.out.println(file.getAbsolutePath()); if (file.exists()) { file.delete(); result = true; System.out.println("文件已经被成功删除"); } return result; }

3.效果图