package?com.jo.work.attachment.action;
import?java.io.File;
import?java.io.IOException;
import?java.util.HashMap;
import?java.util.linkedList;
import?java.util.List;
import?java.util.Map;

import?net.sf.jxls.exception.ParsePropertyException;
import?net.sf.jxls.transformer.XLSTransformer;

import?org.apache.poi.openxml4j.exceptions.InvalidFormatException;

public?class?LoadExcelFileAction?{
	private?static?final?long?serialVersionUID?=?1L;
	
	public?static?void?main（String[]?args）{
		
????????Mapject>?beanParams?=?new?HashMapject>（）;		
		Listject>>?params?=?new?linkedListject>>（）;		
		Mapject>?param?=?new?HashMapject>（）;		
		param.put（“quotaId“?“PX-1“）;		
		param.put（“quotaName“?“混凝土桿組立/整根式/13m以內“）;		
		param.put（“quotaUnit“?“基“）;
		param.put（“num“?2）;
		param.put（“material“?“水泥桿“）;
		param.put（“basePrice“?200.2）;
		param.put（“manMadeFee“?90.5）;
		params.add（param）;
		
		Mapject>?param1?=?new?HashMapject>（）;		
		param1.put（“quotaId“?“PX-2“）;		
		param1.put（“quotaName“?“混凝土桿組立/整根式/13m以上“）;		
		param1.put（“quotaUnit“?“基“）;
		param1.put（“num“?4）;
		param1.put（“material“?“水泥桿“）;
		param1.put（“basePrice“?250.2）;
		param1.put（“manMadeFee“?120.5）;	
		params.add（param1）;
		
		Mapject>?param2?=?new?HashMapject>（）;		
		param2.put（“quotaId“?“PX-3“）;		
		param2.put（“quotaName“?“鐵、木橫擔?單根“）;		
		param2.put（“quotaUnit“?“組“）;
		param2.put（“num“?24）;
		param2.put（“material“?“橫擔“）;
		param2.put（“basePrice“?50）;
		param2.put（“manMadeFee“?20.5）;	
		params.add（param2）;
		beanParams.put（“params“?params）;
		exportExcel（beanParams）;
	}

	public?static?void?exportExcel（Mapject>?beanParams）{		
		//讀取模板
		String?srcFilePath?=?“D:/file/template.xls“;
		//輸出文件?
		String?destFilePath?=?“D:/file“;
		
		new?File（destFilePath）.mkdirs（）;			
		XLSTransformer?transformer?=?new?XLSTransformer（）;		
		try?{			
			transformer.transformXLS（srcFilePath?beanParamsdestFilePath+“/text2.xls“）;						
		}?catch?（ParsePropertyException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（InvalidFormatException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（IOException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			
			
		}
		
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????154330??2015-09-02?16:06??java利用jxls操作excel模板文件\jxls-core-1.0.jar

?????文件??????34238??2015-09-02?16:06??java利用jxls操作excel模板文件\jxls-reader-1.0.jar

?????文件???????2539??2015-09-02?17:28??java利用jxls操作excel模板文件\LoadExcelFileAction.java

?????文件??????30720??2015-09-06?11:07??java利用jxls操作excel模板文件\template.xls

?????目錄??????????0??2015-09-06?11:14??java利用jxls操作excel模板文件

-----------?---------??----------?-----??----

???????????????221827????????????????????5