目录结构:
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简单实例代码就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持武林网。,也希望大家多多支持武林网。