Java poi导入导出EXCEL工具类(兼容各版本)

上传者: xsl1993 | 上传时间: 2021-06-28 17:22:25 | 文件大小: 69KB | 文件类型: ZIP
概述:Java poi导入导出EXCEL工具类(兼容各版本) 一、功能说明 允许同时导入或导出多个sheet,同一sheet可同时存在多个数据块,按数据块划分处理数据。 二、配置文件示例及详细说明 1、导入xml配置示例如下(见src/main/resources/import-config.xml) 2、导出xml配置示例如下(见src/main/resources/export-config.xml) 三、调用示例 1、导入:src/test/java/com/reports/test/ExcelImportReportTest.java 2、导出:src/test/java/com/reports/test/ExcelExportReportTest.java 四、测试用例及数据 路径src/test/resources/

文件下载

资源详情

[{"title":"( 47 个子文件 69KB ) Java poi导入导出EXCEL工具类(兼容各版本)","children":[{"title":"ExcelReportHandle-master","children":[{"title":"notes.txt <span style='color:#111;'> 75B </span>","children":null,"spread":false},{"title":".gitignore <span style='color:#111;'> 278B </span>","children":null,"spread":false},{"title":"src","children":[{"title":"main","children":[{"title":"resources","children":[{"title":"export-config.xml <span style='color:#111;'> 3.15KB </span>","children":null,"spread":false},{"title":"import-config.xml <span style='color:#111;'> 3.26KB </span>","children":null,"spread":false}],"spread":true},{"title":"java","children":[{"title":"com","children":[{"title":"reports","children":[{"title":"ExcelReportHandleApplication.java <span style='color:#111;'> 329B </span>","children":null,"spread":false},{"title":"exports","children":[{"title":"servicehandle","children":[{"title":"ReportMakerFactory.java <span style='color:#111;'> 655B </span>","children":null,"spread":false},{"title":"CsvReportMaker.java <span style='color:#111;'> 3.50KB </span>","children":null,"spread":false},{"title":"XlsxReportMaker.java <span style='color:#111;'> 9.13KB </span>","children":null,"spread":false},{"title":"IReportMaker.java <span style='color:#111;'> 830B </span>","children":null,"spread":false},{"title":"ReportMakeService.java <span style='color:#111;'> 1.50KB </span>","children":null,"spread":false}],"spread":true},{"title":"xmlhandle","children":[{"title":"ReadReportsXml.java <span style='color:#111;'> 681B </span>","children":null,"spread":false},{"title":"Rowx.java <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"Sheetx.java <span style='color:#111;'> 899B </span>","children":null,"spread":false},{"title":"Sheets.java <span style='color:#111;'> 474B </span>","children":null,"spread":false},{"title":"ReportsContext.java <span style='color:#111;'> 1.42KB </span>","children":null,"spread":false},{"title":"Report.java <span style='color:#111;'> 1.11KB </span>","children":null,"spread":false},{"title":"Columnx.java <span style='color:#111;'> 1.12KB </span>","children":null,"spread":false},{"title":"Reports.java <span style='color:#111;'> 587B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"common","children":[{"title":"ImportUtil.java <span style='color:#111;'> 11.54KB </span>","children":null,"spread":false},{"title":"DateUtil.java <span style='color:#111;'> 3.14KB </span>","children":null,"spread":false},{"title":"Constants.java <span style='color:#111;'> 2.31KB </span>","children":null,"spread":false},{"title":"ExportUtil.java <span style='color:#111;'> 3.11KB </span>","children":null,"spread":false}],"spread":true},{"title":"imports","children":[{"title":"servicehandle","children":[{"title":"ImportReaderService.java <span style='color:#111;'> 911B </span>","children":null,"spread":false},{"title":"ImportReader.java <span style='color:#111;'> 434B </span>","children":null,"spread":false},{"title":"ExcelImportReader.java <span style='color:#111;'> 4.10KB </span>","children":null,"spread":false},{"title":"ImportReaderFactory.java <span style='color:#111;'> 485B </span>","children":null,"spread":false}],"spread":true},{"title":"xmlhandle","children":[{"title":"Imports.java <span style='color:#111;'> 585B </span>","children":null,"spread":false},{"title":"Rowx.java <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"ImportsContext.java <span style='color:#111;'> 1.42KB </span>","children":null,"spread":false},{"title":"Sheetx.java <span style='color:#111;'> 898B </span>","children":null,"spread":false},{"title":"Sheets.java <span style='color:#111;'> 474B </span>","children":null,"spread":false},{"title":"ReadImportsXml.java <span style='color:#111;'> 680B </span>","children":null,"spread":false},{"title":"Import.java <span style='color:#111;'> 955B </span>","children":null,"spread":false},{"title":"Columnx.java <span style='color:#111;'> 1.09KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"test","children":[{"title":"resources","children":[{"title":"testdata","children":[{"title":"部门月度销售统计_20180808.xls <span style='color:#111;'> 25.50KB </span>","children":null,"spread":false},{"title":"部门月度销售统计_20180808.xlsx <span style='color:#111;'> 11.03KB </span>","children":null,"spread":false}],"spread":true},{"title":"config","children":[{"title":"export-config.xml <span style='color:#111;'> 3.15KB </span>","children":null,"spread":false},{"title":"import-config.xml <span style='color:#111;'> 3.26KB </span>","children":null,"spread":false}],"spread":true},{"title":"template","children":[{"title":"部门月度销售统计_yyyyMMdd.xlsx <span style='color:#111;'> 10.11KB </span>","children":null,"spread":false},{"title":"部门月度销售统计_yyyyMMdd.xls <span style='color:#111;'> 24.00KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"java","children":[{"title":"com","children":[{"title":"reports","children":[{"title":"entity","children":[{"title":"SalesDetailEntity.java <span style='color:#111;'> 965B </span>","children":null,"spread":false},{"title":"SalaryDetailEntity.java <span style='color:#111;'> 1.10KB </span>","children":null,"spread":false},{"title":"SaleStatisticsEntity.java <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false}],"spread":true},{"title":"test","children":[{"title":"ExcelExportReportTest.java <span style='color:#111;'> 5.75KB </span>","children":null,"spread":false},{"title":"ExcelImportReportTest.java <span style='color:#111;'> 4.57KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"pom.xml <span style='color:#111;'> 2.23KB </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 662B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

  • cn_clyyu :
    太贵了,不太好用
    2020-07-27
  • qq_36621433 :
    不好使,除了贵点没啥用
    2019-12-05

免责申明

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