目錄結構:
data.xls數據:
後台頁面:
public void doget(httpservletrequest請求,httpservletresponse響應)拋出了servletexception,ioexception {//system.out.ut.println(嘗試{Workbook wb = Workbook.getWorkBook(new File(this.getServletContext()。getRealPath(“ /")+"proldata.xls”)); system.out.println(“ 2222222”); List <Data> data = new ArrayList <Data>(); for(int i = 1; i <wb.getSheet(0).getrows(); i ++){cell [] cell = wb.getSheet(0).getrow(i); data.Add(新數據(Cell [0] .getContents(),單元格[1] .getContents(),cell [2] .getContents())); system.out.println(cell [1] .getContents()); } wb.close(); request.setAttribute(“數據”,數據); request.getRequestDisPatcher(“ ../ index.jsp”)。forward(請求,響應); } catch(異常E){e.printstacktrace(); }}} data.java
公共類數據{私有字符串ID;私有字符串名稱;私人字符串密碼;公共數據(){super(); // TODO自動生成的構造函數stub}公共數據(字符串ID,字符串名稱,字符串密碼){super(); this.id = id; this.name = name; this.password =密碼; } public String getId(){返回ID; }前台頁面:
index.jsp:
<body> <form Action =“ Servlet/getExceldata”方法=“ post”> <input type =“ submit” data =(list <data>)request.getAttribute(“ data”); if(data!= null && data.size()> 0)for(data D:data){out.println(d.GetId()+“ ---”+d.GetName()+d.getName()+“ ----”+d.getPassword()); }%> </body>運行結果:
以上這篇java web的讀取excel簡單實例代碼就是小編分享給大家的全部內容了,希望能給大家一個參考,也希望大家多多支持武林網。 ,也希望大家多多支持武林網。