package?com.cn;
import?org.apache.poi.hssf.usermodel.*;
import?com.cn.JobsBean;
import?java.util.List;
import?java.io.*;

public?class?ExcelUtil?{
	public?ExcelUtil（）{
		
	};
	//?導(dǎo)出方法
	public?void?importExcel（List?joblist?String?filePath）{
	????FileOutputStream?fileOut=null;
		try?{
			fileOut?=?new?FileOutputStream（filePath）;
		}?catch?（FileNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		HSSFWorkbook?workbook=new?HSSFWorkbook（）;		
		HSSFSheet?sheet1=workbook.createSheet（“sheet1“）;
		HSSFRow?row=sheet1.createRow（（short）0）;
		HSSFCell?cell=row.createCell（（short）0）;
		row.createCell（（short）0）.setCellValue（“員工號(hào)“）;
		row.createCell（（short）1）.setCellValue（“員工職位“）;
		row.createCell（2）.setCellValue（“最低薪水“）;
		row.createCell（3）.setCellValue（“最高薪水“）;
		
		for（int?i=0;i			??row=sheet1.createRow（（short）i+1）;
			??cell=row.createCell（（short）0）;
			??row.createCell（（short）0）.setCellValue（joblist.get（i）.getJOB_ID（））;
			??row.createCell（（short）1）.setCellValue（joblist.get（i）.getJOB_title（））;
			??row.createCell（（short）2）.setCellValue（joblist.get（i）.getMIN_SALARY（））;
			??row.createCell（（short）3）.setCellValue（joblist.get（i）.getMAX_SALARY（））;			
		}
		?try?{
			workbook.write（fileOut）;
		}?catch?（IOException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
	};
	
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-09-01?08:39??Importnew\
?????文件?????????529??2013-09-01?08:39??Importnew\.classpath
?????目錄???????????0??2013-09-01?08:39??Importnew\.myeclipse\
?????文件?????????300??2013-09-01?08:39??Importnew\.mymetadata
?????文件????????1752??2013-09-01?08:42??Importnew\.project
?????目錄???????????0??2013-09-01?08:41??Importnew\.settings\
?????文件?????????500??2013-09-01?08:39??Importnew\.settings\.jsdtscope
?????文件?????????108??2013-09-01?09:07??Importnew\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2013-09-01?08:39??Importnew\.settings\org.eclipse.jdt.core.prefs
?????文件?????????465??2013-09-01?08:39??Importnew\.settings\org.eclipse.wst.common.component
?????文件?????????252??2013-09-01?08:39??Importnew\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2013-09-01?08:39??Importnew\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-09-01?08:39??Importnew\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2013-09-01?08:39??Importnew\src\
?????目錄???????????0??2013-09-01?08:39??Importnew\src\com\
?????目錄???????????0??2013-09-01?09:43??Importnew\src\com\cn\
?????文件????????1434??2013-09-01?09:53??Importnew\src\com\cn\ExcelUtil.java
?????文件????????1985??2013-09-01?14:26??Importnew\src\com\cn\JdbcBean.java
?????文件????????1157??2013-09-01?09:19??Importnew\src\com\cn\jdbcthin.java
?????文件?????????735??2013-09-01?07:45??Importnew\src\com\cn\JobsBean.java
?????目錄???????????0??2013-09-01?14:31??Importnew\WebRoot\
?????文件????????3862??2013-09-01?09:36??Importnew\WebRoot\exportexl.jsp
?????文件????????2201??2013-09-01?09:55??Importnew\WebRoot\exportexl_new.jsp
?????文件????????1103??2013-09-01?14:27??Importnew\WebRoot\index.jsp
?????目錄???????????0??2013-09-01?08:39??Importnew\WebRoot\meta-INF\
?????文件??????????36??2013-09-01?08:39??Importnew\WebRoot\meta-INF\MANIFEST.MF
?????文件?????????347??2013-09-01?14:31??Importnew\WebRoot\readme.txt
?????目錄???????????0??2013-09-01?08:39??Importnew\WebRoot\WEB-INF\
?????目錄???????????0??2013-09-01?08:40??Importnew\WebRoot\WEB-INF\classes\
?????目錄???????????0??2013-09-01?08:40??Importnew\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2013-09-01?09:43??Importnew\WebRoot\WEB-INF\classes\com\cn\
............此處省略8個(gè)文件信息