hutool获取大数据量的excel内容及sheet名称问题
创始人
2024-11-14 16:06:03
0次

读取大数据量的excel时

代码如下

private static RowHandler createRowHandler() {         return new RowHandler() {             @Override             public void handle(int i, long l, List list) {                 System.out.println(i + " " + l + " " + list);             }         };     }     public static void main(String[] args) {         File file = FileUtil.file("d:/1.xlsx");         ExcelUtil.readBySax(file,-1,createRowHandler());      } 
报错
NoSuchMethodError:org.apache.poi.util.XMLHelper.newXMLReader()
解决办法
修改源码
 
ExcelSaxUtil中readFrom方法中的xmlReader = XMLHelper.newXMLReader();
 
改为
 
xmlReade SAXHelper.newXMLReader();
 
或者升级poi到5.x
读取sheet名称问题
代码如下
 
 public static List getSheetNames() throws IOException {         OPCPackage open = null;         try {             File file = FileUtil.file("d:/1.xlsx");             open = OPCPackage.open(file, PackageAccess.READ);             XSSFReader xssfReader = new XSSFReader(open);             SheetRidReader parse = SheetRidReader.parse(xssfReader);             List sheetNames = parse.getSheetNames();              return sheetNames;         } catch (IOException e) {             throw new RuntimeException(e);         } catch (OpenXML4JException e) {             throw new RuntimeException(e);         } finally {             if (open!= null){                 open.close();             }         }     }
 
这是运行没问题的 
当将open = OPCPackage.open(file, PackageAccess.READ);改为文件流的形式如下
 
open = OPCPackage.open(new FileInputStream(file));
 
将报错
 
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: 233647, Raw/compressed size: 2324, ratio: 0.009947 Limits: MIN_INFLATE_RATIO: 0.010000, Entry: xl/styles.xml
 
包括获取文件内容时将
 
ExcelUtil.readBySax(file,-1,createRowHandler());改为流的形式如下
 
ExcelUtil.readBySax(new FileInputStream(file),-1,createRowHandler()); 同样会报这个错
 
这是因为压缩率超过范围了 在执行之前添加代码
 
ZipSecureFile.setMinInflateRatio(-1.0);即可解决
 
改完后代码如下
 
package org.example;  import cn.hutool.core.io.FileUtil; import cn.hutool.poi.excel.ExcelUtil; import cn.hutool.poi.excel.sax.SheetRidReader; import cn.hutool.poi.excel.sax.handler.RowHandler; import org.apache.poi.openxml4j.exceptions.OpenXML4JException; import org.apache.poi.openxml4j.opc.OPCPackage; import org.apache.poi.openxml4j.opc.PackageAccess; import org.apache.poi.openxml4j.util.ZipSecureFile; import org.apache.poi.util.XMLHelper; import org.apache.poi.xssf.eventusermodel.XSSFReader;  import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.util.List;  public class Test5 {      private static RowHandler createRowHandler() {         return new RowHandler() {             @Override             public void handle(int i, long l, List list) {                 System.out.println(i + " " + l + " " + list);             }         };     }     public static void main(String[] args) throws FileNotFoundException {         ZipSecureFile.setMinInflateRatio(-1.0);         File file = FileUtil.file("d:/1.xlsx");         ExcelUtil.readBySax(new FileInputStream(file),-1,createRowHandler());      }     public static List getSheetNames() throws IOException {         OPCPackage open = null;         try {             ZipSecureFile.setMinInflateRatio(-1.0);             File file = FileUtil.file("d:/1.xlsx");             open = OPCPackage.open(new FileInputStream(file));             XSSFReader xssfReader = new XSSFReader(open);             SheetRidReader parse = SheetRidReader.parse(xssfReader);             List sheetNames = parse.getSheetNames();             return sheetNames;         } catch (IOException e) {             throw new RuntimeException(e);         } catch (OpenXML4JException e) {             throw new RuntimeException(e);         } finally {             if (open!= null){                 open.close();             }         }     }  }  
                
            
            
            

                
                            

            

                

                    上一篇：使用openpyxl库对Excel条件格式的深度探索

                

                

                    下一篇：kafka 消费者注册过程                

            

            
            

                
                
相关内容

                
            

            

            
            

               

            



        
        
    
    

    
    

        
        

            
            

                
                

                    
                    

                        
                        热门资讯
                        
                    

                    
                

                
            

            
            
            


                                
                

                    
                    

                        

                    

                    
                    
                    

                        实操分享开挂脚本!德扑圈多功能...
                        实操分享开挂脚本!德扑圈多功能开挂脚本，德扑圈好像存在有开挂脚本1、打开软件启动之后找到中间准星的标...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        如何分辨真伪透视器工具!WeP...
                        如何分辨真伪透视器工具!WePoKer多功能透视器工具，WePoKer切实是真的有透视器工具1、下载...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        一分钟揭秘作弊器脚本!红龙po...
                        一分钟揭秘作弊器脚本!红龙poker多功能作弊器脚本，红龙poker一直真的是有作弊器脚本1、实时红...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        一起来讨论作弊器脚本!德扑之星...
                        一起来讨论作弊器脚本!德扑之星多功能作弊器脚本，德扑之星本来有作弊器脚本德扑之星破解侠是真的助透视。...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        免费测试版外挂软件!WPK多功...
                        免费测试版外挂软件!WPK多功能外挂软件，WPK好像有外挂软件1、金币登录送、破产送、升级送、活动送...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        分享开挂内幕作弊器插件!德普之...
                        分享开挂内幕作弊器插件!德普之星多功能作弊器插件，德普之星一直真的是有作弊器插件1、德普之星公共底牌...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        总算了解开挂教程!德扑之星多功...
                        总算了解开挂教程!德扑之星多功能开挂教程，德扑之星确实存在有开挂教程1、超多福利：超高返利，海量正版...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        实测揭晓辅助技巧!智星德州扑克...
                        实测揭晓辅助技巧!智星德州扑克多功能辅助技巧，智星德州扑克本来真的有辅助技巧1、智星德州扑克模拟器是...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        玩家必看科普辅助教程!wpk多...
                        玩家必看科普辅助教程!wpk多功能辅助教程，wpk都是是真的有辅助教程1、操作简单，无需wpk手机版...
                    

                    
                

                                
                

                    
                    

                        

                    

                    
                    
                    

                        玩家必看科普透视挂app!AA...
                        玩家必看科普透视挂app!AAPoKer多功能透视挂app，AAPoKer一贯真的是有透视挂appA...