easyexcel 读取Excel报错：Limits: MIN_INFLATE_RATIO: 0.010000, Entry: xl/styles.xml

最新推荐文章于 2024-09-27 17:24:11 发布

原创

最新推荐文章于 2024-09-27 17:24:11 发布 · 2.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java #excel

在尝试使用阿里巴巴的Excel分析库解析Excel文件时遇到了Zipbombdetected异常，该异常由于文件压缩比例超过安全阈值导致。解决方案是通过调用ZipSecureFile.setMinInflateRatio()方法调整阈值，例如设置为0.001以允许解析。这允许处理超出默认限制的文件。

错误日志

10:09:31.336 [main] WARN com.alibaba.excel.analysis.v07.XlsxSaxAnalyser - Currently excel cannot get style information, but it doesn't affect the data analysis.You can try to save the file with office again or ignore the current error.
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 adjust this limit via ZipSecureFile.setMinInflateRatio() if you need to work with files which exceed this limit.
Uncompressed size: 669031, Raw/compressed size: 6656, ratio: 0.009949
Limits: MIN_INFLATE_RATIO: 0.010000, Entry: xl/styles.xml
	at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.checkThreshold(ZipArchiveThresholdInputStream.java:132)
	at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.read(ZipArchiveThresholdInputStream.java:82)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityManager$RewindableInputStream.read(XMLEntityManager.java:2919)
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(UTF8Reader.java:302)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(XMLEntityScanner.java:1895)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.scanQName(XMLEntityScanner.java:843)
	at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanAttribute(XMLNSDocumentS