java 读excel

import jxl.*;
import java.io.*;
import jxl.write.*;

/**读取Excel文件的内容 * @param file 待读取的文件 * @return */ public static String readExcel(File file) { StringBuffer sb = new StringBuffer(); System.out.println("===读==="); Workbook wb = null; System.out.println("===1==="); try { System.out.println("===2==="); //构造Workbook（工作薄）对象 wb = Workbook.getWorkbook(file); System.out.println("===3==="); if (wb == null) { System.out.println("===null退出==="); return null; } //获得了Workbook对象之后，就可以通过它得到Sheet（工作表）对象了 Sheet[] sheet = wb.getSheets(); if (sheet == null) { return "sheet == null"; } if (sheet.length < 1) { return "sheet.length <1"; } System.out.println("sheet.length=" + sheet.length); //对每个工作表进行循环 for (int i = 0; i < sheet.length; i++) { //得到当前工作表的行数 int rowNum = sheet[i].getRows(); for (int j = 0; j < rowNum; j++) { //得到当前行的所有单元格 Cell[] cells = sheet[i].getRow(j); if (cells != null && cells.length > 0) { //对每个单元格进行循环 for (int k = 0; k < cells.length; k++) { //读取当前单元格的值 String cellValue = cells[k].getContents(); System.out.println("I=" + i + ",J=" + j + ",K=" + k + ",Values=" + cellValue); sb.append(cellValue + "/t"); } } sb.append("/r/n"); } sb.append("/r/n"); } } finally { //最后关闭资源，释放内存 wb.close(); return sb.toString(); } }

//调用 by gisoracle

 File file = new File("e://Dept.XLS");
    System.out.print(readExcel(file));