jakarta-poi无法读取已存在数据的Excel文件的数据!!!!!

[newman0708]

我发现用jakarta-poi读取已存在数据的Excel文件时，无法读取指定单元格的数据。
一定要在当前像创建的单元格如r=sheet.createRow(i);这样，才能用getRow(0);访问。
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet =wb.createSheet("ChartSheet");
wb.setSheetName(0,"SimpleChartTest");
HSSFRow r = null;
HSSFCell c = null;
r=sheet.getRow(0);
c=r.getCell((short)0);
System.out.println("1,0: "+c.getStringCellValue());
FileOutputStream out = new FileOutputStream("SimpleChart.xls");
wb.write(out);
out.close();

能帮忙解决一下这个问题!

[xhongyang]

up

[newman0708]

已结帖,谢谢各位参与

[sl816]

FileInputStream fis = new FileInputStream(filename);
HSSFWorkbook wb = new HSSFWorkbook(fis);
HSSFSheet sheet = wb.getSheet("SheetName");
// or HSSFSheet sheet = wb.getSheetAt(sheetIndex);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell((short)0);
String s = cell.getStringCellValue();
// or Double d = cell.getNumericCellValue();
// or ....