package?poi.excel;

import?java.io.FileNotFoundException;
import?java.io.IOException;
import?java.io.InputStream;

import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.ss.usermodel.Row;
import?org.apache.poi.ss.usermodel.Sheet;
import?org.apache.poi.ss.usermodel.Workbook;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;
import?org.apache.struts.action.ActionForm;
import?org.apache.struts.action.ActionForward;
import?org.apache.struts.action.ActionMapping;
import?org.apache.struts.actions.DispatchAction;

public?class?ExcelPoiAction?extends?DispatchAction{

	
	public?ActionForward?upload（ActionMapping?mapping?ActionForm?actionForm
			HttpServletRequest?request?HttpServletResponse?response）?throws?Exception?{
		ExcelPoizForm?form?=（ExcelPoizForm）actionForm;
		try?{
			//提示消息
			String?message=““;
			Workbook?workbook?=this.createWorkBook（form.getFile（）.getInputStream（）form.getFile（）.getFileName（））;
			//讀取第一個sheet
			Sheet?sheet?=?workbook.getSheetAt（0）;
			//讀取數據從第二行開始，第一列崗位名稱，第二列崗位描述第三列崗位編號
			for（int?i=1;?i<=sheet.getLastRowNum（）;?i++）{?
				Row?row?=?sheet.getRow（i）;??
				System.out.println（row.getCell（4））;
				
			}
			request.setAttribute（“msgresult“?“上傳完成！“+message）;
		}?catch?（FileNotFoundException?e）?{
			request.setAttribute（“msgresult“?“導入失敗！“）;
			System.out.println（“導入失敗“）;	
		}?catch?（IOException?e）?{
			request.setAttribute（“msgresult“?“導入失敗！“）;
			System.out.println（“導入失敗“）;
		}catch（Exception?e）{
			request.setAttribute（“msgresult“?“導入失敗！“）;
			System.out.println（“導入失敗“）;
		}
		finally{
			return?mapping.findForward（“success“）;
		}
		
	}

	
	/*??*?判斷是xls文件還是xlsx文件??*/
	public?Workbook?createWorkBook（InputStream?isString?fileName）?throws?IOException{????
		if（fileName.toLowerCase（）.endsWith（“xls“））{?
			return?new?HSSFWorkbook（is）;??
			}?
		if（fileName.toLowerCase（）.endsWith（“xlsx“））{??
			return?new?XSSFWorkbook（is）;?
			}????
		return?null;?
		}
	
}

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

?????文件???????2177??2013-12-26?21:11??struts1?poi?Excel批量導入支持xls和xlsx-源碼java\ExcelPoiAction.java

?????文件????????317??2013-12-26?20:40??struts1?poi?Excel批量導入支持xls和xlsx-源碼java\ExcelPoizForm.java

?????文件???????1039??2013-12-26?20:46??struts1?poi?Excel批量導入支持xls和xlsx-源碼java\poiExcelDemo.jsp

?????文件????????734??2013-12-26?21:29??struts1?poi?Excel批量導入支持xls和xlsx-源碼java\struts-config.xml

?????目錄??????????0??2013-12-26?21:19??struts1?poi?Excel批量導入支持xls和xlsx-源碼java\包

?????目錄??????????0??2013-12-26?21:29??struts1?poi?Excel批量導入支持xls和xlsx-源碼java

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

?????????????????4267????????????????????6