用jxl api来实现用jsp连接excel

 

2008-09-28 17:19

一个应用

<%@page import="jxl.*,java.io.*"%>
<%
Workbook workbook = null;
Sheet sheet = null;
Cell cell = null;
try{
workbook = Workbook.getWorkbook(new File("d:\\Tomcat5.0\\webapps\\ROOT\\jxlrwtest.xls"));
}catch (Exception e) {
out.println("文件不存在!");
}
sheet = workbook.getSheet(0);
int columnCount=3;
int rowCount=sheet.getRows();
for (int i = 0; i <rowCount; i++) {
for (int j = 0; j <columnCount; j++) {
   cell=sheet.getCell(j, i);
   if(cell.getType()==CellType.NUMBER){
          out.print(((NumberCell)cell).getValue());
   }
   else if(cell.getType()==CellType.DATE){
          out.print(((DateCell)cell).getDate());
   }
   else{
          out.print(cell.getContents());
   }
   out.print("<br>");
}
out.print("<br>");
}
workbook.close();
%>

另一个实现：

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Excel Driver (*.xls)};DBQ=d:/IMEI/order/"+request.getParameter("Data_Url")+".xls","","");
sqlment = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);