目录结构 ：
Data.xls 数据:
后台页面 ：
public void Doget (httpservletrequest, httpservletresponse response) Throws servletexception, ioexception {//system.out.println(this.getServletContext().getRealPath ("/")); Try {Workbook WB = Workbook.getWorkBook (новый файл (this.getServletContext (). getRealPath ("/")+"data.xls")); System.out.println ("22222222"); 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 (), cell [1] .getContents (), cell [2] .getContents ())); System.out.println (cell [1] .getContents ()); } wb.close (); request.setattribute ("Data", Data); request.getRequestDispatcher ("../ index.jsp"). } catch (Exception e) {e.printstackTrace (); }} Data.java
открытый класс Data {Private String ID; Приватное название строки; Private String Password; public Data () {super (); // TODO Auto Generated Constructor Stub} public Data (String Id, String name, String Password) {super (); this.id = id; this.name = name; this.password = пароль; } public String getId () {return id; }前台页面 ：
Index.jsp:
<body> <form action = "servlet/getexceldata" method = "post"> <input type = "pospent" id = "tijiao" value = "pospo"> </form> <% list <data> data = new ArrayList <Data> (); data = (list <tant>) request.getattribute ("data"); if (data! = null && data.size ()> 0) для (data d: data) {out.println (d.getid ()+"---"+d.getName ()+"---"+d.getPassword ()); } %> </body>运行结果 ：
以上这篇 Java Web 的读取 Excel 简单实例代码就是小编分享给大家的全部内容了 ， 希望能给大家一个参考 ， 也希望大家多多支持武林网。