package com.shlanbao.tzsc.utils.excel;
|
|
import java.lang.reflect.Method;
|
import java.net.URLEncoder;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
|
import org.apache.poi.hssf.usermodel.HSSFCell;
|
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
|
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.HSSFColor;
|
import org.springframework.web.servlet.view.document.AbstractExcelView;
|
|
/**
|
* @ClassName: ViewExcel
|
* @Description: Spring MVC Excel导出通用类，无合并单元格
|
* @author luo
|
* @date 2015年10月13日 上午9:50:52
|
*/
|
public class ViewExcel extends AbstractExcelView{
|
|
@Override
|
public void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook,HttpServletRequest request, HttpServletResponse response)
|
throws Exception {
|
//获取名称
|
String excelName = model.get("name")!=null?model.get("name").toString():"work";
|
excelName+=".xls";
|
// 设置response方式,使执行此controller时候自动出现下载页面,而非直接使用excel打开
|
response.setContentType("APPLICATION/OCTET-STREAM");
|
response.setHeader("Content-Disposition", "attachment; filename="+ URLEncoder.encode(excelName, "UTF-8"));
|
List list = (List) model.get("list");
|
// 产生Excel表头
|
HSSFSheet sheet = workbook.createSheet("work");
|
|
//创建一个样式
|
HSSFCellStyle style = workbook.createCellStyle();
|
//设置边框样式
|
style.setBorderTop(HSSFCellStyle.BORDER_THIN);
|
style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
|
style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
|
style.setBorderRight(HSSFCellStyle.BORDER_THIN);
|
//设置边框颜色
|
style.setTopBorderColor(HSSFColor.BLACK.index);
|
style.setBottomBorderColor(HSSFColor.BLACK.index);
|
style.setLeftBorderColor(HSSFColor.BLACK.index);
|
style.setRightBorderColor(HSSFColor.BLACK.index);
|
HSSFRow header = sheet.createRow(0); // 第0行
|
header.setHeight((short)512);
|
//获取列宽
|
if(model.get("lineWidth")!=null){
|
Short[] title=(Short[])model.get("lineWidth");
|
// 设置每一列的列宽
|
for(int i=0;i<title.length;i++){
|
sheet.setColumnWidth((short)i,(short)(title[i]*256));
|
}
|
}
|
|
//获取标题
|
if(model.get("title")!=null){
|
String[] title=(String[])model.get("title");
|
// 产生标题列
|
for(int i=0;i<title.length;i++){
|
//sheet.autoSizeColumn((short)0);
|
HSSFCell cell=header.createCell((short) i);
|
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
|
cell.setCellValue(title[i]);
|
cell.setCellStyle(style);
|
}
|
}
|
int rowNum = 1;
|
if(model.get("class")!=null){
|
Class c=(Class)model.get("class");
|
String[] method=model.get("method")!=null?(String[])model.get("method"):null;
|
if(method==null){
|
throw new Exception("导出"+excelName+"报表时,未找到集合方法集合");
|
}else{
|
for(Object o:list){
|
HSSFRow row = sheet.createRow(rowNum++);
|
for(int i=0;i<method.length;i++){
|
Method m=c.getDeclaredMethod(method[i]);
|
String value=m.invoke(o)!=null?m.invoke(o).toString():"";
|
HSSFCell cell=row.createCell((short) i);
|
//设置为中文
|
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
|
cell.setCellValue(value);
|
cell.setCellStyle(style);
|
}
|
}
|
}
|
|
}
|
|
}
|
|
}
|
