From dec8951aae400e54f6ee83a8f95867dba9da8af1 Mon Sep 17 00:00:00 2001 From: zhanghl <253316343@qq.com> Date: 星期五, 23 五月 2025 17:17:33 +0800 Subject: [PATCH] [钣金计划大表] 优化:焊缝统计导出Excel样式 --- aps-modules/aps-core/src/main/java/com/aps/core/service/mainPlan/impl/ApsWeldSeamStatisticsV2ServiceImpl.java | 11 ++--------- 1 files changed, 2 insertions(+), 9 deletions(-) diff --git a/aps-modules/aps-core/src/main/java/com/aps/core/service/mainPlan/impl/ApsWeldSeamStatisticsV2ServiceImpl.java b/aps-modules/aps-core/src/main/java/com/aps/core/service/mainPlan/impl/ApsWeldSeamStatisticsV2ServiceImpl.java index 32599c0..ec82f44 100644 --- a/aps-modules/aps-core/src/main/java/com/aps/core/service/mainPlan/impl/ApsWeldSeamStatisticsV2ServiceImpl.java +++ b/aps-modules/aps-core/src/main/java/com/aps/core/service/mainPlan/impl/ApsWeldSeamStatisticsV2ServiceImpl.java @@ -229,14 +229,8 @@ //2. 鍒涘缓Excel宸ヤ綔绨� SXSSFWorkbook wb = new SXSSFWorkbook(500); - ExcelUtil<ApsWeldSeamStatisticsV2> excelUtil = new ExcelUtil<>(ApsWeldSeamStatisticsV2.class); - excelUtil.init(list, "鐒婄紳缁熻琛�", "鐒婄紳缁熻琛�", Excel.Type.EXPORT); - excelUtil.createWorkbook(); - excelUtil.createExcelField(); - - Map<String, CellStyle> cellStyleMap = excelUtil.createStyles(wb); - CellStyle titleStyle = cellStyleMap.get("header_WHITE_GREY_50_PERCENT"); - CellStyle dataStyle = cellStyleMap.get("data_CENTER_BLACK_WHITE_STRING_false"); + CellStyle titleStyle = ExcelUtil.getCommonHeaderStyle(wb); + CellStyle dataStyle =ExcelUtil.getDataCellStyle(wb); SXSSFSheet sheet = wb.createSheet("鐒婄紳缁熻琛�"); List<LinkedHashMap<String,String>> titleList= initRowTitle(); @@ -255,7 +249,6 @@ //5. 鏋勫缓鏁版嵁琛� LinkedHashMap<String, String> first = titleList.get(0); ArrayList<Map.Entry<String, String>> titles = new ArrayList<>(first.entrySet()); - List<String> stringFiledKeys=Arrays.asList("productionBase","isSatisfy"); for (int rowInx = 0; rowInx < list.size(); rowInx++) { SXSSFRow dataRow = sheet.createRow(rowInx + 2); ApsWeldSeamStatisticsV2 statistics = list.get(rowInx); -- Gitblit v1.9.3