java web excel 控件_Java web的读取Excel简单Demo

目录结构：

Data.xls数据:

后台页面：

GetExcelData.java

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

//System.out.println(this.getServletContext().getRealPath ("/"));

try{

Workbook wb = Workbook.getWorkbook(

new File(this.getServletContext().getRealPath ("/")+"data.xls"));

System.out.println("2222222");

List data = new ArrayList();

for(int i=1;i

Cell[] cell = wb.getSheet(0).getRow(i);

data.add(new Data(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").forward(request, response);

}catch(Exception e){

e.printStackTrace();

}

}

Data.java

public class Data {

private String id;

private String name;

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 = password;

}

public String getId() {

return id;

}

----------

前台页面：

Index.jsp:

List data = new ArrayList();

data=(List)request.getAttribute("data");

if(data!=null&&data.size()>0)

for(Data d:data){

out.println(d.getId()+"---"+d.getName()+"---"+d.getPassword());

}

%>

运行结果：