java读取excel之xlsl超大文件

上传者: zwyjg | 上传时间: 2019-12-21 22:25:23 | 文件大小: 11.82MB | 文件类型: zip
数据量小的,可以使用普通api来做, 但是当数据量非常大时,普通的就不行了,不过我的这个代码可以完美解决此问题

文件下载

资源详情

[{"title":"( 31 个子文件 11.82MB ) java读取excel之xlsl超大文件","children":[{"title":"ExcelUtil","children":[{"title":".project <span style='color:#111;'> 368B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"com","children":[{"title":"askingdata","children":[{"title":"excel","children":[{"title":"util","children":[{"title":"RowDataProcesser.java <span style='color:#111;'> 187B </span>","children":null,"spread":false},{"title":"ExcelUtil.java <span style='color:#111;'> 3.73KB </span>","children":null,"spread":false},{"title":"Xlsx2ListData.java <span style='color:#111;'> 5.61KB </span>","children":null,"spread":false},{"title":"Main2.java <span style='color:#111;'> 3.72KB </span>","children":null,"spread":false},{"title":"Main.java <span style='color:#111;'> 15.16KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"test","children":[{"title":"Hufan.java <span style='color:#111;'> 1.71KB </span>","children":null,"spread":false},{"title":"Main.java <span style='color:#111;'> 637B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"lib","children":[{"title":"poi-ooxml-3.14-20160307.jar <span style='color:#111;'> 1.23MB </span>","children":null,"spread":false},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"mongo-2.10.1.jar <span style='color:#111;'> 389.18KB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.14-20160307.jar <span style='color:#111;'> 5.65MB </span>","children":null,"spread":false},{"title":"xercesImpl.jar <span style='color:#111;'> 1.30MB </span>","children":null,"spread":false},{"title":"commons-io-2.4.jar <span style='color:#111;'> 180.80KB </span>","children":null,"spread":false},{"title":"poi-3.14-20160307.jar <span style='color:#111;'> 2.41MB </span>","children":null,"spread":false},{"title":"xml-apis.jar <span style='color:#111;'> 215.37KB </span>","children":null,"spread":false}],"spread":true},{"title":"doc","children":null,"spread":false},{"title":".settings","children":[{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 587B </span>","children":null,"spread":false},{"title":"org.eclipse.core.resources.prefs <span style='color:#111;'> 57B </span>","children":null,"spread":false}],"spread":true},{"title":"test.xlsx <span style='color:#111;'> 8.17KB </span>","children":null,"spread":false},{"title":".classpath <span style='color:#111;'> 737B </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"com","children":[{"title":"askingdata","children":[{"title":"excel","children":[{"title":"util","children":[{"title":"Main2.class <span style='color:#111;'> 5.96KB </span>","children":null,"spread":false},{"title":"Main.class <span style='color:#111;'> 5.70KB </span>","children":null,"spread":false},{"title":"Main2$1.class <span style='color:#111;'> 1.38KB </span>","children":null,"spread":false},{"title":"Main$1.class <span style='color:#111;'> 2.30KB </span>","children":null,"spread":false},{"title":"RowDataProcesser.class <span style='color:#111;'> 248B </span>","children":null,"spread":false},{"title":"ExcelUtil.class <span style='color:#111;'> 5.11KB </span>","children":null,"spread":false},{"title":"Xlsx2ListData.class <span style='color:#111;'> 4.84KB </span>","children":null,"spread":false},{"title":"Xlsx2ListData$SheetToList.class <span style='color:#111;'> 3.50KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"test","children":[{"title":"Hufan.class <span style='color:#111;'> 2.59KB </span>","children":null,"spread":false},{"title":"Main.class <span style='color:#111;'> 675B </span>","children":null,"spread":false},{"title":"Main$1.class <span style='color:#111;'> 1.45KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}]

评论信息

  • 王天天 :
    一次性读取一个sheet,有些虎吧!!!
    2020-09-09
  • linuxcsd :
    厉害了大神!
    2019-06-28
  • KogRow :
    大佬!厉害!给跪了
    2019-03-24

免责申明

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