JACOB操作Office的一些实例

package net.fiyu.edit;

import com.jacob.activeX.*;
import com.jacob.com.*;

public class WordService extends java.awt.Panel {
private static final long serialVersionUID=-1L;

public ActiveXComponent MsWordApp = null;
private Dispatch document = null;
public WordService() {
super();
}
public void openWord(boolean makeVisible) {
//Open Word if we/'ve not done it already
if (MsWordApp == null) {
MsWordApp = new ActiveXComponent("Word.Application");
}
//Set the visible property as required.
Dispatch.put(MsWordApp, "Visible",
new Variant(makeVisible));
}

public void openExcel(boolean makeVisible) {
//Open Word if we/'ve not done it already
if (MsWordApp == null) {
MsWordApp = new ActiveXComponent("Excel.Application");
}
//Set the visible property as required.
Dispatch.put(MsWordApp, "Visible",
new Variant(makeVisible));
}

/**
* 打开已知的word文档
* @param markVisible 可视化状态
* @param docPath 文档路径
*/
public void openWord(boolean markVisible,final String docPath) {
if (MsWordApp == null) {
MsWordApp = new ActiveXComponent("Word.Application");
}
//Set the visible property as required.
Dispatch.put(MsWordApp, "Visible", new Variant(markVisible));
Dispatch docs = MsWordApp.getProperty("Documents").toDispatch();
document = Dispatch.invoke(docs,"Open", Dispatch.Method, new Object[]{docPath}, new int[1]).toDispatch();
}
/**
* 创建Word文档
*
*/
public void createNewDocument() {
//Find the Documents collection object maintained by Word
Dispatch documents = Dispatch.get(MsWordApp,"Documents").toDispatch();
//Call the Add method of the Documents collection to create
//a new document to edit
document = Dispatch.call(documents,"Add").toDispatch();
}
/**
* 插入文本
* @param textToInsert
*/
public void insertText(String textToInsert) {
// Get the current selection within Word at the moment. If
// a new document has just been created then this will be at
// the top of the new doc
Dispatch selection = Dispatch.get(MsWordApp,"Selection").toDispatch();
//Put the specified text at the insertion point
Dispatch.put(selection,"Text",textToInsert);
}
public void saveFileAs(String filename) {
Dispatch.call(document,"SaveAs",filename);
}
public void printFile() {
//Just print the current document to the default printer
Dispatch.call(document,"PrintOut");
}
/**
* 查找替换文本
* @param searchText 需要查找的关键字
* @param replaceText 要替换成的关键字
*/
public void searchReplace(final String searchText,final String replaceText) {
Dispatch selection=MsWordApp.getProperty("Selection").toDispatch();
Dispatch find = ActiveXComponent.call(selection, "Find").toDispatch();
//查找什么文本
Dispatch.put(find, "Text", searchText);
//替换文本
Dispatch.call(find,"ClearFormatting");
Dispatch.put(find, "Text", searchText);
Dispatch.call(find, "Execute");
Dispatch.put(selection, "Text", replaceText);
}
/**
* 把指定的值设置到指定的标签中去
* @param bookMarkKey
*/
public void setBookMark(final String bookMarkKey,final String bookMarkValue) {
Dispatch activeDocument=MsWordApp.getProperty("ActiveDocument").toDispatch();
Dispatch bookMarks = ActiveXComponent.call(activeDocument, "Bookmarks").toDispatch();
boolean bookMarkExist1=Dispatch.call(bookMarks,"Exists",bookMarkKey).getBoolean();
if(bookMarkExist1==true){
Dispatch rangeItem = Dispatch.call(bookMarks, "Item",bookMarkKey).toDispatch();
Dispatch range = Dispatch.call(rangeItem, "Range").toDispatch();
//取标签的值
//String bookMarkValue=Dispatch.get(range,"Text").toString();
//bookMarkValue="test";
if(bookMarkValue!=null){
Dispatch.put(range, "Text",new Variant(bookMarkValue));
}
}else{
System.out.println("not exists bookmark!");
}
}
/**
* 保存Word文档到指定的目录(包括文件名)
* @param filePath
*/
public void saveWordFile(final String filePath) {
//保存文件
Dispatch.invoke(document, "SaveAs", Dispatch.Method, new Object[] {filePath, new Variant(0)} , new int[1]);
//作为word格式保存到目标文件
Variant f = new Variant(false);
Dispatch.call(document, "Close", f);
}
public void closeDocument() {
// Close the document without saving changes
// 0 = wdDoNotSaveChanges
// -1 = wdSaveChanges
// -2 = wdPromptToSaveChanges
Dispatch.call(document, "Close", new Variant(0));
document = null;
}
public void closeWord() {
Dispatch.call(MsWordApp,"Quit");
MsWordApp = null;
document = null;
}

public static void main(String[] args) {
WordService word=new WordService();
word.openWord(true);
word.createNewDocument();
//word.insertText("Hello word.");
//word.searchReplace("Hello", "哈喽");
//word.setBookMark("bookMarkKey","bookMarkValue");
//word.MsWordApp.setProperty("UserName","xiantongsky");
//word.saveWordFile("D:/xiantong.doc");
}
}

###############################################################################################################

package net.fiyu.edit;

