jacob java excel_Java 使用jacob 工具 实现excel 转 pdf （仅适用于windows）

private static final Integer WORD_TO_PDF_OPERAND = 17;private static final Integer PPT_TO_PDF_OPERAND = 32;private static final Integer EXCEL_TO_PDF_OPERAND = 0;private void doc2pdf(String srcFilePath, String pdfFilePath) throwsException {

ActiveXComponent app= null;

Dispatch doc= null;try{

ComThread.InitSTA();

app= new ActiveXComponent("Word.Application");

app.setProperty("Visible", false);

Dispatch docs= app.getProperty("Documents").toDispatch();

Object[] obj= newObject[]{

srcFilePath,new Variant(false),new Variant(false),//是否只读

new Variant(false),new Variant("pwd")

};

doc= Dispatch.invoke(docs, "Open", Dispatch.Method, obj, new int[1]).toDispatch();//Dispatch.put(doc, "Compatibility", false);//兼容性检查,为特定值false不正确

Dispatch.put(doc, "RemovePersonalInformation", false);

Dispatch.call(doc,"ExportAsFixedFormat", pdfFilePath, WORD_TO_PDF_OPERAND); //word保存为pdf格式宏，值为17

}catch(Exception e) {

e.printStackTrace();throwe;

}finally{if (doc != null) {

Dispatch.call(doc,"Close", false);

}if (app != null) {

app.invoke("Quit", 0);

}

ComThread.Release();

}

}private void ppt2pdf(String srcFilePath, String pdfFilePath) throwsException {

ActiveXComponent app= null;

Dispatch ppt= null;try{

ComThread.InitSTA();

app= new ActiveXComponent("PowerPoint.Application");

Dispatch ppts= app.getProperty("Presentations").toDispatch();/** call

* param 4: ReadOnly

* param 5: Untitled指定文件是否有标题

* param 6: WithWindow指定文件是否可见

**/ppt= Dispatch.call(ppts, "Open", srcFilePath, true,true, false).toDispatch();

Dispatch.call(ppt,"SaveAs", pdfFilePath, PPT_TO_PDF_OPERAND); //ppSaveAsPDF为特定值32

}catch(Exception e) {

e.printStackTrace();throwe;

}finally{if (ppt != null) {

Dispatch.call(ppt,"Close");

}if (app != null) {

app.invoke("Quit");

}

ComThread.Release();

}

}private static boolean excel2Pdf(String inFilePath, String outFilePath) throwsException {

ActiveXComponent ax= null;

Dispatch excel= null;try{

ComThread.InitSTA();

ax= new ActiveXComponent("Excel.Application");

ax.setProperty("Visible", new Variant(false));

ax.setProperty("AutomationSecurity", new Variant(3)); //禁用宏

Dispatch excels= ax.getProperty("Workbooks").toDispatch();

Object[] obj= newObject[]{

inFilePath,new Variant(false),new Variant(false)

};

excel= Dispatch.invoke(excels, "Open", Dispatch.Method, obj, new int[9]).toDispatch();//将excel表格 设置成A3的大小

Dispatch sheets = Dispatch.call(excel, "Worksheets").toDispatch();

Dispatch sheet= Dispatch.call(sheets, "Item", new Integer(1)).toDispatch();

Dispatch pageSetup= Dispatch.call(sheet, "PageSetup").toDispatch();

Dispatch.put(pageSetup,"PaperSize", new Integer(8));//A3是8，A4是9，A5是11等等//转换格式

Object[] obj2 = newObject[]{new Variant(EXCEL_TO_PDF_OPERAND), //PDF格式=0

outFilePath,new Variant(0) //0=标准 (生成的PDF图片不会变模糊) ; 1=最小文件

};

Dispatch.invoke(excel,"ExportAsFixedFormat", Dispatch.Method,obj2, new int[1]);

}catch(Exception es) {

es.printStackTrace();return false;//throw es;

} finally{if (excel != null) {

Dispatch.call(excel,"Close", new Variant(false));

}if (ax != null) {

ax.invoke("Quit", newVariant[] {});

ax= null;

}

ComThread.Release();

}return true;

}