文件名称:Excel解析
- 所属分类:
- JSP源码/Java
- 资源属性:
- 上传时间:
- 2018-04-04
- 文件大小:
- 966kb
- 下载次数:
- 0次
- 提 供 者:
- wan****
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
程序刚刚整理出来,还有些粗糙,也希望各位朋友们有更好的方法能够交流、改进。
说明: 本程序是非常简单的excel解析功能;可用于解析excel数据入库。
程序依赖jxl.jar,commons-lang-2.4.jar,commons-logging.jar
上述三个依赖包已经封装在本包中。如需最新的jar包可以将其替换。
excel模板配置如下:
第一行是map需使用的key;
第二行是方便数据整理时的备注;
第三行及以后是对应字段的值
Excel模板可参照包内importTemplate.xls;使用方法请参照以下代码。(Procedures have just been sorted out, but also a bit rough, but also hope that friends have a better way to communicate, improve.Note: this procedure is very simple excel parsing function; can be used to parse excel data library.The program relies on jxl.jar commons-lang-2.4.jarn commons-logging.jarThe above three dependency packages are encapsulated in this package.If you need the latest jar package, you can replace it.The excel template is configured as follows:The first line is the key that map needs to use;The second line is the remarks when it is convenient to organize the data;The third line and thereafter are the values of the corresponding fieldsThe Excel template can be found in importTemplate.xlswithin the package; see the following code for use.)
说明: 本程序是非常简单的excel解析功能;可用于解析excel数据入库。
程序依赖jxl.jar,commons-lang-2.4.jar,commons-logging.jar
上述三个依赖包已经封装在本包中。如需最新的jar包可以将其替换。
excel模板配置如下:
第一行是map需使用的key;
第二行是方便数据整理时的备注;
第三行及以后是对应字段的值
Excel模板可参照包内importTemplate.xls;使用方法请参照以下代码。(Procedures have just been sorted out, but also a bit rough, but also hope that friends have a better way to communicate, improve.Note: this procedure is very simple excel parsing function; can be used to parse excel data library.The program relies on jxl.jar commons-lang-2.4.jarn commons-logging.jarThe above three dependency packages are encapsulated in this package.If you need the latest jar package, you can replace it.The excel template is configured as follows:The first line is the key that map needs to use;The second line is the remarks when it is convenient to organize the data;The third line and thereafter are the values of the corresponding fieldsThe Excel template can be found in importTemplate.xlswithin the package; see the following code for use.)
(系统自动生成,下载前可以参看下载内容)
下载文件列表
文件名 | 大小 | 更新时间 |
---|---|---|
reademe.txt | 1093 | 2013-12-24 |
importTemplate.xls | 23552 | 2013-12-24 |
lib\commons-logging.jar | 60841 | 2013-09-26 |
lib\commons-lang-2.4.jar | 261809 | 2013-09-26 |
lib\jxl.jar | 725356 | 2013-09-26 |
META-INF | 0 | 2013-12-24 |
lib | 0 | 2013-12-24 |
com | 0 | |
com\util | 0 | 2013-12-24 |
META-INF\MANIFEST.MF | 25 | 2013-12-24 |
com\util\MapObject.class | 1159 | 2013-12-24 |
com\util\Dto.class | 828 | 2013-12-24 |
com\util\ExcelFiller.class | 8363 | 2013-12-24 |
com\util\ExcelImportTemplate.class | 4560 | 2013-12-24 |
com\util\ExcelData.class | 1329 | 2013-12-24 |
com\util\ExcelTemplate.class | 4092 | 2013-12-24 |