实现一个配置简单功能强大的excel工具类搞定大多数导入导出

上传者: lk_blog | 上传时间: 2019-12-21 20:11:53 | 文件大小: 1.96MB | 文件类型: rar
实现一个配置简单功能强大的excel工具类搞定大多数导入导出. http://blog.csdn.net/lk_blog/article/details/8007777 http://blog.csdn.net/lk_blog/article/details/8007837 对于J2EE项目导入导出Excel是最普通和实用功能,本工具类使用步骤简单,功能强大,只需要对实体类进行简单的注解就能实现导入导出功能,导入导出操作的都是实体对象. 看看这个类都有哪些功能吧: * 1.实体属性配置了注解就能导出到excel中,每个属性都对应一列. * 2.列名称可以通过注解配置. * 3.导出到哪一列可以通过注解配置. * 4.鼠标移动到该列时提示信息可以通过注解配置. * 5.用注解设置只能下拉选择不能随意填写功能. * 6.用注解设置是否只导出标题而不导出内容,这在导出内容作为模板以供用户填写时比较实用. 使用步骤: 1.写一个实体类 2.为实体类设置注解配置. 3.实例化一个ExcelUtil对象,调用exportExcel或importExcel方法.

文件下载

资源详情

[{"title":"( 29 个子文件 1.96MB ) 实现一个配置简单功能强大的excel工具类搞定大多数导入导出","children":[{"title":"ExcelDemo","children":[{"title":"gc.log <span style='color:#111;'> 287B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"com","children":[{"title":"tgb","children":[{"title":"lk","children":[{"title":"test03","children":[{"title":"ExportTest03.java <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false},{"title":"ImportTest03.java <span style='color:#111;'> 606B </span>","children":null,"spread":false},{"title":"StudentVO.java <span style='color:#111;'> 1.29KB </span>","children":null,"spread":false}],"spread":true},{"title":"ExportTest01.java <span style='color:#111;'> 3.24KB </span>","children":null,"spread":false},{"title":"util","children":[{"title":"ExcelUtil.java <span style='color:#111;'> 10.16KB </span>","children":null,"spread":false},{"title":"ExcelVOAttribute.java <span style='color:#111;'> 766B </span>","children":null,"spread":false}],"spread":true},{"title":"test04","children":[{"title":"ExportTest04.java <span style='color:#111;'> 2.46KB </span>","children":null,"spread":false},{"title":"Student.java <span style='color:#111;'> 1.10KB </span>","children":null,"spread":false},{"title":"StudentVO.java <span style='color:#111;'> 1.37KB </span>","children":null,"spread":false},{"title":"ImportTest04.java <span style='color:#111;'> 2.35KB </span>","children":null,"spread":false}],"spread":true},{"title":"ExportTest02.java <span style='color:#111;'> 3.29KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"bin","children":[{"title":"com","children":[{"title":"tgb","children":[{"title":"lk","children":[{"title":"ExportTest01.class <span style='color:#111;'> 3.06KB </span>","children":null,"spread":false},{"title":"test03","children":[{"title":"StudentVO.class <span style='color:#111;'> 2.01KB </span>","children":null,"spread":false},{"title":"ImportTest03.class <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"ExportTest03.class <span style='color:#111;'> 1.92KB </span>","children":null,"spread":false}],"spread":true},{"title":"ExportTest02.class <span style='color:#111;'> 4.08KB </span>","children":null,"spread":false},{"title":"util","children":[{"title":"ExcelUtil.class <span style='color:#111;'> 9.86KB </span>","children":null,"spread":false},{"title":"ExcelVOAttribute.class <span style='color:#111;'> 592B </span>","children":null,"spread":false}],"spread":true},{"title":"test04","children":[{"title":"StudentVO.class <span style='color:#111;'> 2.00KB </span>","children":null,"spread":false},{"title":"ExportTest04.class <span style='color:#111;'> 3.22KB </span>","children":null,"spread":false},{"title":"ImportTest04.class <span style='color:#111;'> 3.04KB </span>","children":null,"spread":false},{"title":"Student.class <span style='color:#111;'> 1.96KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":".classpath <span style='color:#111;'> 424B </span>","children":null,"spread":false},{"title":".settings","children":[{"title":"org.eclipse.core.resources.prefs <span style='color:#111;'> 112B </span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 629B </span>","children":null,"spread":false}],"spread":true},{"title":".project <span style='color:#111;'> 385B </span>","children":null,"spread":false},{"title":"lib","children":[{"title":"jxl-2.6.jar <span style='color:#111;'> 708.73KB </span>","children":null,"spread":false},{"title":"poi-3.5-FINAL-20090928.jar <span style='color:#111;'> 1.45MB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]

评论信息

  • sclxzy :
    相当好用的工具,学习了
    2021-03-15
  • lrtwilly :
    还不错,就是太贵了。。
    2019-10-30
  • qq_28960431 :
    谢谢分享值得学习
    2018-09-02
  • qq_33512863 :
    还没具体尝试
    2018-08-13
  • u014627231 :
    可以的,收藏了,使用比较方便
    2018-06-19

免责申明

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