读取百万级数据量的xlsx文件的java代码

上传者: u011186240 | 上传时间: 2019-12-21 21:21:45 | 文件大小: 13.11MB | 文件类型: rar
文件里包含可以运行起来的项目,下载下来解压后,引入项目就可以运行看结果了。该代码可以处理100万数据量的excel文件,xlsx文件数据量太大,用普通的读法会报内存溢出错误,所以用官网提供的方法,一条一条的读取大excel文件,本例子从这点出发,组装excel里读取的单条数据为list,在根据需求操作list,即单条读取,单条操作,下载下来 后找到endRow(int rowNum)函数,在函数末尾有个注销的list数组打印,这个list即从excel里读取的当前行,列顺序同excel里的列顺序,直接操作list即可。

文件下载

资源详情

[{"title":"( 19 个子文件 13.11MB ) 读取百万级数据量的xlsx文件的java代码","children":[{"title":"testpoi","children":[{"title":"bin","children":[{"title":"cn","children":[{"title":"com","children":[{"title":"poi","children":[{"title":"utils","children":[{"title":"XLSX2CSV.class <span style='color:#111;'> 5.48KB </span>","children":null,"spread":false},{"title":"XLSX2CSV$SheetConvert.class <span style='color:#111;'> 3.18KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":".settings","children":[{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 629B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"cn","children":[{"title":"com","children":[{"title":"poi","children":[{"title":"utils","children":[{"title":"XLSX2CSV.java <span style='color:#111;'> 8.95KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":".project <span style='color:#111;'> 383B </span>","children":null,"spread":false},{"title":".classpath <span style='color:#111;'> 1.09KB </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"junit-4.12.jar <span style='color:#111;'> 307.55KB </span>","children":null,"spread":false},{"title":"poi-3.16.jar <span style='color:#111;'> 2.56MB </span>","children":null,"spread":false},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"poi-examples-3.16.jar <span style='color:#111;'> 361.12KB </span>","children":null,"spread":false},{"title":"commons-codec-1.10.jar <span style='color:#111;'> 277.52KB </span>","children":null,"spread":false},{"title":"commons-collections4-4.1.jar <span style='color:#111;'> 733.63KB </span>","children":null,"spread":false},{"title":"curvesapi-1.04.jar <span style='color:#111;'> 96.06KB </span>","children":null,"spread":false},{"title":"poi-scratchpad-3.16.jar <span style='color:#111;'> 1.32MB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.16.jar <span style='color:#111;'> 1.37MB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.16.jar <span style='color:#111;'> 5.60MB </span>","children":null,"spread":false},{"title":"commons-logging-1.2.jar <span style='color:#111;'> 60.38KB </span>","children":null,"spread":false},{"title":"log4j-1.2.17.jar <span style='color:#111;'> 478.40KB </span>","children":null,"spread":false},{"title":"poi-excelant-3.16.jar <span style='color:#111;'> 30.49KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}]

评论信息

  • 王天天 :
    骗钱骗人!!!!!
    2020-09-09
  • txl12345678 :
    代码可以使用,作为参考很有意义
    2020-06-16
  • 豫东一棵草 :
    可以,可以。。。。。。。。。
    2019-08-15
  • huangleiRock :
    无法下载。。。。。
    2019-06-19
  • 杨逸仑 :
    可以.用......................
    2018-07-13

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明