【Excel导出--固定表头动态行数据--easyExcel】

最新推荐文章于 2024-07-23 14:41:16 发布

是阿淼啊

最新推荐文章于 2024-07-23 14:41:16 发布

阅读量735

点赞数 8

文章标签： excel windows java

是阿淼啊

本文链接：https://blog.csdn.net/qq_53195321/article/details/134998389

版权

实现效果
代码实现

List<MesReportedWagesVo> list = reportedWages.getList();
        try {
            List<List<Object>> dataList = new ArrayList<>();

            BigDecimal totalPricePd = new BigDecimal(0);
            //Double totalPricePd = 0.0;
            Integer totalCount = 0;
            for (MesReportedWagesVo mesReportedWagesVo : list) {
                List<Object> rowData = new ArrayList<>();
                List<Object> rowDataTwo = new ArrayList<>();

                // 添加员工信息到行数据
                String name = "姓名：" + mesReportedWagesVo.getRealName() + "，工号："+mesReportedWagesVo.getStaffId();
                String sum = "个人合计：" + mesReportedWagesVo.getSumCount() + "件，"+mesReportedWagesVo.getSumPricePd()+"元";
                rowData.add(name);
                //rowData.add(sum);
                totalPricePd.add(mesReportedWagesVo.getSumPricePd()) ;
                totalCount +=  mesReportedWagesVo.getSumCount();

                // 将包含员工信息的行数据添加到 dataList
                dataList.add(rowData);
                // 添加工资详情项到行数据（多行数据）
                for (MesEngineeringManagementDTO mesEngineeringManagementDTO : mesReportedWagesVo.getMesEngineeringManagementDTOList()) {
                    List<Object> itemData = new ArrayList<>();
                    itemData.add(mesEngineeringManagementDTO.getProduceNum());
                    itemData.add(mesEngineeringManagementDTO.getColorName());
                    itemData.add(mesEngineeringManagementDTO.getSizeCode());
                    itemData.add(mesEngineeringManagementDTO.getProductName());
                    itemData.add(mesEngineeringManagementDTO.getPricePd());
                    itemData.add(mesEngineeringManagementDTO.getCount());
                    itemData.add(mesEngineeringManagementDTO.getPrice());
                    dataList.add(itemData);
                }
                rowDataTwo.add(sum);
                dataList.add(rowDataTwo);
            }
            // 创建 ExcelWriter 对象
            String fileName ="报工工资统计表";
            fileName = URLEncoder.encode(fileName, "UTF-8");
            response.setContentType("application/vnd.ms-excel");
            response.setCharacterEncoding("UTF-8");
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
            ExcelWriter writer = EasyExcel.write(response.getOutputStream()).build();

            // 创建 Sheet 对象并设置表头
            Sheet sheet = new Sheet(1, 0);
            List<List<String>> data = new ArrayList<>();
            data.add(Arrays.asList("报工工资统计表","合计："+totalCount+"件，金额："+totalPricePd,"生产单号"));
            data.add(Arrays.asList("报工工资统计表","合计："+totalCount+"件，金额："+totalPricePd,"颜色"));
            data.add(Arrays.asList("报工工资统计表","合计："+totalCount+"件，金额："+totalPricePd,"尺码"));
            data.add(Arrays.asList("报工工资统计表","合计："+totalCount+"件，金额："+totalPricePd,"工序"));
            data.add(Arrays.asList("报工工资统计表","合计："+totalCount+"件，金额："+totalPricePd,"单价"));
            data.add(Arrays.asList("报工工资统计表","合计："+totalCount+"件，金额："+totalPricePd,"数量"));
            data.add(Arrays.asList("报工工资统计表","合计："+totalCount+"件，金额："+totalPricePd,"金额"));
            sheet.setHead(data);
            sheet.setAutoWidth(true);
            sheet.setSheetName("报工工资统计表");
            // 写入数据
            writer.write0(dataList, sheet);
            // 关闭 ExcelWriter 对象
            writer.finish();
        } catch (Exception e) {
            e.printStackTrace();
        }