jacob大部分方法封装类

package com.bjsasc.avidm.avplan.evaluate.util;import java.io.File;import java.util.ArrayList;import java.util.HashMap;import java.util.Iterator;import com.jacob.activeX.ActiveXComponent; import FailException; import Thread;import .Dispatch;import .Variant;public class EvaluateJacobWordUtil {/** Word应用对象*/private ActiveXComponent wordApplication;/** 所有文档对象*/private Dispatch wdDocuments;/** 当前活动文档对象*/private Dispatch wdDocument;/** 当前选择范围*/private Dispatch wdSelection;/** 所有表格对象*/private Dispatch wdTables;/** 当前表格对象*/private Dispatch wdTable;/** 单元格对象*/private Dispatch tbCell;/** 所有书签对象*/private Dispatch wdBookmarks;/** 当前书签对象*/private Dispatch wdBookmark;/** empty */private Dispatch range;/** word是否以可视化方式运行*/private static boolean wdVisible = false;public void setVisible(boolean visible){wdVisible = visible;}/*** 启动Word应用,并调用ComThread.InitSTA()方法*/private void run() throws Exception{// 初始化COM进程initCom();// 启动word应用wordApplication = new ActiveXComponent("Word.Application");// 是否以可视化方式运行wordApplication.setProperty("Visible", new Variant(wdVisible));// 得到所有word文档对象this.wdDocuments = wordApplication.getProperty("Documents").getDispatch(); }/*** 初始化COM线程*/public void initCom() {ComThread.InitSTA();}/*** 释放COM线程资源,COM的线程回收不由java 垃圾回收机制回收*/public void releaseCom() {ComThread.Release();}/*** 启动word,同时打开word文档* @param String filePath 文档地址* @deprecated*/public void openDocument(String filePath) throws Exception{try{run();wdDocument = Dispatch.call(wdDocuments, "Open", filePath).getDispatch();wdTables = wordApplication.call(wdDocument, "Tables").getDispatch();wdBookmarks = wordApplication.call(wdDocument, "Bookmarks").getDispatch();wdSelection = wordApplication.getProperty("Selection").getDispatch();}catch(ComFailException e){throw new Exception(e);}}/*** 根据模版创建新文件* @param String templatePath 模版文件地址*/public void newDocumentByTemplate(String templatePath) throws Exception{ try{run();wdDocument = Dispatch.call(wdDocuments, "Add", templatePath).getDispatch();wdTables = wordApplication.call(wdDocument, "Tables").getDispatch();wdBookmarks = wordApplication.call(wdDocument, "Bookmarks").getDispatch();wdSelection = wordApplication.getProperty("Selection").getDispatch();}catch(ComFailException e){throw new Exception(e);}}/*** 关闭Word当前文档* @param Boolean saveOnExit (ture保存并关闭,false不保存关闭)*/public void closeDocument(boolean saveOnExit) throws Exception {if(wdDocument != null){Dispatch.call(wdDocument, "Close",new Variant(saveOnExit));wdDocument = null;}}/*** 另存为其他格式文档* @param String outFileName 保存文件路径* @param Int saveFormat 保存文件类型* saveFormat | Member name Description* 0 | wdFormatDocument Microsoft Word format.* 1 | wdFormatTemplate Microsoft Word template format.* 2 | wdFormatText Microsoft Windows text format.* 3 | wdFormatTextLineBreaks Microsoft Windows text format with line breaks preserved.* 4 | wdFormatDOSText Microsoft DOS text format.* 5 | wdFormatDOSTextLineBreaks Microsoft DOS text with line breaks preserved.* 6 | wdFormatRTF Rich text format (RTF).* 7 | wdFormatEncodedText Encoded text format.* 7 | wdFormatUnicodeText Unicode text format.* 8 | wdFormatHTML Standard HTML format.* 9 | wdFormatWebArchive Web archive format.* 10 | wdFormatFilteredHTML Filtered HTML format.* 11 | wdFormatXML Extensible Markup Language (XML) format.*/public void saveAs(String outFileName,int saveFormat) throws Exception{Dispatch.call(wdDocument, "SaveAs", outFileName,new Variant(saveFormat));}/*** 另存为* @param String outFileName 保存文件路径*/public void saveAs(String outFileName) throws Exception{saveAs(outFileName,0);}/*** 退出Word应用,并调用ComThread.Release()方法*/public void quit() {if(wordApplication != null){wordApplication.invoke("Quit", new Variant(0));wordApplication = null;}releaseCom();}/*** 选中dispatch对象* @param dispatch（分配，派遣）*/private void select(Dispatch dispatch) {Dispatch.call(dispatch, "Select");}private Dispatch getSelection(){return this.wdSelection;}private Dispatch getRange(Dispatch dispatch){return Dispatch.get(dispatch,"Range").getDispatch();}private Dispatch getTables(){return this.wdTables;}/*** 根据索引查找文档中的表格* @param tbIndex* @return wdTable 当前表格对象*/private Dispatch getTable(int tbIndex) {wdTable = Dispatch.call(wdTables, "Item", new Variant(tbIndex)).getDispatch();return wdTable;}/*** 在selection对象范围内索引表* @param tbIndex* @return wdTable 当前表格对象*/private Dispatch getTable(Dispatch selection,int tbIndex) {Dispatch tables = Dispatch.call(selection, "Tables").getDispatch();Dispatch table = Dispatch.call(tables, "Item", new Variant(tbIndex)).getDispatch();return table;}/*** 查找指定表的某单元格* @param Dispatch tableDispatch* @param int tbRowIndex* @param int tbColumnIndex* @return tbCell 当前单元格对象*/private Dispatch getCell(Dispatch tableDispatch,int tbRowIndex, int tbColumnIndex) throws Exception{try{tbCell = Dispatch.call(tableDispatch, "Cell",new Variant(tbRowIndex),new Variant(tbColumnIndex)).getDispatch();}catch(ComFailException cfe){throw new Exception(cfe);}return tbCell;}private void putText(Dispatch dispatch,String text) throws Exception{range = getRange(dispatch);Dispatch.put(range,"Text",text);}private void insertFile(Dispatch dispatch,File file) throws Exception{range = getRange(dispatch);// select(dispatch);Dispatch.call(range,"insertFile",file.getPath());}/*** 在指定的表格中的单元个填充数据* @param tbIndex word文件中的第N张表(从1开始)* @param rowIndex指定行的序号(从1开始)* @param colIndex指定列的序号(从1开始)* @param text填充的文本内容*/public void putTextToCell(int tbIndex, int rowIndex,int colIndex,String text) throws Exception{// getTable(tbIndex);putText(getCell(getTable(tbIndex),rowIndex,colIndex),text);}/*** 在指定的表格中的单元个填充数据,光标放置在文本后面* @param tbIndex word文件中的第N张表(从1开始)* @param rowIndex指定行的序号(从1开始)* @param colIndex指定列的序号(从1开始)* @param text填充的文本内容*/public void setTextToCell(int tbIndex, int rowIndex,int colIndex,String text) throws Exception{ Dispatch cell = getCell(getTable(tbIndex),rowIndex,colIndex);select(cell);Dispatch.call(wdSelection,"InsertAfter",text);}/*** 在指定行前面增加一行* @param tbIndex word文件中的第N张表(从1开始)* @param tbRowIndex指定行的序号(从1开始)*/public void insertRowAtTable(int tbIndex,int tbRowIndex) throws Exception{// 根据索引取表格wdTable = getTable(tbIndex);// 表格的所有行Dispatch tbRows = Dispatch.get(wdTable, "Rows").getDispatch();Dispatch tbCell = getCell(getTable(tbIndex),tbRowIndex,1);Dispatch.call(tbRows, "Add", new Variant(tbCell));}/*** 在指定行下面增加行* @param int tbIndex word文件中的第N张表(从1开始)* @param int tbRowIndex指定行的序号(从1开始)* @param int rowNum插入的行数*/public void insertRowBelow(Dispatch tableDispatch,int tbRowIndex,int rowNum)throws Exception{// 表格的所有行// Dispatch tbRows = Dispatch.get(wdTable, "Rows").getDispatch();Dispatch tbCell = getCell(tableDispatch,tbRowIndex,1);select(tbCell);Dispatch.call(wdSelection, "InsertRowsBelow",new Variant(rowNum));}/*** 在指定行下面增加行* @param int tbIndex word文件中的第N张表(从1开始)* @param int tbRowIndex指定行的序号(从1开始)* @param int rowNum插入的行数*/public void insertRowBelow(int tbRowIndex,int rowNum)throws Exception{wdTable = getTable(tbRowIndex);Dispatch tbCell = getCell(wdTable,tbRowIndex,1);select(tbCell);Dispatch.call(wdSelection, "InsertRowsBelow",new Variant(rowNum));}private void copyOrDeleteRow(Dispatch tbRow, int nDataBlockRow) {/** 没有找到变量*/if (nDataBlockRow == -1)return;/** 变量内容为零条*/if (nDataBlockRow == 0) {Dispatch.call(tbRow, "delete");return;}/** 不用复制*/if (nDataBlockRow == 1)return;if (nDataBlockRow > 1) {Dispatch.call(tbRow, "select");Dispatch.call(wdSelection, "Copy");int nCopyNow = nDataBlockRow - 1;for (int nCopys = 0; nCopys < nCopyNow; nCopys++) {try {Dispatch.call(wdSelection, "Paste");}catch(Exception e) {e.printStackTrace();//有时候文档损坏，可以忽略本问题，实际上已经粘贴上了}}}}/*** 填充表格* @param Dispatch tableDispatch表格对象* @param int tbRowIndex指定行的序号(从1开始)* @param int tbColIndex指定列的序号(从1开始)*/private void fillTable(Dispatch tableDispatch,ArrayList al,int tbRowIndex, int tbColIndex)throws Exception{Dispatch rows = Dispatch.get(tableDispatch, "rows").getDispatch();int rowCount = Dispatch.get(rows,"Count").getInt();if(rowCount > al.size()){rowCount = al.size();}for(int i = 0; i < rowCount; i++){String rowData[] = (String[])al.get(i);for(int j = 0; j < rowData.length; j++){try{getCell(tableDispatch,tbRowIndex + i, tbColIndex + j);if(new File(rowData[j]).exists()){insertFile(tbCell,new File(rowData[j]));}else{putText(tbCell,rowData[j]);}}catch(ComFailException e){e.printStackTrace();}}}}/*** 填充表格,并自动扩展表格* @param tbIndex word文件中的第N张表(从1开始)* @param tbRowIndex指定行的序号(从1开始)* @param tbColIndex指定列的序号(从1开始)*/public void autoFillTable(ArrayList al,int tbIndex,int tbRowIndex, int tbColIndex)throws Exception{if(al.size() < 1){System.out.println("[Empty Table:" + tbIndex + "]");return;}wdTable = getTable(tbIndex);Dispatch rows = Dispatch.get(wdTable, "rows").getDispatch();Dispatch row = Dispatch.call(rows,"Item",new Variant(tbRowIndex)).getDispatch();this.copyOrDeleteRow(row,al.size());fillTable(wdTable,al,tbRowIndex,tbColIndex);}/*** 填充表格* @param ArrayList数据LIST* @param tbIndex word文件中的第N张表(从1开始)* @param tbRowIndex指定行的序号(从1开始)* @param tbColIndex指定列的序号(从1开始)*/public void insertAtTable(ArrayList al,int tbIndex,int tbRowIndex,int tbColIndex)throws Exception{if(al.size() < 1){System.out.println("[Empty Table:" + tbIndex + "]");return;}wdTable = getTable(tbIndex);fillTable(wdTable,al,tbRowIndex,tbColIndex);}private float getHeight(Dispatch dispatch) throws Exception{float height = 0;try{if(dispatch != null){height = Dispatch.get(dispatch, "Height").getFloat();}}catch(ComFailException cfe){throw new Exception(cfe);}return height;}/*** 设置指定对象的高度* @param Dispatch dispatch* @param String height 高度值*/private void setHeight(Dispatch dispatch,String height) throws Exception{try{if(dispatch != null){Dispatch.put(dispatch, "Height",new Variant(height));}}catch(ComFailException cfe){throw new Exception(cfe);}}/*** 拆分单元格* @param Dispatch cellDispatch 要拆分的单元格* @param int numRows 拆分的行数* @param int numColumns 拆分的列数*/public void splitCell(Dispatch cellDispatch,int numRows,int numColumns)throws Exception{ try{Dispatch.call(cellDispatch,"Split",new Variant(numRows),new Variant(numColumns));}catch(ComFailException cfe){throw new Exception(cfe);}}private Dispatch getBookmarks(){return this.wdBookmarks;}/*** 根据书签名称得到书签对象。