From 4286e458968ab057d17e3522c7da72e7f58bd4a0 Mon Sep 17 00:00:00 2001 From: puzhibing <393733352@qq.com> Date: 星期日, 26 一月 2025 14:51:25 +0800 Subject: [PATCH] 修改 --- ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java index d385ba9..adae034 100644 --- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java +++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java @@ -937,11 +937,12 @@ public void importExpress(String url) { URL url1 = new URL(url); try (InputStream fileInputStream = url1.openStream()) { - Workbook workbook = new SXSSFWorkbook(new XSSFWorkbook(fileInputStream)); + Workbook workbook = new XSSFWorkbook(fileInputStream); Sheet sheet = workbook.getSheetAt(0); // 获取第一个Sheet int lastRowNum = sheet.getLastRowNum(); for (int i = 2; i <= lastRowNum; i++) { Row row = sheet.getRow(i); + row.getCell(1).setCellType(CellType.STRING); String orderNum = row.getCell(1).getStringCellValue(); // 快递单号 row.getCell(7).setCellType(CellType.STRING); -- Gitblit v1.7.1