Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size

最新推荐文章于 2024-10-17 22:26:51 发布
最新推荐文章于 2024-10-17 22:26:51 发布
阅读量768 收藏
点赞数 3
分类专栏： Java 文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/zcxbd/article/details/138160211
版权
文章讲述了在Java开发过程中，遇到Excel导入时出现Zipbomb检测错误，提示文件可能被用于消耗内存，从而构成安全威胁。解决方案是调整ZipSecureFile设置以处理大文件，确保按指定模板导入以避免问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

Java开发-excel导入报错

在这里插入图片描述

com.seeburger.webedi.exception.BusinessException: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data.
This may indicate that the file is used to inflate memory usage and thus could pose a security risk.
You can adjust this limit via ZipSecureFile.setMinInflateRatio() if you need to work with files which exceed this limit.
Uncompressed size: 1398835, Raw/compressed size: 13987, ratio: 0.009999
Limits: MIN_INFLATE_RATIO: 0.010000, Entry: xl/styles.xml
	at com.seeburger.webedi.exception.BusinessException.locael(BusinessException.java:38)
	at com.seeburger.webedi.utils.poi.ExcelUtil.importExcel(ExcelUtil.java:679)
	at com.seeburger.webedi.po.service.HuService.importExcel(HuService.java:831)
	at com.seeburger.webedi.po.service.HuService.importHuByExcel(HuService.java:686)
	at com.seeburger.webedi.po.service.HuService$$FastClassBySpringCGLIB$$1.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)
	at com.seeburger.webedi.po.service.HuService$$EnhancerBySpringCGLIB$$1.importHuByExcel(<generated>)
	at com.seeburger.webedi.po.controller.HuController.importHu(HuController.java:136)
	at com.seeburger.webedi.po.controller.HuController$$FastClassBySpringCGLIB$$1.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:64)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
	at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:57)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:58)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)
	at com.seeburger.webedi.po.controller.HuController$$EnhancerBySpringCGLIB$$1.importHu(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at com.seeburger.webedi.interceptor.xss.XssFilter.doFilter(XssFilter.java:34)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at com.seeburger.webedi.interceptor.WrapFilter.doFilter(WrapFilter.java:42)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at com.seeburger.webedi.interceptor.LogMdcFilter.doFilter(LogMdcFilter.java:39)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:97)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:41002)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)

原因：excel导入模板表头有筛选等

解决方案：用户按照指定模板导入即可

java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size
hlli86的博客
01-30 5635
文章目录java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data.1、使用poi导入excel文件时碰到如下问题2、问题的解决方法 java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compr
Limits: MIN_INFLATE_RATIO: 0.010000, Entry: xl/pivotCache/pivotCacheRecords2.xml(POI安全-压缩炸弹)
LCJ0018的博客
01-11 1075
在报错代码上一行加上，问题得以解决（阅读报错信息，发现 ratio: 0.009949，而Limits: MIN_INFLATE_RATIO: 0.010000。报错的原因：上传的文件的压缩已经低于默认的。在...poi.jar包中，找到。类，如图：（也可以直接搜索这个类。处理方式：在读取文件前，将这个。
读取excel报错 Zip bomb detected! The file would exceed the max. ratio of compressed file size to the
热门推荐
愤怒的苹果ext的博客
11-10 2万+
读取excel报错 Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data，完整报错信息如下所示。 java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of th.
java.io.IOException: Zip bomb detected! The file would exceed the max.
泽辉的技术博客
12-26 1万+
解决办法： 添加一行代码即可 ZipSecureFile.setMinInflateRatio(-1.0d); 参考： FileInputStream file = new FileInputStream("/file/path/report.xlsx"); ZipSecureFile.setMinInflateRatio(-1.0d); XSSFWorkbook wb = ne...
poi读取excel报错：Zip bomb detected! The file would exceed the max
adions0819的博客
08-10 3130
POI导出导入场景遇到的问题。
处理导入Excel文件过大导致Zip bomb detected的问题
后端开发
06-14 2264
此错误提示文件大小超过了压缩文件大小与解压后数据大小之比的最大限制，为了处理这一问题，可以在方法体的顶部添加一行代码来调整这一限制。调整垃圾回收器的设置，以提高内存管理的效率，例如，可以使用G1垃圾回收器。和增加堆内存大小外，还有一些优化策略可以帮助处理大文件。
EasyExcel 遭遇 java.io.IOException: Zip bomb detected
AlbenXie的博客
12-19 4607
在报错代码上一行加上，问题得以解决（阅读报错信息，发现 ratio: 0.009999633802473054，而Limits: MIN_INFLATE_RATIO: 0.01，setMinInflateRatio() if you need to work with files which exceed this limit）在网上搜索其他两种设置： 代表将接受所有可能的比率。
java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size代码如何进行完美处理
06-09
The total size of compressed files would exceed the max. ratio of file size."); } // 处理压缩文件 // ... } } catch (IOException e) { // 处理异常 // ... } ``` 在此示例代码中，我们使用...
java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size怎么处理
06-09
3. 使用其它压缩工具：如果您确信文件没有被恶意压缩，可以尝试使用其它压缩工具，如7-Zip或WinRAR。这些工具具有更高的压缩比率，但也更加安全。 4. 检查文件是否被恶意压缩：如果以上方法都无法解决问题，您应该...
使用Hutool操作Excel的时候出现的问题（压缩比问题）
flash_love的博客
08-28 859
今天在使用Hutool操作Excel的时候，出现了一个问题，导致操作失败。
JAVA导入Excel 报错 java.io.IOException: Zip bomb detected!
weixin_34343308的博客
10-29 5017
2019独角兽企业重金招聘Python工程师标准>>> ...
easyexcel导入报错java.io.IOException: Zip bomb detected!
xiaobozhang1993的博客
02-26 2666
使用easyexcel导入文件，结果提示报错: java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data. This may indicate that the file is used to inflate memory usage and thus could pose a security r
easyExcel读取excel报错( java.io.IOException: Zip bomb detected!)
wen1187365110的专栏
07-12 3697
1. 问题描述 利用easyExcel读取excel信息 private List<Demo> readExcelDemo(){ String filePath = ...; DemoListener demoListener = new DemoListener(); EasyExcel.read(filePath, Demo.class,demoListener).sheet("产品目录").doRead(); return demoListener.getL
apache poi-检测到Zip Bomb解决方案
赵英超的博客
04-13 9928
异常信息： Caused by: com.alibaba.excel.exception.ExcelAnalysisException: java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data. This may indicate that the file is used to inflate
导入excel文件时显示文件过大处理方式
code3306的博客
07-26 1836
有的时候会报这种错，这个代表的是传输文件过大，禁止传入，解决方式就是在方法体的最上面的部分，加上一行代码。
Java 读取 Excel 报错
Minh-X
06-10 1722
Caused by: java.io.IOException: Zip bomb detected! The file would exceed the max. ratio of compressed file size to the size of the expanded data. This may indicate that the file is used to inflate memory usage and thus could pose a security risk. You can a
使用apache poi解析Excel加水印时报错Zip Bomb
chen2017sheng的博客
04-30 1046
Apache POI，Zip bomb detected，setMinInflateRatio
Zip bomb detected!解决办法
最新发布
由入门到精通
10-17 929
代码中增加如下一行代码。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值