有用过java Excel？帮忙看下程序 ....

chg2008 2005-12-16 04:29:33

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;
import jxl.Cell;
import jxl.CellType;
import jxl.LabelCell;
import jxl.Sheet;
import jxl.Workbook;

/*
* 创建日期 2005-12-16

*/
/**
* @author Administrator
*
* TODO 要更改此生成的类型注释的模板，请转至窗口－首选项－ Java －代码样式－代码模板
*/
public class ExcelHandle {
public static InputStream is;
public ExcelHandle() {
}
/**
* 读取Excel
*
* @param filePath
*/
public void readExcel(String filePath) {

try {
is = new FileInputStream(filePath);
}
catch (FileNotFoundException e) {

System.out.println("file :" + filePath + " not Found！");
}
try {
Workbook rwb = Workbook.getWorkbook(is); //创建一个工作簿

//Sheet st = rwb.getSheet("0")这里有两种方法获取sheet表,1为名字，而为下标，从0开始
Sheet st = rwb.getSheet("0");

//cell是指excel的单元格
Cell c00 = st.getCell(1,1); //老提示这行有NullPointerException

//通用的获取cell值的方式,返回字符串
String strc00 = c00.getContents();

//输出
System.out.println(strc00);
// }
//关闭
rwb.close();
}
catch (Exception e) {
e.printStackTrace();
System.out.println(e.getLocalizedMessage());
}
}

public static void main(String[] args) {

ExcelHandle eh = new ExcelHandle();
try {
eh.readExcel("f:/name.xls");
}
catch (Exception e){
e.printStackTrace();
}
}
}

?/?//
输出：
java.lang.NullPointerException
at ExcelHandle.readExcel(ExcelHandle.java:51)
at ExcelHandle.main(ExcelHandle.java:76)

但是51行是去（1，1）格的值，excel文件中有内容啊

...全文