/**
* 导出excel文件
*/
@RequestMapping(value = "export", method=RequestMethod.POST)
public String exportFile(StatCmsWebstat statCmsWebstat, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) {
try {
String fileName = showMonthStr(statCmsWebstat.getStartYear(), statCmsWebstat.getYear(),
statCmsWebstat.getStartMonth(), statCmsWebstat.getMonth()) + statCmsWebstat.getPhase() + "学段网站统计表.xlsx";
List<String> lsHead = new ArrayList<String>();
lsHead.add("序号");
lsHead.add("单位");
lsHead.add("站点总数");
lsHead.add("站点");
lsHead.add("");
lsHead.add("");
lsHead.add("");
lsHead.add("内容数量");
lsHead.add("总访问量");
lsHead.add("日均访问量");
ExportExcel excel = new ExportExcel(fileName, lsHead);
lsHead.clear();
lsHead.add("");
lsHead.add("");
lsHead.add("");
lsHead.add("主站");
lsHead.add("班级空间");
lsHead.add("专题网站");
lsHead.add("个人空间");
lsHead.add("");
lsHead.add("");
lsHead.add("");
excel.addHead(lsHead, 2);
excel.mergedregion(1, 2, 0, 0);
excel.mergedregion(1, 2, 1, 1);
excel.mergedregion(1, 2, 2, 2);
excel.mergedregion(1, 1, 3, 6);
excel.mergedregion(1, 2, 7, 7);
excel.mergedregion(1, 2, 8, 8);
excel.mergedregion(1, 2, 9, 9);
List<StatCmsWebstat> ls = statCmsWebstatService.findStatList(statCmsWebstat);
excel.setrownun(3);
Integer countSiteTotal = 0;
Integer countMainStationNum = 0;
Integer countThematicSpaceNum = 0;
Integer countClassSpaceNum = 0;
Integer countPersonalSpaceNum = 0;
Integer countContentNum = 0;
Integer countTotalview = 0;
Float countAverageDailyTraffic = (float)0.00;
if(ls.size()>0){
for (int i = 0; i < ls.size(); i++) {
StatCmsWebstat webstat = ls.get(i);
Row row = excel.addRow();
excel.addCell(row, 0, String.valueOf(i+1));
excel.addCell(row, 1, ls.get(i).getCreateUnit());
excel.addCell(row, 2, ls.get(i).getSiteTotal());
excel.addCell(row, 3, ls.get(i).getMainStationNum());
excel.addCell(row, 4, ls.get(i).getClassSpaceNum());
excel.addCell(row, 5, ls.get(i).getThematicSpaceNum());
excel.addCell(row, 6, ls.get(i).getPersonalSpaceNum());
excel.addCell(row, 7, ls.get(i).getContentNum());
excel.addCell(row, 8, ls.get(i).getTotalview());
excel.addCell(row, 9, ls.get(i).getAverageDailyTraffic());
countSiteTotal += webstat.getSiteTotal();
countMainStationNum += webstat.getMainStationNum();
countThematicSpaceNum += webstat.getThematicSpaceNum();
countClassSpaceNum += webstat.getClassSpaceNum();
countPersonalSpaceNum += webstat.getPersonalSpaceNum();
countContentNum += webstat.getContentNum();
countTotalview += webstat.getTotalview();
countAverageDailyTraffic += webstat.getAverageDailyTraffic();
}
Row rowCount = excel.addRow();
excel.addCell(rowCount, 0, "合计");
excel.addCell(rowCount, 1, "");
excel.addCell(rowCount, 2, countSiteTotal);
excel.addCell(rowCount, 3, countMainStationNum);
excel.addCell(rowCount, 4, countClassSpaceNum);
excel.addCell(rowCount, 5, countThematicSpaceNum);
excel.addCell(rowCount, 6, countPersonalSpaceNum);
excel.addCell(rowCount, 7, countContentNum);
excel.addCell(rowCount, 8, countTotalview);
excel.addCell(rowCount, 9, countAverageDailyTraffic);
excel.write(response, fileName).dispose();
}else{
addMessage(redirectAttributes, "没有找到可以导出的数据!");
}
return null;
} catch (Exception e) {
addMessage(redirectAttributes, "网站统计记录导出失败!");
}
return "redirect:"+Global.getAdminPath()+"/cms/statCmsWebstat/index";
}
Java导出Excel
最新推荐文章于 2024-12-27 17:45:46 发布