From 29c36380f636c0ae22d668c856c03a543bcca1c8 Mon Sep 17 00:00:00 2001 From: fwq <582742538@qq.com> Date: 星期一, 23 十月 2023 19:25:23 +0800 Subject: [PATCH] 捕获异常判断2007 --- src/main/java/com/hx/util/ExcelUtil.java | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/hx/util/ExcelUtil.java b/src/main/java/com/hx/util/ExcelUtil.java index 9c789f8..ce1713f 100644 --- a/src/main/java/com/hx/util/ExcelUtil.java +++ b/src/main/java/com/hx/util/ExcelUtil.java @@ -3,6 +3,7 @@ import com.hx.exception.TipsException; import com.monitorjbl.xlsx.StreamingReader; import org.apache.poi.hssf.usermodel.*; +import org.apache.poi.openxml4j.exceptions.OLE2NotOfficeXmlFileException; import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.streaming.SXSSFWorkbook; import org.apache.poi.xssf.usermodel.XSSFCell; @@ -884,7 +885,10 @@ .bufferSize(10240) .open(new FileInputStream(file)); listData =readhandle(book); - }catch (Exception e){ + }catch (OLE2NotOfficeXmlFileException ex){ + ex.printStackTrace(); + throw new RuntimeException("excel鐗堟湰涓嶄负2007鍙婁互涓�"); + } catch (Exception e){ e.printStackTrace(); throw new RuntimeException(e.getMessage()); } -- Gitblit v1.8.0