<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*,java.text.*" %>
< %@page import="jxl.*,java.io.*"%><%
Workbook workbook = null;
Sheet sheet = null;
Cell cell = null;
try{
workbook = Workbook.getWorkbook(new File("D:\\work\\workspace\\dazhong\\WebRoot\\a.xls"));
}catch (Exception e) {
out.println("无法打开");
return;
}
try{
sheet = workbook.getSheet(0);
}catch(Exception e){
out.println();
}
int columnCount=sheet.getColumns();
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){
String tTime=new SimpleDateFormat("yyyy-MM-dd").format(((DateCell)cell).getDate());
out.print(tTime);
}
else{
out.print(cell.getContents());
}
out.print("<br>");
}
out.print("<br>");
}
workbook.close();
%>