程猿博客

所需poi的jar包： commons-collections4-4.1.jar poi-3.17.jar poi-examples-3.17.jar poi-excelant-3.17.jar poi-ooxml-3.17.jar poi-ooxml-schemas-3.17.jar poi-scratchpad-3.17.jar xmlbeans-2.6.0.jar maven项目，可以直接加pom配置： <!-- poi--> org.apache.commons commons-collections4 4.1 org.apache.poi poi 3.17 org.apache.poi poi-examples 3.17 org.apache.poi poi-excelant 3.17 org.apache.poi poi-ooxml 3.17 org.apache.poi poi-ooxml-schemas 3.17 org.apache.poi poi-scratchpad 3.17 org.apache.xmlbeans xmlbeans 2.6.0

基于jacob插件实现 word，excel，ppt 转换 pdf，如下所示： public void excel2pdf(String source, String target) { System.out.println("启动Excel"); long start = System.currentTimeMillis(); ActiveXComponent app = new ActiveXComponent("Excel.Application"); // 启动excel(Excel.Application) try { app.setProperty("Visible", false); Dispatch workbooks = app.getProperty("Workbooks").toDispatch(); System.out.println("打开文档" + source); Dispatch workbook = Dispatch.invoke(workbooks, "Open", Dispatch.Method, new Object[]{source, new Variant(false),new Variant(false)}, new int[3]).toDispatch(); Dispatch.invoke(workbook, "SaveAs", Dispatch.Method, new Object[] { target, new Variant(57), new Variant(false), new Variant(57), new Variant(57), new Variant(false), new Variant(true), new Variant(57), new Variant(true), new Variant(true), new Variant(true) }, new int[1]); Variant f = new Variant(false); System.out.println("转换文档到PDF " + target); Dispatch.call(workbook, "Close", f); long end = System.currentTimeMillis(); System.out.println("转换完成..用时：" + (end - start) + "ms."); } catch (Exception e) { System.out.println("========Error:文档转换失败：" + e.getMessage()); }finally { if (app != null){ app.invoke("Quit", new Variant[] {}); } } }