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