jxls导入excel

我们在开发中经常用jxls实现导出功能，殊不知jxls也有导入功能，下面来介绍下如何使用jxls导入excel。

首先在maven的pom中添加相关依赖，如下：

 

                 <dependency>
			<groupId>net.sf.jxls</groupId>
			<artifactId>jxls-core</artifactId>
			<version>1.0.6</version>
		</dependency>
		<dependency>
		    <groupId>net.sf.jxls</groupId>
		    <artifactId>jxls-reader</artifactId>
		    <version>1.0.6</version>
		</dependency>

 

 

然后需要配置导入模板（即字段映射关系），如下：

<?xml version="1.0" encoding="UTF-8"?>
<workbook>
	<worksheet name="新增局数据">
		<section startRow="1" endRow="2" />
		<loop startRow="3" endRow="3" items="tcs" var="tc" varType="com.aspire.train.bdc.demo.entity.TcPartner">
			<section startRow="3" endRow="3">
				<mapping row="3" col="0">tc.operType</mapping>
				<mapping row="3" col="1">tc.partnerId</mapping>
				<mapping row="3" col="2">tc.partnerName</mapping>
				<mapping row="3" col="3">tc.description</mapping>
				<mapping row="3" col="4">tc.validProvince</mapping>
				<mapping row="3" col="5">tc.validDate</mapping>
				<mapping row="3" col="6">tc.expireDate</mapping>
			</section>
			<loopbreakcondition>
				<rowcheck offset="0">
					<cellcheck offset="0"></cellcheck>
				</rowcheck>
			</loopbreakcondition>
		</loop>
	</worksheet>
</workbook> 

 

 

相关说明可以查看官网http://jxls.sourceforge.net/reference/reader.html

 

其次，是制作导入模板，如下：

 

下面是实现的java代码块，如下：

               String xmlConfig = ConfigurationHelper
				.getFullFileName("com/aspire/train/bdc/demo/template/TcPartner.xml");
		XLSReader mainReader;
		try {
			InputStream inputXML = new BufferedInputStream(new FileInputStream(xmlConfig));
			mainReader = ReaderBuilder.buildFromXML(inputXML);
			InputStream inputXLS = new BufferedInputStream(file.getInputStream());
			TcPartner tc = new TcPartner();
			List<TcPartner> tcs = new ArrayList<TcPartner>();
			Map<String,Object> beans = new HashMap<String,Object>();
			beans.put("tc", tc);
			beans.put("tcs", tcs);
			mainReader.read(inputXLS, beans);
			System.out.println(beans);
		} catch (IOException e) {
			e.printStackTrace();
		} catch (Exception e) {
			e.printStackTrace();
		}