支持多Sheet的Excle批量导入工具

super_robin

浏览: 54113 次
性别:
来自: 河南郑州

最近访客更多访客>>

leisure0422

joke01

kuangzhiqin

xuyexw

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

Excel操纵

Excel XML Java SUN

等不忙了做一个支持多Sheet的Excle批量导入工具，初步设想配置文件如下：



<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<root>
    <comment>Excel多Sheet批量导入工具配置文件</comment>
	<dataSource description=""
	            dsDriverClass=""
				dsUrl=""
				dsUserName=""
				dsPassword=""/>
	     
	<excelFile name = "c:/text.xls" >
	     <sheet sheetIndex="0" tableName = "table0">
		    <colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
		 </sheet>

		 <sheet index="1" tableName = "table1">
		    <colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
		 </sheet>

		 <sheet index="2" tableName = "table2">
		    <colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
		 </sheet>

		 <sheet index="3" tableName = "table3">
		    <colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
			<colume sheetColumeIndex="" dbColumeName="" dbIsNullAble="true"/> 
		 </sheet>
	</excelFile>
</root>

分享到：