POI工具类
?
package com.adtech.tools;
?
import java.io.IOException;
?
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
?
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.Region;
?
/**
?* 报表打印工具类
?*?
?* @date 2010-01-22
?*/
public class ReportTool {
/**
* Excel编码处理
*?
* @param toEncoded
* @param encoding
* @return
*/
public static String getUnicode(String toEncoded, String encoding) {
String retString = "";
if (toEncoded.equals("") || toEncoded.trim().equals("")) {
return toEncoded;
}
try {
byte[] b = toEncoded.getBytes(encoding);
sun.io.ByteToCharConverter convertor = sun.io.ByteToCharConverter
.getConverter(encoding);
char[] c = convertor.convertAll(b);
for (int i = 0; i < c.length; i++) {
retString += String.valueOf(c[i]);
}
} catch (java.io.UnsupportedEncodingException usee) {
System.out.println("不支持" + encoding + "编码方式");
usee.printStackTrace();
} catch (sun.io.MalformedInputException mfie) {
System.out.println("输入参数无效!!!");
mfie.printStackTrace();
}
return retString;
}
?
/**
* 处理文件名乱码
*?
* @param str
* @return
*/
public static String getStr(String str) {
try {
String temp_p = str;
byte[] temp_t = temp_p.getBytes("ISO8859_1");
String temp = new String(temp_t);
return temp;
} catch (Exception e) {
e.printStackTrace();
}
return "null";
}
?
/**
* 定义字体大小样式
*?
* @param workbook
* @param color
* ? ? ? ? ? ?字体颜色
* @param boldweight
* ? ? ? ? ? ?字体样式
* @param fontHeight
* ? ? ? ? ? ?字体大小
* @return
*/
public static HSSFFont createHSSFFont(HSSFWorkbook workbook, short color,
short boldweight, int fontHeight) {
HSSFFont font = workbook.createFont();
font.setColor(HSSFFont.COLOR_NORMAL);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
font.setFontHeight((short) fontHeight);
return font;
}
?
/**
* 定义边框样式 单元格四周都有边框
*?
* @param workbook
* @param verticalAlignment
* ? ? ? ? ? ?垂直显示
* @param alignment
* ? ? ? ? ? ?水平显示样式
* @param top
* ? ? ? ? ? ?上边框粗细
* @param bottom
* ? ? ? ? ? ?下边框粗细
* @param left
* ? ? ? ? ? ?左边框粗细
* @param right
* ? ? ? ? ? ?右边框粗细
* @return
*/
public static HSSFCellStyle createHSSFCellStyle(HSSFWorkbook workbook,
short verticalAlignment, short alignment, int top, int bottom,
int left, int right) {
HSSFCellStyle cellStyle = workbook.createCellStyle();
cellStyle.setVerticalAlignment(verticalAlignment);
cellStyle.setAlignment(alignment);
cellStyle.setBorderBottom((short) bottom);
cellStyle.setBorderLeft((short) left);
cellStyle.setBorderRight((short) right);
cellStyle.setBorderTop((short) top);
return cellStyle;
?
}
?
/**
* 定义边框样式 单元格四周都有边框
*?
* @param workbook
* @param verticalAlignment
* ? ? ? ? ? ?垂直显示
* @param alignment
* ? ? ? ? ? ?水平显示样式
* @param top
* ? ? ? ? ? ?上边框粗细
* @param bottom
* ? ? ? ? ? ?下边框粗细
* @param left
* ? ? ? ? ? ?左边框粗细
* @param right
* ? ? ? ? ? ?右边框粗细
* @param font
* ? ? ? ? ? ?单元格字体样式
* @return
*/
public static HSSFCellStyle createHSSFCellStyle(HSSFWorkbook workbook,
HSSFFont font, short verticalAlignment, short alignment, int top,
int bottom, int left, int right) {
HSSFCellStyle cellStyle = workbook.createCellStyle();
cellStyle.setVerticalAlignment(verticalAlignment);
cellStyle.setAlignment(alignment);
cellStyle.setBorderBottom((short) bottom);
cellStyle.setBorderLeft((short) left);
cellStyle.setBorderRight((short) right);
cellStyle.setBorderTop((short) top);
cellStyle.setFont(font);
return cellStyle;
?
}
?
/**
* 创建行
*?
* @param sheet
* ? ? ? ? ? ?工作表
* @param rowNum
* ? ? ? ? ? ?行号
* @param height
* ? ? ? ? ? ?行高
*?
* @return
*/
public static HSSFRow createHSSFRow(HSSFSheet sheet, int rowNum, int height) {
HSSFRow row = sheet.createRow((short) rowNum);
row.setHeight((short) height);
return row;
}
?
/**
* 创建列
*?
* @param hssfRow
* ? ? ? ? ? ?行对象
* @param cellStyle
* ? ? ? ? ? ?单元格样式
* @param cellNum
* ? ? ? ? ? ?列号
* @param content
* ? ? ? ? ? ?单元格内容
*?
*/
public static void createHSSFCell(HSSFRow hssfRow, HSSFCellStyle cellStyle,
int cellNum, String content) {
HSSFCell cell = hssfRow.createCell((short) cellNum);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellStyle(cellStyle);
content = getUnicode(content, "gb2312");
cell.setCellValue(content);
?
}
?
/**
* 创建列
*?
* @param hssfRow
* ? ? ? ? ? ?行对象
* @param cellStyle
* ? ? ? ? ? ?单元格样式
* @param cellNum
* ? ? ? ? ? ?列号
* @param content
* ? ? ? ? ? ?单元格内容
* @param beginRow
* ? ? ? ? ? ?合并单元格开始行
* @param beginCell
* ? ? ? ? ? ?合并单元格开始列
* @param endRow
* ? ? ? ? ? ?合并单元格结束行
* @param endCell
* ? ? ? ? ? ?合并单元格结束列
*?
*/
public static void createHSSFCell(HSSFSheet sheet, HSSFRow hssfRow,
HSSFCellStyle cellStyle, int cellNum, String content, int beginRow,
int beginCell, int endRow, int endCell) {
HSSFCell cell = hssfRow.createCell((short) cellNum);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellStyle(cellStyle);
content = getUnicode(content, "gb2312");
cell.setCellValue(content);
sheet.addMergedRegion(new Region((short) beginRow, (short) beginCell,
(short) endRow, (short) endCell));
for (int i = beginCell + 1; i < endCell + 1; i++) {
cell = hssfRow.createCell((short) i);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellStyle(cellStyle);
}
if (beginRow < endRow) {
for (int j = beginRow + 1; j < endRow + 1; j++) {
HSSFRow row = ReportTool.createHSSFRow(sheet, j, 300);
?
for (int i = beginCell; i < endCell + 1; i++) {
cell = row.createCell((short) i);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellStyle(cellStyle);
}
}
}
?
}
?
/**
* 设置页面返回类型
*?
* @param request
* @param response
* @param jyPath
* @throws ServletException
* @throws IOException
*/
public static void setExclType(HttpServletRequest request,
HttpServletResponse response, String jyPath) {
?
response.setContentType("application/octet-stream");
String outputFile = request.getParameter("TEMPLET_NNAME") != null ? getUnicode(
request.getParameter("TEMPLET_NNAME"), "gb2312")
+ ".xls"
: "";
HttpSession session = request.getSession();
if (outputFile.equals("")) {
// 所有状态查询标题不能为空
session.setAttribute("ADQMS9000_MESSAGE_TYPE", "1");
session.setAttribute("ADQMS9000_MESSAGE_CONTENT", "你没有权限导出！");
session.setAttribute("ADQMS9000_MESSAGE_GOTO",
"javascript:history.back(1)");
?
try {
request.getRequestDispatcher(jyPath).forward(request, response);
} catch (Exception e) {
}
}
String fileName = outputFile;
response.setHeader("Content-Disposition", "attachment;filename="
+ fileName);
}
}
