import?java.awt.image.BufferedImage;
import?java.io.ByteArrayOutputStream;
import?java.io.FileInputStream;
import?java.io.IOException;
import?java.io.InputStream;

import?javax.imageio.ImageIO;

import?org.apache.poi.ss.usermodel.ClientAnchor;
import?org.apache.poi.ss.usermodel.Drawing;
import?org.apache.poi.ss.usermodel.Picture;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
/**
?*?
?*?@author?lyt
?*?2017年7月19日
?*/

public?class?ExcelWaterRemarkUtils?{

	/**
	?*?為Excel打上水印工具函數(shù)?請(qǐng)自行確保參數(shù)值，以保證水印圖片之間不會(huì)覆蓋。?在計(jì)算水印的位置的時(shí)候，并沒(méi)有考慮到單元格合并的情況，請(qǐng)注意
	?*?
	?*?@param?wb
	?*????????????Excel?Workbook
	?*?@param?sheet
	?*????????????需要打水印的Excel
	?*?@param?waterRemarkPath
	?*????????????水印地址，classPath，目前只支持png格式的圖片，
	?*????????????因?yàn)榉莗ng格式的圖片打到Excel上后可能會(huì)有圖片變紅的問(wèn)題，且不容易做出透明效果。
	?*????????????同時(shí)請(qǐng)注意傳入的地址格式，應(yīng)該為類似：“\\excelTemplate\\test.png“
	?*?@param?startXCol
	?*????????????水印起始列
	?*?@param?startYRow
	?*????????????水印起始行
	?*?@param?betweenXCol
	?*????????????水印橫向之間間隔多少列
	?*?@param?betweenYRow
	?*????????????水印縱向之間間隔多少行
	?*?@param?XCount
	?*????????????橫向共有水印多少個(gè)
	?*?@param?YCount
	?*????????????縱向共有水印多少個(gè)
	?*?@param?waterRemarkWidth
	?*????????????水印圖片寬度為多少列
	?*?@param?waterRemarkHeight
	?*????????????水印圖片高度為多少行
	?*?@throws?IOException
	?*/
	public?static?void?putWaterRemarkToExcel（Workbook?wb?Sheet?sheet?String?waterRemarkPath?int?startXCol
			int?startYRow?int?betweenXCol?int?betweenYRow?int?XCount?int?YCount?int?waterRemarkWidth
			int?waterRemarkHeight）?throws?IOException?{

		//?校驗(yàn)傳入的水印圖片格式
		if?（!waterRemarkPath.endsWith（“png“）?&&?!waterRemarkPath.endsWith（“PNG“））?{
			throw?new?RuntimeException（“向Excel上面打印水印，目前支持png格式的圖片?！埃?
		}

		//?加載圖片
		ByteArrayOutputStream?byteArrayOut?=?new?ByteArrayOutputStream（）;
		InputStream?imageIn=new?FileInputStream（waterRemarkPath）;
		//InputStream?imageIn?=?Thread.currentThread（）.getContextClassLoader（）.getResourceAsStream（waterRemarkPath）;
		if?（null?==?imageIn?||?imageIn.available（）?			throw?new?RuntimeException（“向Excel上面打印水印，讀取水印圖片失?。?）?！埃?
		}
		BufferedImage?bufferImg?=?ImageIO.read（imageIn）;
		if?（null?==?bufferImg）?{
			throw?new?RuntimeException（“向Excel上面打印水印，讀取水印圖片失?。?）?！埃?
		}
		ImageIO.write（bufferImg?“png“?byteArrayOut）;

		//?開(kāi)始打水印
		Drawing?drawing?=?sheet.createDrawingPatriarch（）;
		
		//?按照共需打印多少行水印進(jìn)行循環(huán)
		for?（int?yCount?=?0;?yCount?			//?按照每行需要打印多少個(gè)水印進(jìn)行循環(huán)
			for?（int?xCount?=?0;?xCount?				//?創(chuàng)建水印圖片位置
				int?xIndexInteger?=?startXCol?+?（xCount?*?waterRemarkWidth）?+?（xCount?*?betweenXCol）;
				int?yIndexInteger?=?startYRow?+?（yCount?*?waterRemarkHeight）?+?（yCount?*?betweenYRow）;
				/*
				?*?參數(shù)定義：?第一個(gè)參數(shù)是（x軸的開(kāi)始節(jié)點(diǎn)）；?第二個(gè)參數(shù)是（是y軸的開(kāi)始節(jié)點(diǎn)）；?第三個(gè)參數(shù)是（是x軸的結(jié)束節(jié)點(diǎn)）；
				?*?第四個(gè)參數(shù)是（是y軸的結(jié)束節(jié)點(diǎn)）；?第五個(gè)參數(shù)是（是從Excel的第幾列開(kāi)始插入圖片，從0開(kāi)始計(jì)數(shù)）；
				?*?第六個(gè)參數(shù)是（是從excel的第幾行開(kāi)始插入圖片，從0開(kāi)始計(jì)數(shù)）；?第七個(gè)參數(shù)是（圖片寬度，共多少列）；
				?*?第8個(gè)參數(shù)是（圖片高度，共多少行）；
				?*/
				ClientAnchor?anchor?=?

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????420??2017-07-19?12:09??exportExcel\.classpath

?????文件????????388??2017-07-19?11:57??exportExcel\.project

?????文件????????598??2017-07-19?11:57??exportExcel\.settings\org.eclipse.jdt.core.prefs

?????文件???????2897??2017-07-19?12:09??exportExcel\bin\ExcelWaterRemarkUtils.class

?????文件???????2898??2017-07-19?12:09??exportExcel\bin\ImageUtils.class

?????文件???????3168??2017-07-19?12:10??exportExcel\bin\poiexe.class

?????文件?????232771??2015-06-15?17:43??exportExcel\lib\commons-codec-1.6.jar

?????文件????2679259??2017-07-13?11:00??exportExcel\lib\poi-3.16.jar

?????文件???????4269??2017-07-19?12:04??exportExcel\src\ExcelWaterRemarkUtils.java

?????文件???????2241??2017-07-19?12:07??exportExcel\src\ImageUtils.java

?????文件???????2669??2017-07-19?12:10??exportExcel\src\poiexe.java

?????目錄??????????0??2017-07-19?11:57??exportExcel\.settings

?????目錄??????????0??2017-07-19?12:09??exportExcel\bin

?????目錄??????????0??2017-07-19?12:09??exportExcel\lib

?????目錄??????????0??2017-07-19?12:00??exportExcel\src

?????目錄??????????0??2018-03-13?14:33??exportExcel

-----------?---------??----------?-----??----

??????????????2931578????????????????????16