jacob用法简介

2019-11-14 21:39:57

字体：大中小

来源：转载

供稿：网友

jacob用法简介

原创作品，允许转载，转载时请务必以超链接形式标明文章原始出处、作者信息和本声明。否则将追究法律责任。http://xiaoduan.blog.51cto.com/502137/136692

现在我们一起来看看，用java如何操作Microsoft Word。jacob，官网是http://danadler.com/jacob这是一个开源的工具。最新版本1.7官方的解释是：The JACOB PRoject: A JAva-COM Bridge这是官方对下载文件的说明：

jacob.jar:a JAR file for the java classes which you must add to your CLASSPATH. The package names replace com.ms with com.jacob (for example com.ms.com.Variant maps to com.jacob.com.Variant.
jacob.dll:a small Win32 DLL which you must add to your PATH.
samples:provided in Java source and compiled form to demonstrate various features of the product. In particular, a set of wrapper classes for Microsoft® ADO are provided as samples.

开发环境：JDK 1.6MyEclipse Enterprise Workbench Version: 7.0 Milestone-1Tomcat 5.5.27现在MyEclipse中新建一个项目jacob，将jacob的jar包放到该项目的类库中。我的jacob版本是1.14.3 。 Snap10

下面这一步非常重要，就是拷贝jacob目录中jacob-1.14.3-x86.dll文件到系统环境变量目录中一般情况就放在当前jdk中bin目录下。 Snap14

这里有一个MSWordManager 类，是jacob官方发布的工具类，里面有大多数Java操作MS Office的工具。packagecom.test;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;importjava.util.ArrayList;importjava.util.List;importcom.jacob.activeX.ActiveXComponent;importcom.jacob.com.Dispatch;importcom.jacob.com.Variant;publicclassMSWordManager {// word文档privateDispatch doc;// word运行程序对象privateActiveXComponent word;// 所有word文档集合privateDispatch documents;// 选定的范围或插入点privateDispatch selection;privatebooleansaveOnExit =true;/** *//** * * @param visible 为true表示word应用程序可见 */publicMSWordManager(booleanvisible) {if(word ==null) { word =newActiveXComponent("Word.application"); word.setProperty("Visible",newVariant(visible)); }if(documents ==null) documents = word.getProperty("Documents").toDispatch(); }/** *//** * 设置退出时参数 * * @param saveOnExit boolean true-退出时保存文件，false-退出时不保存文件 */publicvoidsetSaveOnExit(booleansaveOnExit) {this.saveOnExit = saveOnExit; }/** *//** * 创建一个新的word文档 * */publicvoidcreateNewDocument() { doc = Dispatch.call(documents,"Add").toDispatch(); selection = Dispatch.get(word,"Selection").toDispatch(); }/** *//** * 打开一个已存在的文档 * * @param docPath */publicvoidopenDocument(String docPath) { closeDocument(); doc = Dispatch.call(documents,"Open", docPath).toDispatch(); selection = Dispatch.get(word,"Selection").toDispatch(); }/** *//** * 把选定的内容或插入点向上移动 * * @param pos 移动的距离 */publicvoidmoveUp(intpos) {if(selection ==null) selection = Dispatch.get(word,"Selection").toDispatch();for(inti = 0; i < pos; i++) Dispatch.call(selection,"MoveUp"); }/** *//** * 把选定的内容或者插入点向下移动 * * @param pos 移动的距离 */publicvoidmoveDown(intpos) {if(selection ==null) selection = Dispatch.get(word,"Selection").toDispatch();for(inti = 0; i < pos; i++) Dispatch.call(selection,"MoveDown"); }/** *//** * 把选定的内容或者插入点向左移动 * * @param pos 移动的距离 */publicvoidmoveLeft(intpos) {if(selection ==null) selection = Dispatch.get(word,"Selection").toDispatch();for(inti = 0; i < pos; i++) { Dispatch.call(selection,"MoveLeft"); } }/** *//** * 把选定的内容或者插入点向右移动 * * @param pos 移动的距离 */publicvoidmoveRight(intpos) {if(selection ==null) selection = Dispatch.get(word,"Selection").toDispatch();for(inti = 0; i < pos; i++) Dispatch.call(selection,"MoveRight"); }/** *//** * 把插入点移动到文件首位置 * */publicvoidmoveStart() {if(selection ==null) selection = Dispatch.get(word,"Selection").toDispatch(); Dispatch.call(selection,"HomeKey",newVariant(6)); }publicvoidmoveEnd() {if(selection ==null) selection = Dispatch.get(word,"Selection").toDispatch(); Dispatch.call(selection,"EndKey",newVariant(6)); }/** *//** * 从选定内容或插入点开始查找文本 * * @param toFindText 要查找的文本 * @return boolean true-查找到并选中该文本，false-未查找到文本 */publicbooleanfind(String toFindText) {if(toFindText ==null|| toFindText.equals(""))returnfalse;// 从selection所在位置开始查询 Dispatch find = word.call(selection,"Find").toDispatch();// 设置要查找的内容 Dispatch.put(find,"Text", toFindText);// 向前查找 Dispatch.put(find,"Forward","True");// 设置格式 Dispatch.put(find,"Format","True");// 大小写匹配 Dispatch.put(find,"MatchCase","True");// 全字匹配 Dispatch.put(find,"MatchWholeWord","True");// 查找并选中returnDispatch.call(find,"Execute").getBoolean(); }/** *//** * 把选定选定内容设定为替换文本 * * @param toFindText 查找字符串 * @param newText 要替换的内容 * @return */publicbooleanreplaceText(String toFindText, String newText) {if(!find(toFindText))returnfalse; Dispatch.put(selection,"Text", newText);returntrue; }/** *//** * 全局替换文本 * * @param toFindText 查找字符串 * @param newText 要替换的内容 */publicvoidreplaceAllText(String toFindText, String newText) {while(find(toFindText)) { Dispatch.put(selection,"Text", newText); Dispatch.call(selection,"MoveRight"); } }/** *//** * 在当前插入点插入字符串 * * @param newText 要插入的新字符串 */publicvoidinsertText(String newText) { Dispatch.put(selection,"Text", newText); }/** *//** * * @param toFindText 要查找的字符串 * @param imagePath 图片路径 * @return */publicbooleanreplaceImage(String toFindText, String imagePath) {if(!find(toFindText))returnfalse; Dispatch.call(Dispatch.get(selection,"InLineShapes").toDispatch(),"AddPicture", imagePath);returntrue; }/** *//** * 全局替换图片 * * @param toFindText 查找字符串 * @param imagePath 图片路径 */publicvoidreplaceAllImage(String toFindText, String imagePath) {while(find(toFindText)) { Dispatch.call(Dispatch.get(selection,"InLineShapes").toDispatch(),"AddPicture", imagePath); Dispatch.call(selection,"MoveRight"); } }/** *//** * 在当前插入点插入图片 * * @param imagePath 图片路径 */publicvoidinsertImage(String imagePath) { Dispatch.call(Dispatch.get(selection,"InLineShapes").toDispatch(),"AddPicture", imagePath); }/** *//** * 合并单元格 * * @param tableIndex * @param fstCellRowIdx * @param fstCellColIdx * @param secCellRowIdx * @param secCellColIdx */publicvoidmergeCell(inttableIndex,intfstCellRowIdx,intfstCellColIdx,intsecCellRowIdx,intsecCellColIdx) {// 所有表格 Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch(); Dispatch fstCell = Dispatch.call(table,"Cell",newVariant(fstCellRowIdx),newVariant(fstCellColIdx)) .toDispatch(); Dispatch secCell = Dispatch.call(table,"Cell",newVariant(secCellRowIdx),newVariant(secCellColIdx)) .toDispatch(); Dispatch.call(fstCell,"Merge", secCell); }/** *//** * 在指定的单元格里填写数据 * * @param tableIndex * @param cellRowIdx * @param cellColIdx * @param txt */publicvoidputTxtToCell(inttableIndex,intcellRowIdx,intcellColIdx, String txt) {// 所有表格 Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch(); Dispatch cell = Dispatch.call(table,"Cell",newVariant(cellRowIdx),newVariant(cellColIdx)).toDispatch(); Dispatch.call(cell,"Select"); Dispatch.put(selection,"Text", txt); }/** *//** * 在当前文档拷贝数据 * * @param pos */publicvoidcopy(String toCopyText) { moveStart();if(this.find(toCopyText)) { Dispatch textRange = Dispatch.get(selection,"Range").toDispatch(); Dispatch.call(textRange,"Copy"); } }/** *//** * 在当前文档粘帖剪贴板数据 * * @param pos */publicvoidpaste(String pos) { moveStart();if(this.find(pos)) { Dispatch textRange = Dispatch.get(selection,"Range").toDispatch(); Dispatch.call(textRange,"Paste"); } }/** *//** * 在当前文档指定的位置拷贝表格 * * @param pos 当前文档指定的位置 * @param tableIndex 被拷贝的表格在word文档中所处的位置 */publicvoidcopyTable(String pos,inttableIndex) { Dispatch tables = Dispatch.get(doc,"Tables").toDispatch(); Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch(); Dispatch range = Dispatch.get(table,"Range").toDispatch(); Dispatch.call(range,"Copy");if(this.find(pos)) { Dispatch textRange = Dispatch.get(selection,"Range").toDispatch(); Dispatch.call(textRange,"Paste"); } }/** *//** * 在当前文档末尾拷贝来自另一个文档中的段落 * * @param anotherDocPath 另一个文档的磁盘路径 * @param tableIndex 被拷贝的段落在另一格文档中的序号(从1开始) */publicvoidcopyParagraphFromAnotherDoc(String anotherDocPath,intparagraphIndex) { Dispatch wordContent = Dispatch.get(doc,"Content").toDispatch();// 取得当前文档的内容 Dispatch.call(wordContent,"InsertAfter","$selection$");// 插入特殊符定位插入点 copyParagraphFromAnotherDoc(anotherDocPath, paragraphIndex,"$selection$"); }/** *//** * 在当前文档指定的位置拷贝来自另一个文档中的段落 * * @param anotherDocPath 另一个文档的磁盘路径 * @param tableIndex 被拷贝的段落在另一格文档中的序号(从1开始) * @param pos 当前文档指定的位置 */publicvoidcopyParagraphFromAnotherDoc(String anotherDocPath,intparagraphIndex, String pos) { Dispatch doc2 =null;try{ doc2 = Dispatch.call(documents,"Open", anotherDocPath) .toDispatch(); Dispatch paragraphs = Dispatch.get(doc2,"Paragraphs").toDispatch(); Dispatch paragraph = Dispatch.call(paragraphs,"Item",newVariant(paragraphIndex)).toDispatch(); Dispatch range = Dispatch.get(paragraph,"Range").toDispatch(); Dispatch.call(range,"Copy");if(this.find(pos)) { Dispatch textRange = Dispatch.get(selection,"Range") .toDispatch(); Dispatch.call(textRange,"Paste"); } }catch(Exception e) { e.printStackTrace(); }finally{if(doc2 !=null) { Dispatch.call(doc2,"Close",newVariant(saveOnExit)); doc2 =null; } } }/** *//** * 在当前文档指定的位置拷贝来自另一个文档中的表格 * * @param anotherDocPath 另一个文档的磁盘路径 * @param tableIndex 被拷贝的表格在另一格文档中的序号(从1开始) * @param pos 当前文档指定的位置 */publicvoidcopyTableFromAnotherDoc(String anotherDocPath,inttableIndex, String pos) { Dispatch doc2 =null;try{ doc2 = Dispatch.call(documents,"Open", anotherDocPath) .toDispatch(); Dispatch tables = Dispatch.get(doc2,"Tables").toDispatch(); Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)).toDispatch(); Dispatch range = Dispatch.get(table,"Range").toDispatch(); Dispatch.call(range,"Copy");if(this.find(pos)) { Dispatch textRange = Dispatch.get(selection,"Range") .toDispatch(); Dispatch.call(textRange,"Paste"); } }catch(Exception e) { e.printStackTrace(); }finally{if(doc2 !=null) { Dispatch.call(doc2,"Close",newVariant(saveOnExit)); doc2 =null; } } }/** *//** * 在当前文档指定的位置拷贝来自另一个文档中的图片 * * @param anotherDocPath 另一个文档的磁盘路径 * @param shapeIndex 被拷贝的图片在另一格文档中的位置 * @param pos 当前文档指定的位置 */publicvoidcopyImageFromAnotherDoc(String anotherDocPath,intshapeIndex, String pos) { Dispatch doc2 =null;try{ doc2 = Dispatch.call(documents,"Open", anotherDocPath) .toDispatch(); Dispatch shapes = Dispatch.get(doc2,"InLineShapes").toDispatch(); Dispatch shape = Dispatch.call(shapes,"Item",newVariant(shapeIndex)).toDispatch(); Dispatch imageRange = Dispatch.get(shape,"Range").toDispatch(); Dispatch.call(imageRange,"Copy");if(this.find(pos)) { Dispatch textRange = Dispatch.get(selection,"Range") .toDispatch(); Dispatch.call(textRange,"Paste"); } }catch(Exception e) { e.printStackTrace(); }finally{if(doc2 !=null) { Dispatch.call(doc2,"Close",newVariant(saveOnExit)); doc2 =null; } } }/** *//** * 创建表格 * * @param pos 位置 * @param cols 列数 * @param rows 行数 */publicvoidcreateTable(intnumCols,intnumRows){//(String pos, int numCols, int numRows) {// if (!find(pos)) { Dispatch tables = Dispatch.get(doc,"Tables").toDispatch(); Dispatch range = Dispatch.get(selection,"Range").toDispatch(); Dispatch newTable = Dispatch.call(tables,"Add", range,newVariant(numRows),newVariant(numCols)).toDispatch(); Dispatch.call(selection,"MoveRight"); moveEnd();// } }/** *//** * 在指定行前面增加行 * * @param tableIndex word文件中的第N张表(从1开始) * @param rowIndex 指定行的序号(从1开始) */publicvoidaddTableRow(inttableIndex,introwIndex) {// 所有表格 Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch();// 表格的所有行 Dispatch rows = Dispatch.get(table,"Rows").toDispatch(); Dispatch row = Dispatch.call(rows,"Item",newVariant(rowIndex)) .toDispatch(); Dispatch.call(rows,"Add",newVariant(row)); }/** *//** * 在第1行前增加一行 * * @param tableIndex word文档中的第N张表(从1开始) */publicvoidaddFirstTableRow(inttableIndex) {// 所有表格 Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch();// 表格的所有行 Dispatch rows = Dispatch.get(table,"Rows").toDispatch(); Dispatch row = Dispatch.get(rows,"First").toDispatch(); Dispatch.call(rows,"Add",newVariant(row)); }/** *//** * 在最后1行前增加一行 * * @param tableIndex * word文档中的第N张表(从1开始) */publicvoidaddLastTableRow(inttableIndex) {// 所有表格 Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch();// 表格的所有行 Dispatch rows = Dispatch.get(table,"Rows").toDispatch(); Dispatch row = Dispatch.get(rows,"Last").toDispatch(); Dispatch.call(rows,"Add",newVariant(row)); }/** *//** * 增加一行 * * @param tableIndex word文档中的第N张表(从1开始) */publicvoidaddRow(inttableIndex) { Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch();// 表格的所有行 Dispatch rows = Dispatch.get(table,"Rows").toDispatch(); Dispatch.call(rows,"Add"); }/** *//** * 增加一列 * * @param tableIndex word文档中的第N张表(从1开始) */publicvoidaddCol(inttableIndex) {// 所有表格 Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch();// 表格的所有行 Dispatch cols = Dispatch.get(table,"Columns").toDispatch(); Dispatch.call(cols,"Add").toDispatch(); Dispatch.call(cols,"AutoFit"); }/** *//** * 在指定列前面增加表格的列 * * @param tableIndex word文档中的第N张表(从1开始) * @param colIndex 指定列的序号 (从1开始) */publicvoidaddTableCol(inttableIndex,intcolIndex) {// 所有表格 Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch();// 表格的所有行 Dispatch cols = Dispatch.get(table,"Columns").toDispatch(); System.out.println(Dispatch.get(cols,"Count")); Dispatch col = Dispatch.call(cols,"Item",newVariant(colIndex)) .toDispatch();// Dispatch col = Dispatch.get(cols, "First").toDispatch(); Dispatch.call(cols,"Add", col).toDispatch(); Dispatch.call(cols,"AutoFit"); }/** *//** * 在第1列前增加一列 * * @param tableIndex word文档中的第N张表(从1开始) */publicvoidaddFirstTableCol(inttableIndex) { Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch();// 表格的所有行 Dispatch cols = Dispatch.get(table,"Columns").toDispatch(); Dispatch col = Dispatch.get(cols,"First").toDispatch(); Dispatch.call(cols,"Add", col).toDispatch(); Dispatch.call(cols,"AutoFit"); }/** *//** * 在最后一列前增加一列 * * @param tableIndex word文档中的第N张表(从1开始) */publicvoidaddLastTableCol(inttableIndex) { Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();// 要填充的表格 Dispatch table = Dispatch.call(tables,"Item",newVariant(tableIndex)) .toDispatch();// 表格的所有行 Dispatch cols = Dispatch.get(table,"Columns").toDispatch(); Dispatch col = Dispatch.get(cols,"Last").toDispatch(); Dispatch.call(cols,"Add", col).toDispatch(); Dispatch.call(cols,"AutoFit"); }/** *//** * 自动调整表格 * */publicvoidautoFitTable() { Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();intcount = Dispatch.get(tables,"Count").toInt();for(inti = 0; i < count; i++) { Dispatch table = Dispatch.call(tables,"Item",newVariant(i + 1)) .toDispatch(); Dispatch cols = Dispatch.get(table,"Columns").toDispatch(); Dispatch.call(cols,"AutoFit"); } }/** *//** * 调用word里的宏以调整表格的宽度,其中宏保存在document下 * */publicvoidcallWordMacro() { Dispatch tables = Dispatch.get(doc,"Tables").toDispatch();intcount = Dispatch.get(tables,"Count").toInt(); Variant vMacroName =newVariant("Normal.NewMacros.tableFit"); Variant vParam =newVariant("param1"); Variant para[] =newVariant[] { vMacroName };for(inti = 0; i < para.length; i++) { Dispatch table = Dispatch.call(tables,"Item",newVariant(i + 1)) .toDispatch(); Dispatch.call(table,"Select"); Dispatch.call(word,"Run","tableFitContent"); } }/** *//** * 设置当前选定内容的字体 * * @param boldSize * @param italicSize * @param underLineSize 下划线 * @param colorSize 字体颜色 * @param size 字体大小 * @param name 字体名称 */publicvoidsetFont(booleanbold,booleanitalic,booleanunderLine, String colorSize, String size, String name) { Dispatch font = Dispatch.get(selection,"Font").toDispatch(); Dispatch.put(font,"Name",newVariant(name)); Dispatch.put(font,"Bold",newVariant(bold)); Dispatch.put(font,"Italic",newVariant(italic)); Dispatch.put(font,"Underline",newVariant(underLine)); Dispatch.put(font,"Color", colorSize); Dispatch.put(font,"Size", size); }/** *//** * 文件保存或另存为 * * @param savePath 保存或另存为路径 */publicvoidsave(String savePath) { Dispatch.call( (Dispatch) Dispatch.call(word,"WordBasic").getDispatch(),"FileSaveAs", savePath); }/** *//** * 关闭当前word文档 * */publicvoidcloseDocument() {if(doc !=null) { Dispatch.call(doc,"Save"); Dispatch.call(doc,"Close",newVariant(saveOnExit)); doc =null; } }/** *//** * 关闭全部应用 * */publicvoidclose() { closeDocument();if(word !=null) { Dispatch.call(word,"Quit"); word =null; } selection =null; documents =null; }/** *//** * 打印当前word文档 * */publicvoidprintFile() {if(doc !=null) { Dispatch.call(doc,"PrintOut"); } }publicstaticvoidmain(String args[])throwsException { MSWordManager msWordManager =newMSWordManager(true); msWordManager.createNewDocument(); msWordManager.insertText("aaaaaaaaaaaaaaaaaaaaa"); msWordManager.moveEnd(); msWordManager.close(); }}新建一个类T，来测试一下jacob是否能用，代码如下packagecom.test;publicclassT {publicstaticvoidmain(String[] args) {// TODO Auto-generated method stub MSWordManager ms=newMSWordManager(true);//生成一个MSwordManager对象,并且设置显示Word程序 ms.createNewDocument();//创建一个新的.doc文件 ms.insertText("Test jacob");//插入文本 ms.save("c://1.doc");//保存.doc文件 ms.close(); ms.closeDocument(); }}运行后C盘生成了1.doc文件， Snap16

这样也是没有实际意义，所以我们要加入数据库。数据库依然是DB2 9.5 ，用户名db2admin 密码abc 表名admin我在这个项目中添加了Hibernate框架，Java程序代码如下packagecom.dao;importjava.util.List;publicclassTest {publicstaticvoidmain(String[] args) { AdminDAO dao =newAdminDAO(); List list = dao.findAll(); MSWordManager ms=newMSWordManager(false); ms.createNewDocument();for(inti=1;i<=list.size();i++){ Admin admin = (Admin)list.get(1); ms.insertText(admin.getName()); ms.insertText("本文章由jacob自动生成"); ms.moveEnd(); } ms.save("c://1.doc"); ms.closeDocument(); ms.close(); }}运行程序后，进入c盘，打开生成的1.doc文件。 Snap17