jxl 导入 Excel

package com.hh.utils;

import java.io.*;
import com.hh.framework.model.DynamicModel;
import com.hh.framework.model.ModelArrayList;
import com.hh.framework.model.ModelList;


import jxl.*;
/*
 * jxl import
 */
public class importExcel {
	
	public static void main(String args[]) {
		getworkbookList("D:/666.xls");

}
	
	public static ModelList getworkbookList(String path)
	{
		ModelList list = new ModelArrayList();
		InputStream is=null;
		jxl.Workbook rwb =null;
		try
		{
		
		//构建Workbook对象, 只读Workbook对象
		//直接从本地文件创建Workbook
		//从输入流创建Workbook
		      is= new FileInputStream(path);
		      rwb= Workbook.getWorkbook(is);
		     Sheet rs = (Sheet) rwb.getSheet(0); 
		     System.out.println("rows="+rs.getRows()+"**************columns="+rs.getColumns());
		     for(int i=0;i<rs.getRows();i++){
		    	 DynamicModel model =new DynamicModel();
		    	 for(int j=0;j<rs.getColumns();j++){
		    	Cell cell = ((jxl.Sheet) rs).getCell(j,i);
		    	String str = cell.getContents();
//		    	model.addParam(namelist.get(j).toString(), str);//动态model绑定名字和值
		    	model.addParam("NAME"+j, str);
		    	 }
		    	 list.addModel(model);
		     }		     		   
		}catch (Exception e) {

			e.printStackTrace();
		}
		finally {
			try {
			     rwb.close();
			     is.close();
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		return list;
	}
}

 以上会返回一个List.

 <f:dataTable>
	            <f:html><div></f:html>
					<f:outputText value="Please select the imported file" />
				<f:html></div></f:html>
	            <input class="input_text" type="file" name="TheFile" value="" size="50">         
		        <f:tableFooter>
		            <f:commandButton value="Import Excel" event="import" validate="false"/>
		        </f:tableFooter>               
		    </f:dataTable>

 

	<SCRIPT LANGUAGE="JavaScript">
<!--     
			var el = document.getElementById('showDiv');
			
			var fn = function(){
		      el.style.display = "none";
			}
			window.setTimeout("fn()",10000);
	
//-->
</SCRIPT>

 

错误信息的提示，然后消失。