java统计数据并导出Excel

最新推荐文章于 2024-08-04 03:59:45 发布

_蔚然

最新推荐文章于 2024-08-04 03:59:45 发布

阅读量1.6k

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/qq_38949960/article/details/88863214

版权

这篇博客主要介绍了如何使用Java进行业务数据的统计，并结合JavaScript实现报表的下载功能，通过Excel工具类完成数据导出到Excel的操作。

摘要由CSDN通过智能技术生成

业务代码：

@RequestMapping(value = "/exportDepartStatistics.html")
    @ResponseBody
    public HashMap<String, Object> exportDepartStatistics(HttpServletRequest request, HttpServletResponse response)  {
   
        System.out.println("exportDepartStatistics");

        String declareYear = request.getParameter("declareYear");

        HashMap<String, Object> modelmap = new HashMap<>();
        String status = "success"; //ajax状态
        //excel标题
        String[] title = {
   "序号","部门","已审核","未审核","已总结","合计"};
        //excel文件名
        String fileName = "DepartStatistics"+ DateTools.dateToString(new Date(),"yyy-MM-dd-HHmmss") + ".xls";
        //sheet名
        String sheetName = "";
        if (declareYear == null || "".equals(declareYear)){
   
            sheetName =  "各部门情况统计";
        }else{
   
            sheetName =  declareYear + "年各部门情况统计";
        }

        //响应到客户端
        try {
   
            //获取存储路径
            ConfigItem configItem = configItemService.queryConfigItem(ConfigItem.TYPE_STATISTICS_PATH);
            if(configItem == null || configItem.getCurrentValue() == null){
   
                modelmap.put("status","lose");
                return modelmap;
            }

			Map<String,String> map = new HashMap<String,String>();
			map.put("type", Case.TYPE_DEPART);
			map.put("declareYear",declareYear);
			map.put("handlingDepartment", null);

            //获取数据
            List<Map<String, Object>> countList = caService.getCountList(map);

            String [][] content = new String[countList.size()