Java web的讀取Excel簡單實例代碼

2019-11-26 14:15:06

字體：大中小

來源：轉載

供稿：網友

目錄結構：

Data.xls數據:

后臺頁面：

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> data = new ArrayList<Data>();       for(int i=1;i<wb.getSheet(0).getRows();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:

<body> <form action="servlet/getExcelData" method="post"> <input type="submit" id="tijiao" value="submit"> </form> <%   List<Data> data = new ArrayList<Data>();   data=(List<Data>)request.getAttribute("data");   if(data!=null&&data.size()>0)   for(Data d:data){     out.println(d.getId()+"---"+d.getName()+"---"+d.getPassword());   }   %> </body>

運行結果：