通过jsp jxl读取excel

最新推荐文章于 2026-04-25 10:11:15 发布

原创最新推荐文章于 2026-04-25 10:11:15 发布 · 575 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#jsp #string #import #html #scroll

本文展示了一个使用Java读取Excel文件中特定Sheet并逐行打印单元格内容的例子。通过jxl库操作Excel表格，从指定路径加载文件，并遍历所有行的前三列数据。

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="java.io.*" %>
<%@ page import="jxl.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>


    <title>My JSP 'index2.jsp' starting page</title>


</head>

<body>

    <%
// String url = "jdbc:mysql://localhost:3306/logistics?user=root&password=123&useUnicode=true&characterEncoding=GB2312";
//Class.forName("com.mysql.jdbc.Driver").newInstance();
// Connection conn= DriverManager.getConnection(url);
// Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

        // InputStream is = new FileInputStream("C:/Program Files/Apache Software Foundation/Tomcat 5.5/webapps/test.xls");
     // jxl.Workbook book = Workbook.getWorkbook(is);
      //String[][] cellArray = new String[2][2];

   Workbook book = Workbook.getWorkbook(new File("D:/testrename.xls"));
   //Workbook book = Workbook.getWorkbook(new File("C:/Program Files/Apache Software Foundation/Tomcat 5.5/webapps/test.xls"));
   Sheet sheet = (Sheet)book.getSheet(0);
   //Cell cell1 = sheet.getCell(0,0);
   Cell c0;
   Cell c1;
   Cell c2;
   for(int i=0;i<sheet.getRows();i++){

     c0=sheet.getCell(0,i);
     c1=sheet.getCell(1,i);
     c2=sheet.getCell(2,i);

     String result[] = new String[3];

     result[0]=c0.getContents();
     result[1]=c1.getContents();
     result[2]=c2.getContents();

     out.println(result[0]);
     out.println(result[1]);
     out.println(result[2]);

    //for(int j=0;j<sheet.getColumns();j++){
     //c= sheet.getCell(j,i);
           //String result = c.getContents();
     //out.println(sheet.getCell(j,i).getContents());
     // cellArray[j][i]=sheet.getCell(j,i).getContents();
      //out.println(cellArray[j][i]);

    //}
   }

  // for(int i=0;i<sheet.getRows();i++){
   // for(int j=0;j<sheet.getColumns();j++){
    //    out.println(cellArray[j][i]);
    //}
   //}
   //String result = cell1.getContents();
   //out.println(result);
   book.close();
     %>

</body>
</html>