package com.fh.util;
import java.util.Date;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
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.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.web.servlet.view.document.AbstractXlsView;
import com.fh.util.PageData;
import com.fh.util.Tools;
/**
-
说明:导入到EXCEL
-
作者:FH Admin
-
from:tjhelitong.com
*/
public class ObjectExcelView extends AbstractXlsView{@Override
protected void buildExcelDocument(Map<String, Object> model,
Workbook workbook, HttpServletRequest request,
HttpServletResponse response) throws Exception {
// TODO Auto-generated method stub
Date date = new Date();
String filename = Tools.date2Str(date, “yyyyMMddHHmmss”);
HSSFSheet sheet;
response.setContentType(“application/octet-stream”);
response.setHeader(“Content-Disposition”, “attachment;filename=”+filename+".xls");HSSFWorkbook book = (HSSFWorkbook) workbook; sheet = book.createSheet("sheet1"); List<String> titles = (List<String>) model.get("titles"); int len = titles.size(); HSSFCellStyle headerStyle = book.createCellStyle(); //标题样式 headerStyle.setAlignment(HorizontalAlignment.CENTER); headerStyle.setVerticalAlignment(VerticalAlignment.CENTER); HSSFFont headerFont = book.createFont(); //标题字体 headerFont.setBold(true); headerFont.setFontHeightInPoints((short)11); headerStyle.setFont(headerFont); short height=25*20; HSSFRow row = sheet.createRow(0); for(int i=0; i<len; i++){ //设置标题 String title = titles.get(i); row.setRowStyle(headerStyle); row.createCell(i).setCellValue(title); } sheet.getRow(0).setHeight(height); HSSFCellStyle contentStyle = book.createCellStyle(); //内容样式 contentStyle.setAlignment(HorizontalAlignment.CENTER); List<PageData> varList = (List<PageData>) model.get("varList"); int varCount = varList.size(); for(int i=0; i<varCount; i++){ PageData vpd = varList.get(i); HSSFRow rows = sheet.createRow(i+1); for(int j=0;j<len;j++){ String varstr = vpd.getString("var"+(j+1)) != null ? vpd.getString("var"+(j+1)) : ""; rows.setRowStyle(contentStyle); rows.createCell(j).setCellValue(varstr); } }
}
}