HSSFRow中getCell()方法使用出错
try (FileInputStream fileIn = new FileInputStream("c:\demo.xls")) {
POIFSFileSystem fs = new POIFSFileSystem(fileIn);
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
for (int k = 1; k <= sheet.getLastRowNum(); k++) {
HSSFRow row = sheet.getRow(k);
if(row !=null){
HSSFCell cell = row.getCell(1);//错误之处1
if(cell==null){
out.println("no data
");
}else{
String value =cell.getStringCellValue();
if(value.equals(templateName)){
HSSFCell srcQueryCell = row.getCell(5);//错误之处2
srcQuery=srcQueryCell.getStringCellValue().replaceAll("\r|\n","
");
HSSFCell trgQueryCell = row.getCell(6);//错误之处3
trgQuery=trgQueryCell.getStringCellValue().replaceAll("\r|\n","
");
out.println(srcQuery+"
");
}
}
}
}
}
在运行时提示The method getCell(short) in the type HSSFRow is not applicable for the arguments (int),有哪位看看具体问题出在那里?