Java web的读取Excel简单实例代码

时间：2020-12-18 02:00:53|栏目：JAVA代码|点击：次

目录结构：

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>

运行结果：

上一篇：Java Object toString方法原理解析

栏目：JAVA代码

下一篇：基于Spring Batch向Elasticsearch批量导入数据示例

本文标题：Java web的读取Excel简单实例代码

本文地址：http://www.codeinn.net/misctech/34086.html

更多JAVA代码

JAVA代码

Java web的读取Excel简单实例代码

阅读排行

推荐教程