<%@ 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();
%>