package?cn.nami;

import?java.io.File;
import?java.io.FileInputStream;
import?java.io.InputStream;
import?java.util.List;
import?java.util.Map;

import?cn.zhaoql.excelexport.module.ExcelModule;
import?cn.zhaoql.excelexport.userinterface.ExcelExpUtil;
import?cn.zhaoql.excelimport.bean.ExcelData;
import?cn.zhaoql.excelimport.userinterface.ExcelImportUtil;
import?cn.zhaoql.excelimport.util.ExcelDataUtil;

public?class?Test
{
	public?static?void?main（String[]?args）?throws?Exception
	{
		//?讀取excel導入的數據
		ExcelData?data?=?testExcelImp（）;
		//?將數據通過excel模板輸出
		testExcelExp（ExcelDataUtil.changeExcelDataToSimple（data）.getRepeatData（））;
	}
	
	/**
	?*?測試excel導入
	?*/
	private?static?ExcelData?testExcelImp（）?throws?Exception
	{
		String?xmlFile?=?“excel_desc.xml“;
		InputStream?importExcelStream?=?new?FileInputStream（“info_CRM.xls“）;
		ExcelData?data?=?ExcelImportUtil.readExcel（xmlFile?importExcelStream）;
		System.out.println（data）;
		return?data;
	}
	
	/**
	?*?測試excel導出
	?*/
	private?static?void?testExcelExp（List>?sheet_data_all）?throws?Exception
	{
		ExcelModule?excelModule?=?new?ExcelModule（sheet_data_all）;
		//?導出excel時使用的模板：exp_templete.xls
		String?templeteFile?=?new?File（System.getProperty（“user.dir“）?“exp_templete.xls“）.getAbsolutePath（）;
		System.out.println（templeteFile）;
		//?導出的文件名：exp_out.xls
		ExcelExpUtil.expExcel（excelModule?templeteFile?“exp_out.xls“）;
	}
}

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

?????文件??????19968??2010-09-24?20:29??exp_templete.xls

?????文件??????19968??2010-09-24?20:29??info_CRM.xls

?????文件???????2422??2010-09-24?20:32??bin\cn\nami\Test.class

?????文件???????1056??2010-09-24?20:29??bin\excel_desc.xml

?????文件??????61305??2010-09-24?20:26??lib\ExcelUtil.jar

?????文件?????153253??2010-09-24?20:22??lib\jdom.jar

?????文件????1516415??2010-09-24?20:22??lib\poi-3.5-FINAL-20090928.jar

?????文件???????1536??2010-09-24?20:29??src\cn\nami\Test.java

?????文件???????1056??2010-09-24?20:29??src\excel_desc.xml

?????文件????????408??2010-09-24?20:26??.classpath

?????文件????????389??2010-09-24?20:32??.project

?????目錄??????????0??2010-09-24?20:32??bin\cn\nami

?????目錄??????????0??2010-09-24?20:27??src\cn\nami

?????目錄??????????0??2010-09-24?20:32??bin\cn

?????目錄??????????0??2010-09-24?20:27??src\cn

?????目錄??????????0??2010-09-24?20:32??bin

?????目錄??????????0??2010-09-24?20:26??lib

?????目錄??????????0??2010-09-24?20:29??src

?????文件?????????55??2018-01-02?11:27??readme.txt

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

??????????????1777831????????????????????19