如图:读取 第 8 行的 第二列出现错误
代码如下:
XSSFWorkbook xwb = new XSSFWorkbook(filePanel);
// 读取第一章表格内容
for (Iterator iter = xwb.iterator(); iter.hasNext();) {
// XSSFSheet str = (XSSFSheet)iter.next();
XSSFSheet str = xwb.getSheet("(总体)");
String name = str.getSheetName();
System.out.println(name);
XSSFRow row;
for (int i = str.getFirstRowNum() + 2; i < str
.getPhysicalNumberOfRows(); i++) {
row = str.getRow(i);
rownum = row.getRowNum();
System.out.println(row.getCell(0).toString());
if(null == row.getCell(0).toString()||"".equals(row.getCell(0).toString())){
continue;
}else if(rownum == 2){
date = row.getCell(1).toString();
}else if(rownum >= 7){
for (int j = 3; j < row.getPhysicalNumberOfCells(); j++) {
// 通过row.getCell(j).toString() 获取单元格内容,
String tmp = row.getCell(j+1).toString();
System.out.println(tmp);
}
}
}
System.out.println(str);