excel转pdf(解决导出的pdf和excel格式不一致问题)
public static boolean getLicense() throws IOException { boolean result = false; InputStream is = null; try { is = ExcelToPDF.class.getClassLoader().getResourceAsStream("license.xml"); // license.xml应放在..\WebRoot\WEB-INF\classes路径下 License aposeLic = new License(); aposeLic.setLicense(is); result = true; } catch (Exception e) { e.printStackTrace(); }finally{ if(is!=null){ is.close(); } } return result; } /** * * @param pdfAddress pdf存储路径 * @param xlsAddress excel文件路径 * @return * @throws IOException */ public static String excelForwardpdf(String pdfAddress,String xlsAddress) throws IOException { if (!getLicense()) { // 验证License 若不验证则转化出的pdf文档会有水印产生 return "false"; } String result = "false"; FileOutputStream fileOS = null; try { File pdfFile = new File(pdfAddress);// 输出路径 Workbook wb = new Workbook(xlsAddress);// 原始excel路径 fileOS = new FileOutputStream(pdfFile); wb.save(fileOS, SaveFormat.PDF); result="success"; } catch (Exception e) { e.printStackTrace(); }finally{ if(fileOS!=null){ fileOS.close(); } } return result; }