1.新建类继承AbstractExcelView
public class TestObjectExcelView extends AbstractExcelView{
@Override
protected void buildExcelDocument(Map<String, Object> model, HSSFWorkbook workbook, HttpServletRequest request,
HttpServletResponse response) throws Exception {
// TODO Auto-generated method stub
Date date = new Date();
String filename = Tools.date2Str(date);
HSSFSheet sheet;
HSSFCell cell;
response.setContentType("application/octet-stream");
response.setHeader("Content-Disposition", "attachment;filename="+filename+".xls");
sheet = workbook.createSheet("Sheet1");
List<String> titles = (List<String>) model.get("titles");
int len = titles.size();
HSSFCellStyle headerStyle = workbook.createCellStyle(); //标题样式
headerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
headerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
HSSFFont headerFont = workbook.createFont(); //标题字体
headerFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
headerFont.setFontHeightInPoints((short)11);
headerStyle.setFont(headerFont);
short width = 20,height = 25*20;
sheet.setDefaultColumnWidth(width);
for (int i = 0; i < len; i++) { //设置标题
String title = titles.get(i);
cell = getCell(sheet, 0, i);
cell.setCellStyle(headerStyle);
setText(cell, title);
}
sheet.getRow(0).setHeight(height);
HSSFCellStyle contentStyle = workbook.createCellStyle(); //内容样式
contentStyle.setAlignment(HSSFCellStyle.ALIGN_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);
for (int j = 0; j < len; j++) {
String varstr = vpd.getString("var"+(j+1)) != null ?vpd.getString("var"+(j+1)):"";
cell = getCell(sheet, i+1, j);
cell.setCellStyle(contentStyle);
setText(cell, varstr);
}
}
}
}
2接下来在你的下载 Controller里面返回ModelAndView 即可
/**
*导出Excel
*/
@RequestMapping(value="toExcel")
public ModelAndView toExcel() {
ModelAndView mv = new ModelAndView();
Map<String, Object> dataMap = new HashMap<>();
List<String> titles = new ArrayList<>();
List<PageData> varList = new ArrayList<>();
PageData pd = new PageData();
try {
pd = this.getPageData();
titles.add("序号");
titles.add("订单号");
titles.add("会员姓名");
titles.add("交易金额");
titles.add("订单类型");
titles.add("支付方式");
titles.add("创建时间");
titles.add("交易备注");
dataMap.put("titles", titles);
List<PageData> listAll = transactionRecordService.listAll(pd);
BigDecimal b = new BigDecimal("100");
int varLength = listAll.size();
for(int i=0; i<varLength; i++) {
PageData tem = new PageData();
PageData var = listAll.get(i);
tem.put("var1", ""+(i+1));
tem.put("var2", var.get("trOrderId").toString());
tem.put("var3", (var.get("miRealName") != null && !"".equals(var.get("miRealName")))?var.get("miRealName").toString():"");
tem.put("var4", new BigDecimal(var.get("trAmount").toString()).divide(b)+"");
tem.put("var5", (Integer)var.get("trOrderType") == 0?"服务订单":"");
tem.put("var6", (Integer)var.get("trPayChannel") == 0?"余额":((Integer)var.get("trPayChannel") == 1?"支付宝":"微信" ));
tem.put("var7", var.get("trCreateTime").toString());
tem.put("var8", var.get("trRemarks").toString());
varList.add(tem);
}
dataMap.put("varList", varList);
ObjectExcelView erv = new ObjectExcelView(); //执行Excel操作
mv = new ModelAndView(erv, dataMap);
} catch (Exception e) {
logger.error("交易记录导出失败://n//r"+e.toString(),e);
}
return mv;
}