目录结构 :
Data.xls 数据:
后台页面 :
public void doGet (permintaan httpservletrequest, respons httpservletResponse) melempar servletException, ioException {//system.out.println(this.getSerVletContext().getRealPath ("/")); coba {workbook wb = workbook.getWorkbook (file baru (this.getSerVletContext (). getRealPath ("/")+"Data.xls")); System.out.println ("2222222"); Daftar <Data> Data = Daftar ArrayList baru <Data> (); untuk (int i = 1; i <wb.getsheet (0) .getRows (); i ++) {cell [] cell = wb.getsheet (0) .getRow (i); data.add (data baru (sel [0] .getContents (), sel [1] .getContents (), sel [2] .getContents ())); System.out.println (sel [1] .getContents ()); } wb.close (); request.setAttribute ("data", data); request.getRequestDispatcher ("../ index.jsp"). Forward (Request, Response); } catch (Exception e) {E.PrintStackTrace (); }} Data.java
data kelas publik {private string ID; nama string pribadi; kata sandi string pribadi; data publik () {super (); // TODO Stub Konstruktor yang Dihasilkan Otomatis} Data Publik (ID String, Nama String, Kata Sandi String) {Super (); this.id = id; this.name = name; this.password = kata sandi; } public String getId () {return id; }前台页面 :
Index.jsp:
<body> <Form Action = "Servlet/GetExcelData" Method = "Post"> <input type = "kirim" id = "tijiao" value = "kirim"> </form> <% daftar <date> Data = Daftar Arraylist baru <data> (); data = (Daftar <Data>) request.getAttribute ("Data"); if (data! = null && data.size ()> 0) untuk (data d: data) {out.println (d.getId ()+"---"+d.getname ()+"---"+d.getPassword ()); } %> </body>运行结果 :
以上这篇 Java Web 的读取 Excel 简单实例代码就是小编分享给大家的全部内容了 , 希望能给大家一个参考 , 也希望大家多多支持武林网。