java 读取跨列的excel数据

[joe_qw]

如图：读取 第 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);