Excel 数据如下
E9 ([8:4]) =1;
E12([11:4]) =4
H12([11:7]) = 43
System.out.println("getFirstRowNum: "+ sheet.getFirstRowNum());
System.out.println("getLastRowNum: "+ sheet.getLastRowNum());
int rowCount = sheet.getLastRowNum()-sheet.getFirstRowNum();
System.out.println("rowCount: "+ rowCount);
Row Row=sheet.getRow(sheet.getLastRowNum());
System.out.println("getFirstCellNum: "+Row.getFirstCellNum());
System.out.println("getLastCellNum: "+Row.getLastCellNum());
int cellCount=Row.getLastCellNum()-Row.getFirstCellNum();
System.out.println("cellCount:"+cellCount);
输出如下:
E9 ([8:4])
E12([11:4]) =4
H12([11:7]) = 43
可以看出
E9 ([8:4]) 、E12([11:4])
getFirstRowNum: 8 起始是0
getLastRowNum: 11 起始是0
int rowCount = sheet.getLastRowNum()-sheet.getFirstRowNum();
rowCount 是3, row总数等于 sheet.getLastRowNum()-sheet.getFirstRowNum()+1
E12([11:4]) 、H12([11:7])
getFirstCellNum: 4 起始是0
getLastRowNum: 9 起始是1
int cellCount=Row.getLastCellNum()-Row.getFirstCellNum();
cellCount是4,Cell总数等于Row.getLastCellNum()-Row.getFirstCellNum()