Using jacob to operate the office

来源：互联网发布：C语言求主析取范式编辑：程序博客网时间：2024/06/08 05:44

First:

add jacob.jar to the classpath

Second:

add copy the jacob-version.dll to %SystemRoot%/system32

Third:

package com.synnex.jacob;import com.jacob.activeX.ActiveXComponent;import com.jacob.com.Dispatch;import com.jacob.com.Variant;public class JacobUtil {public static final int WORD_HTML = 8;public static final int WORD_TXT = 7;public static final int EXCEL_HTML = 44;/** * * WORD转HTML * * @param docfile * WORD文件全路径 * * @param htmlfile * 转换后HTML存放路径 * */public static void wordToHtml(String docfile, String htmlfile) {ActiveXComponent app = new ActiveXComponent("Word.Application"); // 启动wordtry {app.setProperty("Visible", new Variant(false));Dispatch docs = app.getProperty("Documents").toDispatch();Dispatch doc = Dispatch.invoke(docs, "Open", Dispatch.Method, new Object[] { docfile, new Variant(false), new Variant(true) }, new int[1]).toDispatch();Dispatch.invoke(doc, "SaveAs", Dispatch.Method, new Object[] { htmlfile, new Variant(WORD_HTML) }, new int[1]);Variant f = new Variant(false);Dispatch.call(doc, "Close", f);} catch (Exception e) {e.printStackTrace();} finally {app.invoke("Quit", new Variant[] {});}}/** * * EXCEL转HTML * * @param xlsfile * EXCEL文件全路径 * * @param htmlfile * 转换后HTML存放路径 * */public static void excelToHtml(String xlsfile, String htmlfile) {ActiveXComponent app = new ActiveXComponent("Excel.Application"); // 启动wordtry {app.setProperty("Visible", new Variant(false));Dispatch excels = app.getProperty("Workbooks").toDispatch();Dispatch excel = Dispatch.invoke(excels, "Open", Dispatch.Method, new Object[] { xlsfile, new Variant(false), new Variant(true) }, new int[1]).toDispatch();Dispatch.invoke(excel, "SaveAs", Dispatch.Method, new Object[] { htmlfile, new Variant(EXCEL_HTML) }, new int[1]);Variant f = new Variant(false);Dispatch.call(excel, "Close", f);} catch (Exception e) {e.printStackTrace();} finally {app.invoke("Quit", new Variant[] {});}}}

Fourth:

invoke the method

public static void main(String[] args) {JacobUtil.excelToHtml("c://RRS-Glossary.xls", "c://RRS-Glossary.html");}