jxls操作excel文件

来源：互联网发布：张予曦的淘宝店名字编辑：程序博客网时间：2024/05/19 20:43

Map<String,Object> beans = new HashMap<String,Object>();

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
beans.put("dateFormat", dateFormat);
beans.put("resultList", artList);
beans.put("tag", SpringContextUtil.getBean(TagUtil.class));
beans.put("constUtil", SpringContextUtil.getBean(ConstUtil.class));
beans.put("custId",Integer.parseInt(custId));
XLSTransformer transformer = new XLSTransformer();
String path= request.getRealPath("/");
transformer.markAsFixedSizeCollection("resultList");
String templateFile=path+"//WEB-INF/classes/template/archiveReportTemplate.xls";
String reportFile=path+"//WEB-INF//classes//archiveReport_"+System.currentTimeMillis()+".xls";
transformer.transformXLS(templateFile, beans, reportFile);
String fileName="archiveReport_"+DateUtils.formatDate(new Date(), "yyyyMMddHHmmss")+".xls";
doDownLoad(reportFile,fileName,response);
File file=new File(reportFile);
if(file.exists()){
file.delete();
}

http://blog.csdn.net/geloin/article/details/17242523

0 0