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

最新推荐文章于 2022-08-10 15:57:20 发布

loveluomeng

最新推荐文章于 2022-08-10 15:57:20 发布

阅读量193

点赞数

分类专栏： Excel操纵文章标签： Excel XML Java SUN

本文链接：https://blog.csdn.net/loveluomeng/article/details/83707334

版权

Excel操纵专栏收录该内容

2 篇文章 0 订阅

订阅专栏

等不忙了做一个支持多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>