java poi excel读写demo

上传者: zgsnow | 上传时间: 2021-06-23 11:36:32 | 文件大小: 12.12MB | 文件类型: RAR
java poi excel操作demo 支持xls和xlsx两个格式的excel文件的读写操作。读取模式包含用户模式和事件驱动模式 ,事件驱动模式能够支持大数据量的读操作,写操作xlsx使用sxssf方式支持大数据量的写入操作。 demo 基于poi 3.10.1版本 jdk为1.7 可直接导入ecplise 测试类为TestSrv.java。 压缩包附导入模版。修改TestSrv.java main函数内的导入文件路径即可直接测试使用

文件下载

资源详情

[{"title":"( 44 个子文件 12.12MB ) java poi excel读写demo","children":[{"title":"poi读写excel","children":[{"title":"测试导入.xlsx <span style='color:#111;'> 10.50KB </span>","children":null,"spread":false},{"title":"PoiExcelTest","children":[{"title":"src","children":[{"title":"poi-config.xml <span style='color:#111;'> 972B </span>","children":null,"spread":false},{"title":"util","children":[{"title":"ComUtil.java <span style='color:#111;'> 5.79KB </span>","children":null,"spread":false}],"spread":true},{"title":"poi","children":[{"title":"PoiExport.java <span style='color:#111;'> 10.62KB </span>","children":null,"spread":false},{"title":"MyCell.java <span style='color:#111;'> 2.55KB </span>","children":null,"spread":false},{"title":"PoiExcel.java <span style='color:#111;'> 25.09KB </span>","children":null,"spread":false},{"title":"IRowReader.java <span style='color:#111;'> 462B </span>","children":null,"spread":false},{"title":"PoiConfigParse.java <span style='color:#111;'> 3.43KB </span>","children":null,"spread":false},{"title":"MySheet.java <span style='color:#111;'> 1.73KB </span>","children":null,"spread":false}],"spread":true},{"title":"log4j.xml <span style='color:#111;'> 828B </span>","children":null,"spread":false},{"title":"test","children":[{"title":"TestRead.java <span style='color:#111;'> 3.89KB </span>","children":null,"spread":false},{"title":"TestSrv.java <span style='color:#111;'> 1.71KB </span>","children":null,"spread":false},{"title":"TestExport.java <span style='color:#111;'> 824B </span>","children":null,"spread":false},{"title":"TestVo.java <span style='color:#111;'> 304B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"bin","children":[{"title":"poi-config.xml <span style='color:#111;'> 972B </span>","children":null,"spread":false},{"title":"util","children":[{"title":"ComUtil.class <span style='color:#111;'> 5.02KB </span>","children":null,"spread":false}],"spread":true},{"title":"poi","children":[{"title":"MyCell.class <span style='color:#111;'> 3.18KB </span>","children":null,"spread":false},{"title":"PoiExcel.class <span style='color:#111;'> 21.53KB </span>","children":null,"spread":false},{"title":"MySheet.class <span style='color:#111;'> 2.21KB </span>","children":null,"spread":false},{"title":"PoiExcel$XSSFDataType.class <span style='color:#111;'> 1.25KB </span>","children":null,"spread":false},{"title":"IRowReader.class <span style='color:#111;'> 218B </span>","children":null,"spread":false},{"title":"PoiConfigParse.class <span style='color:#111;'> 5.04KB </span>","children":null,"spread":false},{"title":"PoiExport.class <span style='color:#111;'> 10.96KB </span>","children":null,"spread":false}],"spread":true},{"title":"log4j.xml <span style='color:#111;'> 828B </span>","children":null,"spread":false},{"title":"test","children":[{"title":"TestRead.class <span style='color:#111;'> 5.25KB </span>","children":null,"spread":false},{"title":"TestSrv.class <span style='color:#111;'> 2.85KB </span>","children":null,"spread":false},{"title":"TestVo.class <span style='color:#111;'> 682B </span>","children":null,"spread":false},{"title":"TestExport.class <span style='color:#111;'> 1.09KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":".classpath <span style='color:#111;'> 1.13KB </span>","children":null,"spread":false},{"title":".project <span style='color:#111;'> 388B </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"dom4j-1.6.1.jar <span style='color:#111;'> 306.54KB </span>","children":null,"spread":false},{"title":"xmlbeans-2.6.0.jar <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"stax-api-1.0.1.jar <span style='color:#111;'> 25.89KB </span>","children":null,"spread":false},{"title":"commons-logging-1.1.3.jar <span style='color:#111;'> 60.60KB </span>","children":null,"spread":false},{"title":"xml-apis.jar <span style='color:#111;'> 215.37KB </span>","children":null,"spread":false},{"title":"commons-net-3.3.jar <span style='color:#111;'> 274.40KB </span>","children":null,"spread":false},{"title":"log4j-1.2.17.jar <span style='color:#111;'> 478.40KB </span>","children":null,"spread":false},{"title":"poi-scratchpad-3.10.1-20140818.jar <span style='color:#111;'> 1.18MB </span>","children":null,"spread":false},{"title":"xercesImpl.jar <span style='color:#111;'> 1.30MB </span>","children":null,"spread":false},{"title":"poi-examples-3.10.1-20140818.jar <span style='color:#111;'> 305.44KB </span>","children":null,"spread":false},{"title":"poi-ooxml-3.10.1-20140818.jar <span style='color:#111;'> 1011.15KB </span>","children":null,"spread":false},{"title":"poi-ooxml-schemas-3.10.1-20140818.jar <span style='color:#111;'> 4.72MB </span>","children":null,"spread":false},{"title":"poi-excelant-3.10.1-20140818.jar <span style='color:#111;'> 29.82KB </span>","children":null,"spread":false},{"title":"poi-3.10.1-20140818.jar <span style='color:#111;'> 1.86MB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true}]

评论信息

  • u013326886 :
    不错的DEMO
    2019-04-02
  • lk1055 :
    很好,解了燃眉之急
    2018-07-31
  • hhb1san14 :
    还可以,但是有一个问题,当Excel空列的时候,程序并不会读取到,这样会导致rowlist不一样大、并且会串行,当这个程序自己要结合反射用的时候,根本用不上
    2018-01-31
  • sinat_27347355 :
    很不错,值得学习
    2017-10-28
  • qq_31280521 :
    刚下下来,,试一试呢
    2017-10-23

免责申明

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