一個應(yīng)用
<%@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();
%>
另一個實現(xiàn):
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);