目录结构 :
Data.xls 数据:
后台页面 :
Public void doget (httpservletRequest solicitud, respuesta httpservletResponse) arroja servletException, ioexception {//system.out.println(this.getServletContext().getRealpath ("/")); Pruebe {Workbook wb = workbook.getworkbook (nuevo archivo (this.getServletContext (). GetRealPath ("/")+"Data.xls")); System.out.println ("22222222"); List <sates> data = new ArrayList <Data> (); for (int i = 1; i <wb.getSheet (0) .getrows (); i ++) {celular [] celular = wb.getSheet (0) .getrow (i); data.Add (nuevos datos (celda [0] .getContents (), celda [1] .getContents (), celda [2] .getContents ())); System.out.println (celular [1] .getContents ()); } wb.close (); request.setAttribute ("datos", datos); request.getRequestDIsPatcher ("../ index.jsp"). Forward (solicitud, respuesta); } catch (Exception e) {E.PrintStackTrace (); }} Data.java
Datos de clase pública {ID de cadena privada; nombre de cadena privada; contraseña de cadena privada; data public () {super (); // TODO Generated Constructor Stub} Public Data (ID de cadena, nombre de cadena, String Passwase) {super (); this.id = id; this.name = name; this.password = contraseña; } public String getId () {return id; }前台页面 :
Index.jsp:
<Body> <Form Action = "Servlet/GetExcelData" Method = "Post"> <input type = "Subt" id = "Tijiao" valor = "enviar"> </form> <% list <sats> data = new ArrayList <Data> (); data = (list <sates>) request.getAttribute ("data"); if (data! = null && data.size ()> 0) para (data d: data) {out.println (d.getid ()+"---"+d.getName ()+"---"+d.getPassword ()); } %> </body>运行结果 :
以上这篇 Java Web 的读取 Excel 简单实例代码就是小编分享给大家的全部内容了 , 希望能给大家一个参考 也希望大家多多支持武林网。