jacob技术向word中“指定”位置插入图片

主要用到org.apache.poi

来 *** 作word，而读取数据库图片

通过读取数据库blob

字段的列然后通过

public

static

bufferedimage

imgchangebuffer(blob

blob)

方法钩子一个

bufferedimage

然后把这个

bufferedimage

设置到word中，希望能帮上忙。

http://www.baidu.com/s?wd=52070475597

package com.ymo.word

import com.jacob.activeX.ActiveXComponent

import com.jacob.com.ComThread

import com.jacob.com.Dispatch

import com.jacob.com.Variant

public class TestJacobWord {

private ActiveXComponent wrdCom = null

private Dispatch doc = null

private Dispatch activeDoc = null

private Dispatch docSelect = null

private Dispatch docs = null

private static TestJacobWord instance = null

private String docName = ""

public static TestJacobWord getInstance() {

if (instance == null) {

instance = new TestJacobWord()

}

return instance

}

private boolean initWord() {

boolean flag = false

ComThread.InitSTA()

wrdCom = new ActiveXComponent("word.Application")

try {

docs = wrdCom.getProperty("Documents").toDispatch()

wrdCom.setProperty("Visible", new Variant(false))

flag = true

} catch (Exception e) {

flag = false

e.printStackTrace()

}

return flag

}

private void createNewDocument() {

doc = Dispatch.call(docs, "Add").toDispatch()

docSelect = Dispatch.get(wrdCom, "Selection").toDispatch()

}

private void getActiveDoc() {

activeDoc = wrdCom.getProperty("ActiveWindow").toDispatch()

System.out.println(activeDoc.getProgramId())

}

private void openDocument(String docPath) {

if (this.doc != null) {

closeDocument()

}

this.doc = Dispatch.call(docs, "Open", docPath, new Variant(false),

new Variant(false)).toDispatch()

docSelect = Dispatch.get(wrdCom, "Selection").toDispatch()

}

private void closeDocument() {

if (doc != null) {

Dispatch.call(doc, "Save")

Dispatch.call(doc, "Close", new Variant(true))

doc = null

}

}

private void setImgWaterMark(String waterMarkPath) {

Dispatch activePan = Dispatch.get(activeDoc, "ActivePane").toDispatch()

Dispatch view = Dispatch.get(activePan, "View").toDispatch()

Dispatch.put(view, "SeekView", new Variant(9))

Dispatch headfooter = Dispatch.get(docSelect, "HeaderFooter")

.toDispatch()

// 取得图形对象

Dispatch shapes = Dispatch.get(headfooter, "Shapes").toDispatch()

Dispatch pic = Dispatch.call(shapes, "AddPicture", waterMarkPath)

.toDispatch()

Dispatch.call(pic, "Select")

Dispatch.put(pic, "Left", new Variant(10))

Dispatch.put(pic, "Top", new Variant(200))

Dispatch.put(pic, "Width", new Variant(150))

Dispatch.put(pic, "Height", new Variant(80))

Dispatch.put(view, "SeekView", new Variant(0))

}

public void setTextWaterMark(String waterMarkStr) {

Dispatch activePan = Dispatch.get(activeDoc, "ActivePane").toDispatch()

Dispatch view = Dispatch.get(activePan, "View").toDispatch()

Dispatch.put(view, "SeekView", new Variant(9))

Dispatch headfooter = Dispatch.get(docSelect, "HeaderFooter")

.toDispatch()

Dispatch shapes = Dispatch.get(headfooter, "Shapes").toDispatch()

Dispatch selection = Dispatch.call(shapes, "AddTextEffect",

new Variant(9), waterMarkStr, "宋体", new Variant(1),

new Variant(false), new Variant(false), new Variant(0),

new Variant(0)).toDispatch()

Dispatch.call(selection, "Select")

Dispatch shapeRange = Dispatch.get(docSelect, "ShapeRange")

.toDispatch()

Dispatch.put(shapeRange, "Name", "PowerPlusWaterMarkObject

1")

Dispatch textEffect = Dispatch.get(shapeRange, "TextEffect")

.toDispatch()

Dispatch.put(textEffect, "NormalizedHeight", new Boolean(false))

Dispatch line = Dispatch.get(shapeRange, "Line").toDispatch()

Dispatch.put(line, "Visible", new Boolean(false))

Dispatch fill = Dispatch.get(shapeRange, "Fill").toDispatch()

Dispatch.put(fill, "Visible", new Boolean(true))

// 设置水印透明度

Dispatch.put(fill, "Transparency", new Variant(0.5))

Dispatch foreColor = Dispatch.get(fill, "ForeColor").toDispatch()

Dispatch.put(foreColor, "RGB", new Variant(16711620))

Dispatch.call(fill, "Solid")

// 设置水印旋转

Dispatch.put(shapeRange, "Rotation", new Variant(315))

Dispatch.put(shapeRange, "LockAspectRatio", new Boolean(true))

Dispatch.put(shapeRange, "Height", new Variant(117.0709))

Dispatch.put(shapeRange, "Width", new Variant(468.2835))

Dispatch.put(shapeRange, "Left", new Variant(-999995))

Dispatch.put(shapeRange, "Top", new Variant(-999995))

Dispatch wrapFormat = Dispatch.get(shapeRange, "WrapFormat")

.toDispatch()

// 是否允许交叠

Dispatch.put(wrapFormat, "AllowOverlap", new Variant(true))

Dispatch.put(wrapFormat, "Side", new Variant(3))

Dispatch.put(wrapFormat, "Type", new Variant(3))

Dispatch.put(shapeRange, "RelativeHorizontalPositi

on", new Variant(0))

Dispatch.put(shapeRange, "RelativeVerticalPosition

", new Variant(0))

Dispatch.put(view, "SeekView", new Variant(0))

}

private void closeWord() {

// 关闭word文件

wrdCom.invoke("Quit", new Variant[] {})

// 释放com线程

ComThread.Release()

}

public String getDocName() {

return docName

}

public void setDocName(String docName) {

this.docName = docName

}

private boolean addWaterMark(String wordPath, String waterMarkPath) {

boolean flag = false

try {

if (initWord()) {

openDocument(wordPath)

getActiveDoc()

setImgWaterMark(waterMarkPath)

closeDocument()

closeWord()

flag = true

} else {

flag = false

}

} catch (Exception e) {

flag = false

e.printStackTrace()

closeDocument()

closeWord()

}

return flag

}

public static void main(String[] args) {

TestJacobWord jacob = TestJacobWord.getInstance()

// jacob.addWaterMark("F://test//test.doc", "F://test//ymo.jpg")

try {

if (jacob.initWord()) {

jacob.openDocument("F://test/test.doc")

jacob.getActiveDoc()

jacob.setTextWaterMark("重庆宇能科技有限公司")

jacob.closeDocument()

jacob.closeWord()

}

} catch (Exception e) {

e.printStackTrace()

jacob.closeDocument()

jacob.closeWord()

}

}

}

package common.util

import jxl.*

import jxl.format.UnderlineStyle

import jxl.write.*

import jxl.write.Number

import jxl.write.Boolean

import java.io.*

/**

* Created by IntelliJ IDEA.

* User: xl

* Date: 2005-7-17

* Time: 9:33:22

* To change this template use File | Settings | File Templates.

*/

public class ExcelHandle

{

public ExcelHandle()

{

}

/**

* 读取Excel

*

* @param filePath

*/

public static void readExcel(String filePath)

{

try

{

InputStream is = new FileInputStream(filePath)

Workbook rwb = Workbook.getWorkbook(is)

//Sheet st = rwb.getSheet("0")这里有两种方法获取sheet表,1为名字，而为下标，从0开始

Sheet st = rwb.getSheet("original")

Cell c00 = st.getCell(0,0)

//通用的获取cell值的方式,返回字符串

String strc00 = c00.getContents()

//获得cell具体类型值的方式

if(c00.getType() == CellType.LABEL)

{

LabelCell labelc00 = (LabelCell)c00

strc00 = labelc00.getString()

}

//输出

System.out.println(strc00)

//关闭

rwb.close()

}

catch(Exception e)

{

e.printStackTrace()

}

}

/**

* 输出Excel

*

* @param os

*/

public static void writeExcel(OutputStream os)

{

try

{

/**

* 只能通过API提供的工厂方法来创建Workbook，而不能使用WritableWorkbook的构造函数，

* 因为类WritableWorkbook的构造函数为protected类型

* method(1)直接从目标文件中读取WritableWorkbook wwb = Workbook.createWorkbook(new File(targetfile))

* method(2)如下实例所示 将WritableWorkbook直接写入到输出流

*/

WritableWorkbook wwb = Workbook.createWorkbook(os)

//创建Excel工作表 指定名称和位置

WritableSheet ws = wwb.createSheet("Test Sheet 1",0)

//**************往工作表中添加数据*****************

//1.添加Label对象

Label label = new Label(0,0,"this is a label test")

ws.addCell(label)

//添加带有字型Formatting对象

WritableFont wf = new WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true)

WritableCellFormat wcf = new WritableCellFormat(wf)

Label labelcf = new Label(1,0,"this is a label test",wcf)

ws.addCell(labelcf)

//添加带有字体颜色的Formatting对象

WritableFont wfc = new WritableFont(WritableFont.ARIAL,10,WritableFont.NO_BOLD,false,

UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.RED)

WritableCellFormat wcfFC = new WritableCellFormat(wfc)

Label labelCF = new Label(1,0,"This is a Label Cell",wcfFC)

ws.addCell(labelCF)

//2.添加Number对象

Number labelN = new Number(0,1,3.1415926)

ws.addCell(labelN)

//添加带有formatting的Number对象

NumberFormat nf = new NumberFormat("#.##")

WritableCellFormat wcfN = new WritableCellFormat(nf)

Number labelNF = new jxl.write.Number(1,1,3.1415926,wcfN)

ws.addCell(labelNF)

//3.添加Boolean对象

Boolean labelB = new jxl.write.Boolean(0,2,false)

ws.addCell(labelB)

//4.添加DateTime对象

jxl.write.DateTime labelDT = new jxl.write.DateTime(0,3,new java.util.Date())

ws.addCell(labelDT)

//添加带有formatting的DateFormat对象

DateFormat df = new DateFormat("dd MM yyyy hh:mm:ss")

WritableCellFormat wcfDF = new WritableCellFormat(df)

DateTime labelDTF = new DateTime(1,3,new java.util.Date(),wcfDF)

ws.addCell(labelDTF)

//添加图片对象,jxl只支持png格式图片

File image = new File("f:\\2.png")

WritableImage wimage = new WritableImage(0,1,2,2,image)

ws.addImage(wimage)

//写入工作表

wwb.write()

wwb.close()

}

catch(Exception e)

{

e.printStackTrace()

}

}

/**

* 拷贝后,进行修改,其中file1为被copy对象，file2为修改后创建的对象

* 尽单元格原有的格式化修饰是不能去掉的，我们还是可以将新的单元格修饰加上去，

* 以使单元格的内容以不同的形式表现

* @param file1

* @param file2

*/

public static void modifyExcel(File file1,File file2)

{

try

{

Workbook rwb = Workbook.getWorkbook(file1)

WritableWorkbook wwb = Workbook.createWorkbook(file2,rwb)//copy

WritableSheet ws = wwb.getSheet(0)

WritableCell wc = ws.getWritableCell(0,0)

//判断单元格的类型,做出相应的转换

if(wc.getType == CellType.LABEL)

{

Label label = (Label)wc

label.setString("The value has been modified")

}

wwb.write()

wwb.close()

rwb.close()

}

catch(Exception e)

{

e.printStackTrace()

}

}

//测试

public static void main(String[] args)

{

try

{

//读Excel

ExcelHandle.readExcel("f:/testRead.xls")

//输出Excel

File fileWrite = new File("f:/testWrite.xls")

fileWrite.createNewFile()

OutputStream os = new FileOutputStream(fileWrite)

ExcelHandle.writeExcel(os)

//修改Excel

ExcelHandle.modifyExcel(new file(""),new File(""))

}

catch(Exception e)

{

e.printStackTrace()

}

}

}

---