import java.io.File;

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.Dispatch;
import com.jacob.com.Variant;

public class Wordtohtml
{
//------------------------------------------------------------------------------
//方法原型: change(String paths)
//功能描述: 将指定目录下面所有的doc文件转化为HTML并存储在相同目录下
//输入参数: String
//输出参数: 无
//返 回 值: 无
//其它说明: 递归
//------------------------------------------------------------------------------
public static void change(String paths, String savepaths)
{

File d = new File(paths);
//取得当前文件夹下所有文件和目录的列表
File lists[] = d.listFiles();
String pathss = new String("");

//对当前目录下面所有文件进行检索
for(int i = 0; i < lists.length; i ++)
{
if(lists[i].isFile())
{
String filename = lists[i].getName();
String filetype = new String("");
//取得文件类型
filetype = filename.substring((filename.length() - 3), filename.length());

//判断是否为doc文件
if(filetype.equals("doc"))
{
System.out.println("当前正在转换......");
//打印当前目录路径
System.out.println(paths);
//打印doc文件名
System.out.println(filename.substring(0, (filename.length() - 4)));

ActiveXComponent app = new ActiveXComponent("Word.Application");//启动word

String docpath = paths + filename;
String htmlpath = savepaths + filename.substring(0, (filename.length() - 4));

String inFile = docpath;
//要转换的word文件
String tpFile = htmlpath;
//HTML文件

boolean flag = false;

try
{
app.setProperty("Visible", new Variant(false));
//设置word不可见
Object docs = app.getProperty("Documents").toDispatch();

Object doc = Dispatch.invoke((Dispatch) docs,"Open", Dispatch.Method, new Object[]{inFile,new Variant(false), new Variant(true)}, new int[1]).toDispatch();
//打开word文件
Dispatch.invoke((Dispatch) doc,"SaveAs", Dispatch.Method, new Object[]{tpFile,new Variant(8)}, new int[1]);
//作为html格式保存到临时文件
Variant f = new Variant(false);
Dispatch.call((Dispatch) doc, "Close", f);
flag = true;
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
app.invoke("Quit", new Variant[] {});
}
System.out.println("转化完毕！");
}
}
else
{
pathss = paths;
//进入下一级目录
pathss = pathss + lists[i].getName() + "//";
//递归遍历所有目录
change(pathss, savepaths);
}
}

}
//------------------------------------------------------------------------------
//方法原型: main(String[] args)
//功能描述: main文件
//输入参数: 无
//输出参数: 无
//返 回 值: 无
//其它说明: 无
//------------------------------------------------------------------------------
public static void main(String[] args)
{

String paths = new String("D://word//");
String savepaths = new String ("D://html//");

change(paths, savepaths);

}
}

#################################################################################################################

package net.fiyu.edit;

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.Dispatch;
import com.jacob.com.Variant;

public class ExcelTest
{
private static ActiveXComponent xl;
private static Object workbooks = null;
private static Object workbook = null;
private static Object sheet = null;
private static String filename =null;
private static boolean readonly = false;
private static Dispatch document = null;

public static void main(String[] args)
{
String file = "d://new_department_data.xls";
OpenExcel(file,true);//false为不显示打开Excel
SetValue("A1","Value","2");
System.out.println(GetValue("A3"));
//CloseExcel(false);

//createNewDocument();

}

//打开Excel文档
private static void OpenExcel(String file,boolean f)
{
try
{
filename = file;
xl = new ActiveXComponent("Excel.Application");
xl.setProperty("Visible", new Variant(f));
workbooks = xl.getProperty("Workbooks").toDispatch();
workbook = Dispatch.invoke((Dispatch) workbooks,
"Open",
Dispatch.Method,
new Object[]{filename,
new Variant(false),
new Variant(readonly)},//是否以只读方式打开
new int[1] ).toDispatch();
}catch(Exception e)
{e.printStackTrace();}
}


public static void createNewDocument() {
xl = new ActiveXComponent("Excel.Application");
//Find the Documents collection object maintained by Word
Dispatch documents = Dispatch.get(xl,"Documents").toDispatch();
//Call the Add method of the Documents collection to create
//a new document to edit
document = Dispatch.call(documents,"Add").toDispatch();
}

//关闭Excel文档
private static void CloseExcel(boolean f)
{
try
{
Dispatch.call((Dispatch) workbook,"Save");
Dispatch.call((Dispatch) workbook, "Close", new Variant(f));
} catch (Exception e) {
e.printStackTrace();
} finally {
xl.invoke("Quit", new Variant[] {});
}
}

//写入值
private static void SetValue(String position,String type,String value)
{
sheet = Dispatch.get((Dispatch) workbook,"ActiveSheet").toDispatch();
Object cell = Dispatch.invoke((Dispatch) sheet, "Range",
Dispatch.Get,
new Object[] {position},
new int[1]).toDispatch();
Dispatch.put((Dispatch) cell, type, value);
}

//读取值
private static String GetValue(String position)
{
Object cell = Dispatch.invoke((Dispatch) sheet,"Range",Dispatch.Get,new Object[] {position},new int[1]).toDispatch();
String value = Dispatch.get((Dispatch) cell,"Value").toString();

return value;
}
}