JavaWeb中导出excel文件的简单方法
在平时做系统项目时,经常会需要做导出功能,不论是导出excel,还是导出cvs文件。我下面的demo是在springmvc的框架下实现的。
1.JS中只需要用GET模式请求导出就可以了:
$('#word-export-btn').parent().on('click',function(){ varpromotionWord=JSON.stringify($('#mainForm').serializeObject()); location.href="${ctx}/promotionWord/export?promotionWord="+promotionWord; });
2.在controller中要做的是将文件以数据流格式输出:
@RequestMapping("/export") publicvoidexport(HttpSessionsession,StringpromotionWord,HttpServletRequestrequest,HttpServletResponseresponse)throwsIOException{ UsersessionUser=(User)session.getAttribute("user"); JSONObjectjsonObj=JSONObject.parseObject(promotionWord); HSSFWorkbookwb=promotionWordService.export(sessionUser.getId(),jsonObj); response.setContentType("application/vnd.ms-excel"); Calendarcal=Calendar.getInstance(); SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-dd"); StringfileName="word-"+sdf.format(cal.getTime())+".xls"; response.setHeader("Content-disposition","attachment;filename="+fileName); OutputStreamouputStream=response.getOutputStream(); wb.write(ouputStream); ouputStream.flush(); ouputStream.close(); }
3.在service中需要将数据写入到格式文件中:
publicHSSFWorkbookexport(StringuserId,JSONObjectjsonObj){ HSSFWorkbookwb=newHSSFWorkbook(); HSSFSheetsheet=wb.createSheet("word"); HSSFRowrow=sheet.createRow(0); HSSFCellStylestyle=wb.createCellStyle(); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); List<PromotionWord>pWordList; Map<String,Object>map=newHashMap<>(); map.put("userId",userId); map.put("checkExistRule",jsonObj.getString("checkExistRule")); map.put("status",jsonObj.getString("status")); map.put("qsStar",jsonObj.getString("qsStar")); map.put("impressionCount",jsonObj.getString("impressionCount")); map.put("selectGroupId",jsonObj.getString("selectGroupId")); map.put("isCheck",jsonObj.getString("isCheck")); map.put("word",jsonObj.getString("word")); Longimpression=jsonObj.getLong("impressionCount"); Longclick=jsonObj.getLong("clickCount"); if(impression!=null){ PromotionWordword=newPromotionWord(); word.setCreatedBy(userId); word.setImpressionCount7(impression); pWordList=getTwentyPercentlists(word); if(pWordList!=null&&pWordList.size()>0){ map.put("impressionCount",pWordList.get(pWordList.size()-1).getImpressionCount()); }else{ map.put("impressionCount",1); } }elseif(click!=null){ PromotionWordword=newPromotionWord(); word.setCreatedBy(userId); word.setClickCount7(click); pWordList=getTwentyPercentlists(word); if(pWordList!=null&&pWordList.size()>0){ map.put("clickCount",pWordList.get(pWordList.size()-1).getClickCount()); }else{ map.put("clickCount",1); } } List<PromotionWord>list=commonDao.queryList(PROMOTION_WORD_DAO+".queryExportDataByUser",map); String[]excelHeader={"关键词","价格","搜索热度","推广评分","购买热度","曝光量","点击量","点击率","推广时长","花费","平均点击花费","匹配产品数","预估排名","状态"}; for(inti=0;i<excelHeader.length;i++){ HSSFCellcell=row.createCell(i); cell.setCellValue(excelHeader[i]); cell.setCellStyle(style); if(i==0){ sheet.setColumnWidth(0,30*256); }else{ sheet.setColumnWidth(i,10*256); } } if(list!=null&&list.size()>0) for(inti=0;i<list.size();i++){ row=sheet.createRow(i+1); PromotionWordword=list.get(i); row.createCell(0).setCellValue(word.getWord()); row.createCell(1).setCellValue(word.getPrice()+""); row.createCell(2).setCellValue(word.getSearchCount()); row.createCell(3).setCellValue(word.getQsStar()); row.createCell(4).setCellValue(word.getBuyCount()); row.createCell(5).setCellValue(word.getImpressionCount7()); row.createCell(6).setCellValue(word.getClickCount7()); if(word.getClickCount7()==0L){ row.createCell(7).setCellValue("0.00%"); }else{ DecimalFormatdf=newDecimalFormat("0.00%"); row.createCell(7).setCellValue(df.format((Double.valueOf(word.getClickCount7())/Double.valueOf(word.getImpressionCount7())))); } row.createCell(8).setCellValue(word.getOnlineTime7()); row.createCell(9).setCellValue(word.getCost7()+""); row.createCell(10).setCellValue(word.getAvgCost7()+""); row.createCell(11).setCellValue(word.getMatchCount()); Stringrank=""; if(word.getMatchCount()!=null&&word.getMatchCount()!=0){ if(word.getProspectRank()==null||word.getProspectRank()==0L){ rank="其他位置"; }else{ rank="第"+word.getProspectRank()+"位"; } }else{ rank="---"; } row.createCell(12).setCellValue(rank); row.createCell(13).setCellValue(word.getStatus()==1?"暂停":"启动"); } returnwb; }
这样之后就可以直接点击导出就有效果了。
以上就是小编为大家带来的JavaWeb中导出excel文件的简单方法全部内容了,希望大家多多支持毛票票~