Java通过POI和JXL给Excel动态添加水印剖析.docxVIP

一：设置水印要显示的model类（非必要） package zp.ExcelUtil; import java.text.SimpleDateFormat; import java.util.Date; public class Model { private String ip; private String user; private Date date; public Model() { // TODO Auto-generated constructor stub } public Model(String ip, String user, Date date) { this.ip = ip; this.user = user; this.date = date; } public String getIp() { return ip; } public void setIp(String ip) { this.ip = ip; } public String getUser() { return user; } public void setUser(String user) { this.user = user; } public String getDate() { SimpleDateFormat sdf = new SimpleDateFormat(yyyy年MM月dd日 HH时mm分ss秒); return sdf.format(date); } public void setDate(Date date) { this.date = date; } } 二.编写工具类 package zp.ExcelUtil; import java.awt.AlphaComposite; import java.awt.BasicStroke; import java.awt.Color; import java.awt.Font; import java.awt.Graphics2D; import java.awt.font.FontRenderContext; import java.awt.geom.Rectangle2D; import java.awt.image.BufferedImage; import java.io.File; import java.io.IOException; import java.lang.reflect.Method; import java.util.HashMap; import java.util.Iterator; import java.util.Map; import javax.imageio.ImageIO; import org.json.JSONException; import org.json.JSONObject; public class Utilss { private static int width = 900; // 水印图片的宽度 private static int height = 1020; // 水印图片的高度 因为设置其他的高度会有黑线，所以拉高高度 /** * 将JavaBean转换成JSONObject（通过Map中转） * * @param bean * javaBean * @return json对象 * @throws Exception */ public static JSONObject modelToJSON(Object bean) throws Exception { return new JSONObject(toMap(bean)); } /** * 将Javabean转换为Map * * @param javaBean * javaBean * @return Map对象 */ @SuppressWarnings({ unchecked, rawtypes }) public static Map toMap(Object javaBean) throws Exception { Map result = new HashMap(); Method[] methods = javaBean.getClass().getDeclaredMethods(); for (Method method : methods) { if (method.getName().starts