通过jsp jxl读取excel

最新推荐文章于 2021-03-16 11:06:57 发布

ahwhbc

最新推荐文章于 2021-03-16 11:06:57 发布

阅读量513

点赞数

文章标签： jsp string import html scroll c

本文链接：https://blog.csdn.net/ahwhbc/article/details/6536731

版权

<%@ 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>

ahwhbc

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
通过jsp jxl读取excel

My JSP index2.jsp starting page // String url = "jdbc:mysql://localhost:3306/logistics?user=root&password=123&useUnicode=true&characterEncoding=GB2312"; //Class.forN
复制链接

扫一扫