JSP读取EXCEL文件

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

%>