@RequestMapping(value = "toExcel")
public void toExcel(HttpServletRequest request,HttpServletResponse response,Integer eid){
// 第一步,创建一个webbook,对应一个Excel文件
HSSFWorkbook wb = new HSSFWorkbook();
// 第二步,在webbook中添加一个sheet,对应Excel文件中的sheet
HSSFSheet sheet = wb.createSheet("sheet1");
// 第三步,在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
HSSFRow row = sheet.createRow((int) 0);
// 第四步,创建单元格,并设置值表头 设置表头居中
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式
HSSFCell cell = row.createCell(0);
cell = row.createCell(1);
cell.setCellValue("起始时间");
cell.setCellStyle(style);
cell = row.createCell(2);
cell.setCellValue("结束时间");
cell.setCellStyle(style);
cell = row.createCell(3);
cell.setCellValue("费用");
for(int i=0;i<list.size();i++){
row = sheet.createRow(i + 1);
TErrorHistory history=list.get(i);
// 第四步,创建单元格,并设置值
row.createCell(0).setCellValue((history.getErrorname()==null?"":history.getErrorname()));
if(history.getStarttime()!=null){
row.createCell(1).setCellValue(DateAndTimeUtil.dateFormatFull(history.getStarttime()));
}else{
row.createCell(1).setCellValue("");
}
if(history.getEndtime()!=null){
row.createCell(2).setCellValue(DateAndTimeUtil.dateFormatFull(history.getEndtime()));
}else{
row.createCell(2).setCellValue("");
}
row.createCell(3).setCellValue((history.getCostprice()==null?"":history.getCostprice().toString()));
try {
out = response.getOutputStream();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
Date date = new Date();
String fileName = sdf.format(date)+".xls";
response.reset();
response.setContentType("application/msexcel");
response.setHeader("Content-disposition", "attachment; filename="+fileName);
wb.write(out);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void toExcel(HttpServletRequest request,HttpServletResponse response,Integer eid){
// 第一步,创建一个webbook,对应一个Excel文件
HSSFWorkbook wb = new HSSFWorkbook();
// 第二步,在webbook中添加一个sheet,对应Excel文件中的sheet
HSSFSheet sheet = wb.createSheet("sheet1");
// 第三步,在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
HSSFRow row = sheet.createRow((int) 0);
// 第四步,创建单元格,并设置值表头 设置表头居中
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式
HSSFCell cell = row.createCell(0);
//设置标头
cell.setCellValue("故障名称");
cell.setCellStyle(style);cell = row.createCell(1);
cell.setCellValue("起始时间");
cell.setCellStyle(style);
cell = row.createCell(2);
cell.setCellValue("结束时间");
cell.setCellStyle(style);
cell = row.createCell(3);
cell.setCellValue("费用");
cell.setCellStyle(style);
//查找数据
for(int i=0;i<list.size();i++){
row = sheet.createRow(i + 1);
TErrorHistory history=list.get(i);
// 第四步,创建单元格,并设置值
row.createCell(0).setCellValue((history.getErrorname()==null?"":history.getErrorname()));
if(history.getStarttime()!=null){
row.createCell(1).setCellValue(DateAndTimeUtil.dateFormatFull(history.getStarttime()));
}else{
row.createCell(1).setCellValue("");
}
if(history.getEndtime()!=null){
row.createCell(2).setCellValue(DateAndTimeUtil.dateFormatFull(history.getEndtime()));
}else{
row.createCell(2).setCellValue("");
}
row.createCell(3).setCellValue((history.getCostprice()==null?"":history.getCostprice().toString()));
}
//下载
try {
out = response.getOutputStream();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
Date date = new Date();
String fileName = sdf.format(date)+".xls";
response.reset();
response.setContentType("application/msexcel");
response.setHeader("Content-disposition", "attachment; filename="+fileName);
wb.write(out);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}