excel转pdf(解决导出的pdf和excel格式不一致问题)
程序员文章站
2022-07-14 17:04:36
...
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;
}