前台js
function exportXlsx(){
window.location.href="pmtaskController.do?exportXlsx";//不要用ajax方式,否则不能弹出下载框
}
后台
public static void exportExcel(String[] headers, List<TaskEntity> tasks, String pattern,HttpServletResponse response)
throws Exception {
//创建一个工作簿 即excel文件,再在该文件中创建一个sheet
HSSFWorkbook wb=new HSSFWorkbook();
HSSFSheet sheet=wb.createSheet("项目计划");
//在sheet中创建一行
HSSFRow row=sheet.createRow(0);
//表头
for(int i = 0; i < headers.length; i++){
row.createCell(i).setCellValue(headers[i]);
}
for(int i = 0; i < tasks.size(); i++){
row = sheet.createRow(i+1);
//设置每一行中每个表格的数据
row.createCell(0).setCellValue(tasks.get(i).getSn());
row.createCell(1).setCellValue(tasks.get(i).getName());
row.createCell(2).setCellValue(tasks.get(i).getOwnerName());
row.createCell(3).setCellValue(tasks.get(i).getDeptName());
row.createCell(4).setCellValue(tasks.get(i).getStatus());
row.createCell(5).setCellValue(tasks.get(i).getTaskLevel());
row.createCell(6).setCellValue(getFormatDate(tasks.get(i).getStartDate(),pattern));
row.createCell(7).setCellValue(getFormatDate(tasks.get(i).getFinishDate(),pattern));
row.createCell(8).setCellValue(getFormatDate(tasks.get(i).getActualFinishDate(),pattern));
row.createCell(9).setCellValue(tasks.get(i).getWorkload());
row.createCell(10).setCellValue(tasks.get(i).getDuration());
}
// 输出Excel文件
OutputStream output = response.getOutputStream();
response.setContentType("application/vnd.ms-excel;charset=utf-8");// 2003
String fileName = "项目计划.xlsx";
response.setHeader("Content-disposition",
"attachment; filename="+ new String(fileName.getBytes(),"iso-8859-1"));
wb.write(output);
output.flush();
output.close();
response.flushBuffer();
}
public static String getFormatDate(Date date,String pattern) {
if(null != date){
return DateUtils.formatDate(date,pattern);
}
return "";
}